[debexpo-devel] Sqlite lock race conditions!

Asheesh Laroia asheesh at asheesh.org
Fri Nov 12 17:10:30 CET 2010


On Thu, 11 Nov 2010, Andrey Rahmatullin wrote:

> On Thu, Nov 11, 2010 at 09:00:50AM -0500, Asheesh Laroia wrote:
>> The software is already capable of doing that -- the database engine
>> is a Pylons configuration option. We just have to create a new MySQL
>> database, then migrate the data over.
> When I migrated my small project (just 1 table, not counting
> authentication-related tables) from sqlite to mysql, I've found that
> scripts which convert sql dumps from one syntax to another can be
> incorrect ot incomplete while paster shell + pickle + SQLAlchemy-provided
> engine abstraction works, if the model doesn't need any API-breaking
> changes (and internal changes are made between dumping and loading).

I think that makes sense.

I haven't gotten any errors on this lately, but Andrey, are you perhaps 
interested in helping do this transition? (-:

If not, then I can try to make some time for it during the weekend.

-- Asheesh.

-- 
The whole world is a tuxedo and you are a pair of brown shoes.
 		-- George Gobel


More information about the debexpo-devel mailing list