get.amped wrote: 
> Sometime a little nudge is what we need :)
> 
> I had been meaning to install and get familiar with SQLite Expert but
> have found any number of reasons not to. But when I decided to try LMS
> Extractor it was immediately obvious that I would need something to
> reveal the table structures if I wanted to do much beyond your default
> queries.
> 
> So I now am using both, SQLite Expert as a query building tool and LMS
> Extractor as an easy way to save the results in a useful format.
> 
> -<*SNIP*>-
Glad to help you get off the schneid with SQL. :)

Yes, I assumed that my handful of basic queries would be just a starter
kit, and since people use different tags and approach the organization
of their libraries differently, most people will want to go after things
in slightly different ways. The main purpose was just to give me a
quick-and-easy way to run (and re-run) canned queries and output some
standard file formats. Once I started using it I thought others might
also find it useful.

I think your combination of using SQLite Expert to build and test
queries, and LMS Extractor to save and run them, is a perfect approach.
There is a lot of information buried in the LMS database, and a little
digging will no doubt open up all kinds of possibilities. Have fun! And
thanks for letting me know you got the Extractor working.


------------------------------------------------------------------------
Dogberry2's Profile: http://forums.slimdevices.com/member.php?userid=18883
View this thread: http://forums.slimdevices.com/showthread.php?t=101600

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

Reply via email to