Re: SQLite module (7.7) notes

On Wed, Nov 03, 2004 at 02:25:01AM +0100, Martin Nilsson (DivX Networks) @ Pike (-) developers forum wrote:

Well, you shouldn't use it directly. But I'll guess its done enough to expose it to the Sql module. (committing to cvs...)

But multi-threading stuff is still actual - some operations take looong time (vacuum, integrity_check), even some selects may take long time (depending on number of db users, locking, transactions, OS load etc).

Mutexes for every connection (sqlite3_open) are also necessary when threads are active ("It is never safe to use the same sqlite structure pointer simultaneously in two or more threads." - even when compiled with THREADSAFE).

I can do this, if you don't have time :)

Regards, /Al