07-19-2024, 12:12 PM | #1 |
Evangelist
Posts: 448
Karma: 41524
Join Date: Sep 2011
Device: Kobo Libra 2 & Clara BW
|
Reading Calibre DB
I'd like to read the Calibre DB from a python program.
I can get a list of my books with: Code:
import sqlite3 fname = "c:/Calibre Library/metadata.db" con = sqlite3.connect(fname) cur = con.cursor() cur.execute("SELECT * from books") for item in cur.fetchall(): print(item) con.close() Here's a typical output from the above: (3025, 'A Short History of the Italian Renaissance', 'Short History of the Italian Renaissance, A', '2024-07-06 20:20:52.809814+00:00', '2015-07-15 04:00:00+00:00', 1.0, 'Bartlett, Kenneth R.', '', '', 'Kenneth R. Bartlett/A Short History of the Italian Rena (3025)', 1, '1e6fc84c-3ab1-459b-810f-543895ac556c', 1, '2024-07-17 01:30:42.096682+00:00') This seems to be: index, title, title_sort, date_imported, date_published, author_sort, ???, path, ???, date_??? I'd guess this is documented somewhere obvious, but my search skills are failing to find the specific location. |
07-19-2024, 12:31 PM | #2 |
creator of calibre
Posts: 44,542
Karma: 24495948
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
|
Advert | |
|
07-19-2024, 01:09 PM | #3 | |
Evangelist
Posts: 448
Karma: 41524
Join Date: Sep 2011
Device: Kobo Libra 2 & Clara BW
|
Quote:
It appears that I have to install the Calibre source and study and use its API? Thank you for a fabulous and tremendously useful program! |
|
07-19-2024, 01:17 PM | #4 |
creator of calibre
Posts: 44,542
Karma: 24495948
Join Date: Oct 2006
Location: Mumbai, India
Device: Various
|
You dont access it using sqlite. Use the calibre API. it is documented, yes you will need to read some documentation and install calibre.
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Reading and printing with Calibre | balubeto | Calibre | 8 | 03-11-2018 02:25 PM |
Calibre not reading Kindle | lovingthereading | Devices | 0 | 05-12-2016 12:28 PM |
Problems Reading Some Calibre Library Books Using Calibre Companion | eurasiarc | Calibre Companion | 17 | 09-28-2013 03:45 PM |
Calibre not reading second library | Ladyhenry | Library Management | 1 | 02-17-2013 09:29 PM |