Re: [sqlite] Foreign Keys

2008-09-14 Thread Mihai Limbasan
Andy Allord wrote: I am new to SQLite 3 and I am wondering if there is a way to work with foreign keys and set handling to cascade? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] Gears for Mac OS X/Safari, now available

2008-09-14 Thread P Kishor
http://gears.google.com/ Strangely, it implements FTS2 for full-text search. http://code.google.com/apis/gears/api_database.html#sqlite_fts -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation

[sqlite] Foreign Keys

2008-09-14 Thread Andy Allord
I am new to SQLite 3 and I am wondering if there is a way to work with foreign keys and set handling to cascade? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] fts3 database grows

2008-09-14 Thread Holger Lembke
Hi, (Hello all, new user... refreshing my rusty sql knowledge) I have a simple table created with create virtual table ft using fts3(id, content); and store id/text-pairs with delete from ft where (id="theid"); insert into ft values ("theid", "sometext"); To test the table I have 400