[android-developers] Re: SQlite and Foreign Keys

2008-12-22 Thread Justin Collum
You can add faked foreign keys to SQLite with triggers (google it). But you'll take a performance hit for it. Still, orphan records blow. It's a tossup. On Mon, Dec 22, 2008 at 7:35 AM, Mark Murphy wrote: > > gsk wrote: > > I am trying to join two tables in the Android SQlite DB but looks > > li

[android-developers] Re: SQlite and Foreign Keys

2008-12-22 Thread Mark Murphy
gsk wrote: > I am trying to join two tables in the Android SQlite DB but looks > like SQlite does not support foreign key relationships. http://www.sqlite.org/syntaxdiagrams.html#table-constraint > I am sure other people must be using multiple tables in their > Android app, how do you join th