Quote:
Originally Posted by rtiangha
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)? |
Hi rtiangha, can you tell me how compacting the database?. This may not be a necessary action, but my database has >100mb. Is it too big or is it normal?
Thanks