MobileRead Forums - View Single Post

rtiangha · 03-03-2020, 12:18 AM

OK, quick question about the database changes for compatibility with the new Series tab.

I sideload everything (even the stuff I buy from Kobo; drm removed, of course) so no need for me to generate a UUID or anything like that, but for various reasons, it'd be easier and faster for me just to copy the database file off my Kobo and run the SQL directly on my computer and then copy it back rather than do it through usb (2.35 GB file, 13,000 books (blame gutenberg), etc, plus I want to compact the database after and that definitely is faster if I do it locally).

I haven't installed the new firmware yet so I can't inspect the database to see what changed, but am I correct to assume that it'd be just as simple as copying over all of the data from the 'Series' column to whatever the new column is (looking at geek1011's seriesmeta commit, is it called SeriesID?) and that's it, or is there more to it than that (sorry if the question sounds dumb; I'm weak in sql)?

03-03-2020, 12:18 AM	#25
rtiangha Evangelist Posts: 495 Karma: 356531 Join Date: Jul 2016 Location: 'burta, Canada Device: Kobo Glo HD	OK, quick question about the database changes for compatibility with the new Series tab. I sideload everything (even the stuff I buy from Kobo; drm removed, of course) so no need for me to generate a UUID or anything like that, but for various reasons, it'd be easier and faster for me just to copy the database file off my Kobo and run the SQL directly on my computer and then copy it back rather than do it through usb (2.35 GB file, 13,000 books (blame gutenberg), etc, plus I want to compact the database after and that definitely is faster if I do it locally). I haven't installed the new firmware yet so I can't inspect the database to see what changed, but am I correct to assume that it'd be just as simple as copying over all of the data from the 'Series' column to whatever the new column is (looking at geek1011's seriesmeta commit, is it called SeriesID?) and that's it, or is there more to it than that (sorry if the question sounds dumb; I'm weak in sql)? Last edited by rtiangha; 03-03-2020 at 12:24 AM.