Database recommendations for Windows app

Dave Cook davecook at nowhere.net
Thu Jun 23 02:12:11 EDT 2005


On 2005-06-23, Peter Hansen <peter at engcorp.com> wrote:

> Your list didn't mention a few things that might be critical. 
> Referential integrity?  

You can implement it in sqlite with triggers.  I only bother with cascading
delete triggers, myself.

>Type checking?  SQLite currently supports 
> neither.  

sqlite3 has a "strict affinity" mode, but I'm not exactly sure how one sets
it.

http://www.sqlite.org/datatype3.html

Dave Cook



More information about the Python-list mailing list