Re: [sqlite] foreign keys? (sqlite3)

* Griggs, Donald <[EMAIL PROTECTED]> [0246 18:46]: > > > -Original Message- > > From: Dick Davies [mailto:[EMAIL PROTECTED] > > Sent: Tuesday, February 01, 2005 3:52 PM > > To: SQLite > > Subject: [sqlite] foreign keys? (sqlite3) > > > >

[sqlite] foreign keys? (sqlite3)

The docs seem to say sqlite3 does'nt support foreign keys, is that correct? If so, I don't understand what ---8< # PRAGMA foreign_key_list(table-name); For each foreign key that references a column in the argument table,

Re: [sqlite] Compacting a database

* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [0212 11:12]: > > > > Is there a way to compact a database after removing data? vacuum ? -- 'One cannot make an omelette without breaking eggs -- but it is amazing how many eggs one can break without making a decent omelette.' --

Re: RE(1): RE(1): [sqlite] SQLite Advocacy

* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [0120 19:20]: > As well, what if you want to move the database to another machien to > distribute workload. > Well, our bug tracking system Swatter we did use Sqlite but we had to write > the thead syncronization layer. > In fact, it is a .nET

Re: RE(1): [sqlite] SQLite Advocacy

* Brass Tilde <[EMAIL PROTECTED]> [0121 18:21]: > > If you install MS SQL server you run a network based service that > > is vulnerable to attack. If you run Sqlite you don't run any > > service and thus are invulnerable (to network service based > > infections). > > Not relevant. No reference