Use on-device SQL database instead of discovering files

Eiluviann · 03-14-2024, 06:28 AM

I'm using Pocketbook Era with ebook subscription service. Majority of my ebooks are DRMd (non-standard) which means that majority of the files discovered by Calibre do not have any readable metadata.

Would it be possible for Calibre to use on-device SQL database for device sync instead of discovering files? Database file is easily accessible and contains all necessary metadata, both for the DRMd ebooks as well as those without it.

kovidgoyal · 03-14-2024, 06:37 AM

Its *possible* but actually doing it would require someone with the hardware to write a driver that does it. Also DRM typically does not prevent reading metadata apart from cover image.

Eiluviann · 03-14-2024, 10:58 AM

In this case it is a service called Legimi and the EPUBs are using a proprietary DRM. They aren't even recognised as epubs by epub editors and there is no metadata attached. The metadata is stored in a separate SQL database which matches epub files with metadata. Later that database is translated into Pocketbook's database so the ebooks have covers, names etc.

03-14-2024, 06:28 AM	#1
Eiluviann Junior Member Posts: 7 Karma: 10 Join Date: Jan 2024 Device: Pocketbook Era	Use on-device SQL database instead of discovering files I'm using Pocketbook Era with ebook subscription service. Majority of my ebooks are DRMd (non-standard) which means that majority of the files discovered by Calibre do not have any readable metadata. Would it be possible for Calibre to use on-device SQL database for device sync instead of discovering files? Database file is easily accessible and contains all necessary metadata, both for the DRMd ebooks as well as those without it.

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
Aura Calibre device discovering	n0t	Kobo Reader	2	08-03-2014 01:12 AM
Calibre device discovering	n0t	Devices	1	08-02-2014 05:14 PM
What is the best way to defragment the SQL database?	JSWolf	Calibre	3	05-16-2012 08:49 AM
Using SQL against Calibre database	jjansen	Calibre	3	03-29-2010 10:14 AM

03-14-2024, 06:37 AM	#2
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	Its possible but actually doing it would require someone with the hardware to write a driver that does it. Also DRM typically does not prevent reading metadata apart from cover image.

03-14-2024, 10:58 AM	#3
Eiluviann Junior Member Posts: 7 Karma: 10 Join Date: Jan 2024 Device: Pocketbook Era	In this case it is a service called Legimi and the EPUBs are using a proprietary DRM. They aren't even recognised as epubs by epub editors and there is no metadata attached. The metadata is stored in a separate SQL database which matches epub files with metadata. Later that database is translated into Pocketbook's database so the ebooks have covers, names etc.

Advert