On 30.04.2010, at 18:08, Albert Santoni wrote: > database likes to go into a state where it's permanently locked. (SQLite > uses table-level locking for concurrent access IIRC.)
AFAIK its db level locking however: "A limited form of table-level locking is now also available in SQLite. If each table is stored in a separate database file, those separate files can be attached to the main database (using the ATTACH command) and the combined databases will function as one. But locks will only be acquired on individual files as needed. So if you redefine "database" to mean two or more database files, then it is entirely possible for two processes to be writing to the same database at the same time. To further support this capability, commits of transactions involving two or more ATTACHed database are now atomic." regards, Lukas DJ Suicide Dive [email protected] ------------------------------------------------------------------------------ _______________________________________________ Mixxx-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/mixxx-devel
