MobileRead Forums - View Single Post

Photonoxx · 05-02-2020, 06:45 AM

Hi, I bring my words to the talk.

I own a Vivlio Touch HD plus (french name of the PB632 Touch HD 3) which probably have the very same software as PB740.

I do some test by adding manually a book in a bookshelf, and check which db is impacted.

In did, it seems the concerned db is /system/explorer-3/explorer-3.db

It is readable and there's two tables in this database which apparently manage the bookshelves.

the first one :"bookshelfs", for managing the bookshelves themselves id, name of the shelf, is_deleted et timestamp (i copy the create command here)
CREATE TABLE bookshelfs( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, is_deleted INTEGER, ts INTEGER, UNIQUE(name) ON CONFLICT FAIL)

And the second one, "bookshelfs_books", which links books to their bookshelf
CREATE TABLE bookshelfs_books( bookshelfid INTEGER, bookid INTEGER, ts INTEGER, is_deleted INTEGER, PRIMARY KEY(bookshelfid, bookid))

bookshelfid correspond to the bookshelf id attributed in the first table "bookshelfs"
bookid correspond to the books id attributed in the "books_impl" of the same database (i copy the create info for this table)

CREATE TABLE books_impl( id INTEGER PRIMARY KEY AUTOINCREMENT, ext TEXT, title TEXT, first_title_letter TEXT, author TEXT, firstauthor TEXT, first_author_letter TEXT, series TEXT, numinseries INTEGER, size INTEGER, creationtime INTEGER NOT NULL DEFAULT 0, updated INTEGER NOT NULL DEFAULT 0, date_added TEXT, ts_added INTEGER, isbn TEXT )

Sadly, I don't have coding ability (or very limited one like some PHP CSS or HTML).

So, may be these informations could give some materials to developers.

I could make some test if any and hope it could help.

05-02-2020, 06:45 AM	#10
Photonoxx Junior Member Posts: 3 Karma: 10 Join Date: May 2020 Device: Vivlio Touch HD plus=PocketBook touch HD 3=P632	Hi, I bring my words to the talk. I own a Vivlio Touch HD plus (french name of the PB632 Touch HD 3) which probably have the very same software as PB740. I do some test by adding manually a book in a bookshelf, and check which db is impacted. In did, it seems the concerned db is /system/explorer-3/explorer-3.db It is readable and there's two tables in this database which apparently manage the bookshelves. the first one :"bookshelfs", for managing the bookshelves themselves id, name of the shelf, is_deleted et timestamp (i copy the create command here) CREATE TABLE bookshelfs( id INTEGER PRIMARY KEY AUTOINCREMENT, name TEXT, is_deleted INTEGER, ts INTEGER, UNIQUE(name) ON CONFLICT FAIL) And the second one, "bookshelfs_books", which links books to their bookshelf CREATE TABLE bookshelfs_books( bookshelfid INTEGER, bookid INTEGER, ts INTEGER, is_deleted INTEGER, PRIMARY KEY(bookshelfid, bookid)) bookshelfid correspond to the bookshelf id attributed in the first table "bookshelfs" bookid correspond to the books id attributed in the "books_impl" of the same database (i copy the create info for this table) CREATE TABLE books_impl( id INTEGER PRIMARY KEY AUTOINCREMENT, ext TEXT, title TEXT, first_title_letter TEXT, author TEXT, firstauthor TEXT, first_author_letter TEXT, series TEXT, numinseries INTEGER, size INTEGER, creationtime INTEGER NOT NULL DEFAULT 0, updated INTEGER NOT NULL DEFAULT 0, date_added TEXT, ts_added INTEGER, isbn TEXT ) Sadly, I don't have coding ability (or very limited one like some PHP CSS or HTML). So, may be these informations could give some materials to developers. I could make some test if any and hope it could help.