Re: [sqlite] General questions from a newbe

2010-08-04 Thread Simon Slavin
On 3 Aug 2010, at 10:20pm, jeff archer wrote: > Generally, in the past I have always used normalized data but thought I read > this might not always be most efficient in SQLite. Is there any "rule of > thumb"? Generally speaking, don't worry about it. Do whatever makes your programming

[sqlite] General questions from a newbe

2010-08-04 Thread jeff archer
I'm new to SQLite but have some experience with MS SQL Server.  I am looking for a quick confirmation from expert that my planed use of SQLite is reasonable and maybe point out if there are any gotchas.  I've done some prototyping and tried most of this out but it is based on how I've done