SQLite (was: RE: [GENERAL] Reliability of Windows versions 8.3 or 8.4)

2010-05-12 Thread Rob Richardson
I use both PostgreSQL and SQLite in my job. I have mixed feelings about SQLite. If you play by its rules, it works very well, but I think you have to understand its rules well. If you do not set up your indexes correctly and do not use transactions correctly, performance can be horrible, but if

Re: SQLite (was: RE: [GENERAL] Reliability of Windows versions 8.3 or 8.4)

2010-05-12 Thread Joshua D. Drake
On Wed, 2010-05-12 at 13:45 -0400, Rob Richardson wrote: I use both PostgreSQL and SQLite in my job. I have mixed feelings about SQLite. If you play by its rules, it works very well, but I think you have to understand its rules well. If you do not set up your indexes correctly and do not