Re: [sqlite] normalization example(s)

On 26 Jun 2010, at 6:36am, John wrote: > On 6/25/2010 10:51 PM, Simon Slavin wrote: >> >> On 26 Jun 2010, at 3:47am, John wrote: >> >>> I don't know if SQLite now supports foreign keys yet or not. >> >> So you're posting to a mailing list you don't read ? > > I read this! ;-) Oh. Okay,

Re: [sqlite] normalization example(s)

On Sat, Jun 26, 2010 at 03:51:12AM +0100, Simon Slavin scratched on the wall: > So you're posting to a mailing list you don't read ? People replay without seeming to read all the time... -j -- Jay A. Kreibich < J A Y @ K R E I B I.C H > "Intelligence is like underwear: it is important

Re: [sqlite] normalization example(s)

On 6/25/2010 10:51 PM, Simon Slavin wrote: > > On 26 Jun 2010, at 3:47am, John wrote: > >> I don't know if SQLite now supports foreign keys yet or not. > > So you're posting to a mailing list you don't read ? I read this! ;-) Actually, I did do one project early this year with SQLite and had

Re: [sqlite] normalization example(s)

On 26 Jun 2010, at 3:47am, John wrote: > I don't know if SQLite now supports foreign keys yet or not. So you're posting to a mailing list you don't read ? Simon. ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] normalization example(s)

On 9/26/2009 10:17 PM, John wrote: > I have "The Definitive Guide to SQLite" and it has jump > started me with databases. (the index could stand a lot > of improvement though). > > I am looking for a "quick start" example of the normalization > case where one table has an index into another table

Re: [sqlite] normalization example(s)

Don't get carried away with keys, triggers and stuff like that at this point. For a start off your example is not normalised. You would have a person table and a food table but then you will need a person-food table as the relationship between person and food is many-to-many so you have to break

Re: [sqlite] normalization example(s)

On Mon, Sep 28, 2009 at 10:28 AM, John wrote: > CityDev wrote: >> You seem to be asking about four separate issues - normalisation,  table >> creation, table loading, and SQLite syntax. The thing is I've just looked at >> your book's index and I can't imagine a better source

Re: [sqlite] normalization example(s)

CityDev wrote: > You seem to be asking about four separate issues - normalisation, table > creation, table loading, and SQLite syntax. The thing is I've just looked at > your book's index and I can't imagine a better source of answers to your > questions. > > Maybe you would like to post some

Re: [sqlite] normalization example(s)

You seem to be asking about four separate issues - normalisation, table creation, table loading, and SQLite syntax. The thing is I've just looked at your book's index and I can't imagine a better source of answers to your questions. Maybe you would like to post some specific cases here? --

[sqlite] normalization example(s)

I have "The Definitive Guide to SQLite" and it has jump started me with databases. (the index could stand a lot of improvement though). I am looking for a "quick start" example of the normalization case where one table has an index into another table of unique values. The book has an example, but