[sqlalchemy] Re: foreign key support in SQLite

2008-01-28 Thread Manlio Perillo
Koen Bok ha scritto: Hey Manilo, My feeling is that this is out of the scope of the SQLAlchemy project. It should support the official workings for each database package, not extend it. Right, this should not be part of SQLAlchemy core, but maybe in a contrib package? Nobody else has

[sqlalchemy] Re: foreign key support in SQLite

2008-01-28 Thread Koen Bok
Hey Manilo, My feeling is that this is out of the scope of the SQLAlchemy project. It should support the official workings for each database package, not extend it. It is pretty easy to implement this yourself and use SQLAlchemy on top of that (I use a lot of triggers in my app). There may be

[sqlalchemy] Re: foreign key support in SQLite

2008-01-28 Thread Michael Bayer
On Jan 28, 2008, at 6:03 AM, Manlio Perillo wrote: Hi. In this wiki page: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers there is a recipe on how to add basic foreign key support to SQLite using triggers. Is it possible to implement this recipe in SQLAlchemy? Some time ago

[sqlalchemy] Re: foreign key support in SQLite

2008-01-28 Thread Manlio Perillo
Michael Bayer ha scritto: On Jan 28, 2008, at 6:03 AM, Manlio Perillo wrote: Hi. In this wiki page: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers there is a recipe on how to add basic foreign key support to SQLite using triggers. Is it possible to implement this recipe in

[sqlalchemy] Re: foreign key support in SQLite

2008-01-28 Thread jason kirtland
Manlio Perillo wrote: Michael Bayer ha scritto: On Jan 28, 2008, at 6:03 AM, Manlio Perillo wrote: Hi. In this wiki page: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers there is a recipe on how to add basic foreign key support to SQLite using triggers. Is it possible to

[sqlalchemy] Re: foreign key support in SQLite

2008-01-28 Thread Michael Bayer
On Jan 28, 2008, at 3:09 PM, Manlio Perillo wrote: Michael Bayer ha scritto: On Jan 28, 2008, at 6:03 AM, Manlio Perillo wrote: Hi. In this wiki page: http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers there is a recipe on how to add basic foreign key support to SQLite using