Calibre and SQL DB

testor · 02-16-2015, 03:23 PM

Hello,
I am new with the extensive use of Calibre. But after having thousands of books I decided to manage this amount with Calibre.

All books are on my Network Attached Storage (NAS) which is a Synology 214+ one.

Adding books and building the metadata.db by Calibre went well. The metadata.db is stored on the NAS as well. Anyway Calibre is a bit slow when it comes to selecting or searching titles of such amount.

Is Calibre able to store all this data in a SQL database instead in the metadata.db?

SQL db which is installed with the Synology NAS is MariaDB - an advanced MySQL DB.

Is it possible to connect Calibre to the MariaDB on the NAS?

If yes - is there a description how to do this? I am not a DB expert, but could do a step by step installation / migration.

Thank you for helping me doing this.

Thank you Kovid for this wonderful tool!!

Greetings

testor

DaltonST · 02-16-2015, 05:23 PM

Quote:

Originally Posted by testor

Is Calibre able to store all this data in a SQL database instead in the metadata.db?

The metadata.db file is a SQLite database. And, before you ask, no, you cannot use another file in lieu of metadata.db.

DaltonST

testor · 02-16-2015, 05:37 PM

Ok. Got it.
Thank you.

Quote:

Originally Posted by DaltonST

The metadata.db file is a SQLite database. And, before you ask, no, you cannot use another file in lieu of metadata.db.

DaltonST

BetterRed · 02-16-2015, 05:43 PM

Quote:

Originally Posted by testor

Hello,
I am new with the extensive use of Calibre. But after having thousands of books I decided to manage this amount with Calibre.

All books are on my Network Attached Storage (NAS) which is a Synology 214+ one.

Adding books and building the metadata.db by Calibre went well. The metadata.db is stored on the NAS as well. Anyway Calibre is a bit slow when it comes to selecting or searching titles of such amount.

DaltonST

And you ought to be aware of this ==>> I am getting errors with my calibre library on a networked drive/NAS?

Calibre is not designed to run in a networked environment. The fact that you have it working today, is not a guarantee it will continue to work into the future.

BR

testor · 02-20-2015, 11:38 AM

Thanks for the hint.

No, I didn't know about this limitations. So far Calibre and the metadata.db runs fine in my network environment. Only one PC has access to the DB.

I will read more about the Calibre Content Server.

Anyway a network solution for Calibre would be perfect.

02-16-2015, 03:23 PM	#1
testor Junior Member Posts: 6 Karma: 10 Join Date: Sep 2012 Device: iPad and Kindle	Calibre and SQL DB Hello, I am new with the extensive use of Calibre. But after having thousands of books I decided to manage this amount with Calibre. All books are on my Network Attached Storage (NAS) which is a Synology 214+ one. Adding books and building the metadata.db by Calibre went well. The metadata.db is stored on the NAS as well. Anyway Calibre is a bit slow when it comes to selecting or searching titles of such amount. Is Calibre able to store all this data in a SQL database instead in the metadata.db? SQL db which is installed with the Synology NAS is MariaDB - an advanced MySQL DB. Is it possible to connect Calibre to the MariaDB on the NAS? If yes - is there a description how to do this? I am not a DB expert, but could do a step by step installation / migration. Thank you for helping me doing this. Thank you Kovid for this wonderful tool!! Greetings testor

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Sql for making a lot of change in Calibre database	Pinguin44	Development	7	12-26-2015 08:40 AM
Using SQL against Calibre database	jjansen	Calibre	3	03-29-2010 10:14 AM
SQL Queries	iain_benson	Calibre	9	06-04-2009 06:08 PM

02-20-2015, 11:38 AM	#5
testor Junior Member Posts: 6 Karma: 10 Join Date: Sep 2012 Device: iPad and Kindle	Thanks for the hint. No, I didn't know about this limitations. So far Calibre and the metadata.db runs fine in my network environment. Only one PC has access to the DB. I will read more about the Calibre Content Server. Anyway a network solution for Calibre would be perfect.