Re: [sqlite] Question about Referential IntegrityRE: Foreign key support

2009-02-23 Thread Yves Goergen
On 12.02.2009 06:23 CE(S)T, Roger Binns wrote: > It is true that triggers can be used to achieve referential integrity. > However you don't have to hand craft them. The front page of the wiki > links to the document explaining it: > > http://www.sqlite.org/cvstrac/wiki?p=ForeignKeyTriggers > >

Re: [sqlite] Question about Referential IntegrityRE: Foreign key support

2009-02-11 Thread Roger Binns
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yves Goergen wrote: > You can already use referential integrity with SQLite - just in a very > complicated way, using numerous handcrafted triggers. How it works is > documented somewhere in the Wiki, IIRC. It is true that triggers can be used to achi

Re: [sqlite] Question about Referential IntegrityRE: Foreign key support

2009-02-11 Thread Yves Goergen
On 09.02.2009 19:32 CE(S)T, palmer ristevski wrote: > Just wondering when/if Richard > will make SQLite having referential Integrity a priority. > Is it on the TODO list? Is it #1 or #100 on this TODO list. > Because almost all other common databases have this. > > Once it has this feature I thin

[sqlite] Question about Referential IntegrityRE: Foreign key support

2009-02-09 Thread palmer ristevski
Just wondering when/if Richard will make SQLite having referential Integrity a priority. Is it on the TODO list? Is it #1 or #100 on this TODO list. Because almost all other common databases have this. Once it has this feature I think that it will become even more popular. Signing off Great Fa