Re: [sqlite] Database design preferences

2012-11-30 Thread Duquette, William H (318K)
On 11/30/12 8:34 AM, "Simon Slavin" wrote: > >On 30 Nov 2012, at 3:50pm, Staffan Tylen wrote: > >> I'm looking for both administrative and technical advice on the pros and >> cons of either creating one single database table with many columns or >>

Re: [sqlite] Database design preferences

2012-11-30 Thread Simon Slavin
On 30 Nov 2012, at 3:50pm, Staffan Tylen wrote: > I'm looking for both administrative and technical advice on the pros and > cons of either creating one single database table with many columns or > creating multiple tables with fewer but related columns to be JOINed

Re: [sqlite] Database design preferences

2012-11-30 Thread Black, Michael (IS)
...@sqlite.org] on behalf of Staffan Tylen [staffan.ty...@gmail.com] Sent: Friday, November 30, 2012 9:50 AM To: sqlite-users@sqlite.org Subject: EXT :[sqlite] Database design preferences I'm looking for both administrative and technical advice on the pros and cons of either creating one single

[sqlite] Database design preferences

2012-11-30 Thread Staffan Tylen
I'm looking for both administrative and technical advice on the pros and cons of either creating one single database table with many columns or creating multiple tables with fewer but related columns to be JOINed when needed. Assume that the data is all related 1-to-1, like name, home address,