@ dasmueller:
its frustrating to see someone that has an idea realized that idea and
decides to share his idea even when that means he has a lot more to to
than just use his thing for his own purposes and some other jump on the
train and ask for impossible or senseless things...
@pkfox:
I realized that there is some interest for an "offline collection
Dokumentation" and i decided
to re-animate my own way to solve this (cause in my private hours i am a
Linux User i cant just use your Tool)
Even without knowing exactly what your doing - i may have a tip for you
and the guys that use your Tool.
"My" way to get a offline Dokumentation of my collection just needs two
tables out of the library.db.
- contributors
- albums
I dont know which tables you use but instead of copying the whole
library.db (if someone has to cause using a headless dedicated lms
Server)
Should be simple as eg:
$lms_offline_db is my var for the filename under Windows it must be
something like %lms_offline_db%
rm is the same as del under *blows -
dont "dump" the same tables into your offline_db twice
Code:
--------------------
rm $lms_offline_db
sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump albums"|sqlite3
$lms_offline_db
sqlite3 /var/lib/squeezeboxserver/cache/library.db ".dump
contributors"|sqlite3 $lms_offline_db
--------------------
After that you end up with a smaller database file if you need to copy
that from your dedicated lms Server.
In my case the shortend library is just 2.8 MB instead of 118 MB.
Feel free to adapt this idea.
Gruss
Jan
------------------------------------------------------------------------
DJanGo's Profile: http://forums.slimdevices.com/member.php?userid=1516
View this thread: http://forums.slimdevices.com/showthread.php?t=104566
_______________________________________________
discuss mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/discuss
