MobileRead Forums - View Single Post - LibrarianSync: Kindle collections builder

knc1 · 02-12-2018, 05:44 PM

On 5.9.2, not even the Amazon store books sort by title correctly, and that is without any collections at all.

But I have been digging into the sqlite3 database files recently (to kill the 'stuck' kual image) and I can say that they have changed considerably since the days when LibrarianSync was written.

I expect KPVBooklet to have the same or similar problems.

= = = =

Tech note:
There has not been much change over time to the cc.db database tables.
But there are (now) stored procedures in cc.db that trigger on various conditions and alter other tables in other database files.
And as usual for something from Lab126, there is no signs of a rational design approach being taken, it is one of those "just grow'd like topsy" database systems.
(db design was once upon a time my day-job | and yes, I do hope Jeff Bezos is tracking my comments by rss)

02-12-2018, 05:44 PM	#348
knc1 Going Viral Posts: 17,212 Karma: 18210809 Join Date: Feb 2012 Location: Central Texas Device: No K1, PW2, KV, KOA	On 5.9.2, not even the Amazon store books sort by title correctly, and that is without any collections at all. But I have been digging into the sqlite3 database files recently (to kill the 'stuck' kual image) and I can say that they have changed considerably since the days when LibrarianSync was written. I expect KPVBooklet to have the same or similar problems. = = = = Tech note: There has not been much change over time to the cc.db database tables. But there are (now) stored procedures in cc.db that trigger on various conditions and alter other tables in other database files. And as usual for something from Lab126, there is no signs of a rational design approach being taken, it is one of those "just grow'd like topsy" database systems. (db design was once upon a time my day-job \| and yes, I do hope Jeff Bezos is tracking my comments by rss) Last edited by knc1; 02-12-2018 at 05:55 PM.