On 24 August 2011 16:55, pof <pof.4yzenc1314201...@no-mx.forums.slimdevices.com> wrote: > > Thanks. > > So how do I change to SQLite? What are the good things about it vs > MySQL?
For the past few years, versions of the server prior to 7.6.0 used MySQL. For 7.6.0 it switched to using SQLite. You dont need to do anything to the server to change, it's all built into it. In theory SQLite requires less memory and CPU, especially with smaller libraries, so it's ideal for making the server perform better on NAS boxes, etc.. However, SQLite doesnt have network support, so to access the database from another machine you have to share the library.db file via folder sharing, etc.. Moose supports both MySQL and SQLite, it's just a case of telling it which to use and pointing it at the relevent files. In Moose all the action happens in the scanning tab of the options dialog. If you've already got Moose talking to your server and dispaying now playing information for a player, you can hit the 'guess database' button (in the scanning tab) and it'll set some of the options for you. The important thing with SQLite is to make sure the path to the database is set up correctly. The 'guess' button's value uses the server's local path to the .db file, so (on windows anyhow) you usually get something like this: c:\programdata\squeezebox\cache\library.db If your server is on a different machine to moose, you'll need to ammend this. As an example, if your server is on a remote machine with IP address 192.168.1.1 and you've shared 'c:\programdata\squeezebox\' as 'bob', you need to alter the sqlite path's value to: \\192.168.1.1\bob\cache\library.db Note that it's a good idea to share the squeezebox folder rather than the cache folder as the cache folder can get deleted when doing a clean.. Hope that helps, -- - Dr Lovegrove http://www.rusticrhino.com/drlovegrove http://groups.google.com/group/moosenews _______________________________________________ plugins mailing list plugins@lists.slimdevices.com http://lists.slimdevices.com/mailman/listinfo/plugins
