MobileRead Forums - View Single Post

davidfor · 03-27-2015, 06:21 AM

Sorry, neither of those is practical. The KoboReader.sqlite file is a database. It contains the details of all the books on your device and is used for all the functions that show details of the book on the device. So, if I gave you a copy of my database, it would have the details of all my books in it. When you replaced yours, the device would see that the books on the device didn't match those in the database and process all of your books. This would include removing the details of my books.

After this, the reading status, bookmarks and the collections your books were in would be lost. And you would still have my collections, just with no books in them. To me, these things are a lot more important than the stats.

I'm not sure what the state the stats would be in. The stats are stored in a table in the database called "Events". Well, it actually stores events that happen, but this includes an event for each time you finish a book. And one of the events records the time spent reading a book. When my books are deleted from the database, some of the events are removed. I haven't looked at this enough to know whether the events needed for the stats are left in the database or not.

The second option is to create the stats. This would be done by creating events in the Events table. That is easy. Or it would be if I know how to create the data needed. I know which event records finishing a book, EventType=5. But, I don't know how to create all the data in it. There are two columns, in the table that I don't know how to populate. And I have tried a couple of things, and it didn't work.

There has been some discussion on this over the last couple of years. So far, I haven't heard of anyone having any luck with doing this.

03-27-2015, 06:21 AM	#2
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Sorry, neither of those is practical. The KoboReader.sqlite file is a database. It contains the details of all the books on your device and is used for all the functions that show details of the book on the device. So, if I gave you a copy of my database, it would have the details of all my books in it. When you replaced yours, the device would see that the books on the device didn't match those in the database and process all of your books. This would include removing the details of my books. After this, the reading status, bookmarks and the collections your books were in would be lost. And you would still have my collections, just with no books in them. To me, these things are a lot more important than the stats. I'm not sure what the state the stats would be in. The stats are stored in a table in the database called "Events". Well, it actually stores events that happen, but this includes an event for each time you finish a book. And one of the events records the time spent reading a book. When my books are deleted from the database, some of the events are removed. I haven't looked at this enough to know whether the events needed for the stats are left in the database or not. The second option is to create the stats. This would be done by creating events in the Events table. That is easy. Or it would be if I know how to create the data needed. I know which event records finishing a book, EventType=5. But, I don't know how to create all the data in it. There are two columns, in the table that I don't know how to populate. And I have tried a couple of things, and it didn't work. There has been some discussion on this over the last couple of years. So far, I haven't heard of anyone having any luck with doing this.