MobileRead Forums - View Single Post

a3nm · 05-28-2013, 08:23 PM

There is a command-line sqlite tool called sqlite3. First, you will need to install it to your Kobo. I haven't tested, but I would assume that you can install the one from Debian (following https://www.mobileread.com/forums/sho...12&postcount=2) along with all the packages it depends on.

Once installed, you can run sqlite3 on the KoboReader.sqlite database, passing the query(ies) that you want to run as standard input and getting the result as standard output. Here is an example:

Code:

echo 'select * from user;' | sqlite3 /mnt/onboard/.kobo/KoboReader.sqlite

I hope this helps.

05-28-2013, 08:23 PM	#2
a3nm Member Posts: 11 Karma: 204 Join Date: May 2013 Device: Kobo Glo	There is a command-line sqlite tool called sqlite3. First, you will need to install it to your Kobo. I haven't tested, but I would assume that you can install the one from Debian (following https://www.mobileread.com/forums/sho...12&postcount=2) along with all the packages it depends on. Once installed, you can run sqlite3 on the KoboReader.sqlite database, passing the query(ies) that you want to run as standard input and getting the result as standard output. Here is an example: Code: echo 'select * from user;' \| sqlite3 /mnt/onboard/.kobo/KoboReader.sqlite I hope this helps.