I've made a rather large change in 7.6.1 today: SQLite now runs in WAL
mode ('see here for the gory technical details'
(http://sqlite.org/wal.html)):

* Server and standalone scanner now share the same set of 3 database
files (squeezebox.db, squeezebox-persistent.db, and ArtworkCache.db).
No more copying back and forth to "-scanner" files, etc.
* "Database is locked" errors while scanning should go away.
* locking_mode=EXCLUSIVE has been removed.
* You can see and use changes in the database while the scanner is
running, the way it used to be.

Also, I found a bug in the persistent table during this work, the
'added' column was storing the file's modification timestamp instead of
the time when the file was originally added. I had to fix this in order
to get the scanner to work right for new files. Hopefully this will not
cause any issues with plugins.


-- 
andyg
------------------------------------------------------------------------
andyg's Profile: http://forums.slimdevices.com/member.php?userid=3292
View this thread: http://forums.slimdevices.com/showthread.php?t=89450

_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta

Reply via email to