max.spicer Wrote: > What I'd like to do, is have look at the database itself to see what > tracks have the dodgy years. Could someone suggest an easy way of > firing sql at the database? I have no problem with SQL, but no > experience of SQLite.
I've used SQLite Database Browser, which will do what you want. Nothing fancy, but it works: http://sqlitebrowser.sourceforge.net A larger list of SQLite tools can be found here: http://www.sqlite.org/cvstrac/wiki?p=SqliteTools Of course if you were to move to MySQL there are many, many more software tools available. I don't know how stable the MySQL stuff is, though... I didn't have much luck with it. Two things to keep in mind, as I've found out when poking data into the database. First, even tiny idiosyncrasies in the data can cause SlimServer to crash. Second, if you insert or update data in the database, even if perfectly valid, there's a very good chance that SlimServer's scanning will just wipe it out the next time it scans your library. Make that a 100% chance if you do a 'wipe cache' before a rescan. If you're only planning on doing SELECT queries, though, you have nothing to worry about. -- JJZolx _______________________________________________ Discuss mailing list [email protected] http://lists.slimdevices.com/lists/listinfo/discuss
