Thread: Recover "Modified" column values after adding new coluns in library
View Single Post
Old 07-27-2022, 04:13 PM   #9
theducks
Well trained by Cats
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 31,123
Karma: 60406498
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
Quote:
Originally Posted by John Maverick View Post
I was hoping that reading the database file, somehow, get the data I need. I suppose the database format is one custom that only Calibre can read. And Calibre will always update last-modified.

Again, a lot of thanks.
No the DB is a standard SQLlite (It IS fully relational). There are free tools to let you do stuff.
BE CAREFULL, you can muck things really bad if you are not absolutly correct.

BTW the commandline tools (calibredb.exe) can work with any LibraryDB specified and that deals with all the needed stuff.
theducks is offline   Reply With Quote