Re: [sqlite] multiple tables within a database

2008-12-01 Thread Darren Duncan
Loosely speaking, I put things together in the same file if some of those things are necessary to understand or interpret the other things, or if there is a logical dependency between things (say, a foreign key), they go in the same file. Being in one file ensures that all the interdependent

[sqlite] multiple tables within a database

2008-12-01 Thread Eric S. Johansson
what's the general rule for deciding when to put multiple tables within a single sqlite db file? I think the answer is something like you put tables together in one database file if they refer to different aspects of the same data element and you put them in separate database files if there's no