Quote:
Originally Posted by unboggling
I downloaded free SQLiteStudio which seems easy enough for a (adjectives deleted) Mac user such as myself to use to get me started.
|
There are lots of SQLite GUIs out there and most will let you run SQL commands and save them. The script I gave you is how I do it via script/command line
Quote:
|
2. Re SQLite, if I want to create my own DBs, can I do it with the SQLite that's part of the calibre install, or do I need to DL another copy of SQLite, or set up something so the one instance can deal with multiple different DBs simultaneously? What solution would not interfere with calibre?
|
I don't know why you would want to set up a different DB, as that's what Calibre is for, and it provides lots of options for new fields, etc. That said, if you just want access to the data in Calibre's DB, you can use a separate SQLite access program (that's what I do with the script I posted, using sqlite3.exe) or you can issue SQL commands through Calibre's command line tools. There are sample posts on how to do that. You might want to look at some of my posts about using SQL to do searches for duplicate titles.
I'd avoid changing anything in metadata.db. You won't cause problems if you just read it for any data you want.