Hello,
We (XMMS2 Team) have been using SQLite for quite some time now, it's used to cache metainformation about songs played. It can also be used to be searched and store addtional information. SQLite fits us very well and have been a good complement to xmms2.
My primary platform is MacOSX and when we recently switched to sqlite 3.2.1 from sqlite 2.8.x I've started to note strange problems.
First of all performance is TERRIBLE, without syncronous=off I see insert times of up to 1 second for one row?!
Secondly after holding the DB open and not sending any querys to it for quite some time (3-4 hours) I often get a corrupted database (error from SQLite is "database file is damaged or encrypted").
The performance problems has also been spotted by another macosx user.
My sqlite installation is vanilla complied from source with macosx shipped gcc.
Anyone expericing the same?
Greetings Tobias
