sqlite-viewer VS rqlite

Now open the http://127.0.0.1:8000/, you will see the following output: You can also use sqlite3 command line tool or SQL Viewer tool in order to inspect changes in your database.

Just for fun, I threw the db.sqlite3 database on testing site, https://inloop.github.io/sqlite-viewer/, to see if the data is still valid and it is, I just need to redirect django to point to the local sqlite3 database.

Now have a look in that database ( https://inloop.github.io/sqlite-viewer/ ) and compare it to your external drive file paths. Maybe the drive has a different name…?

So, try using a tool that can read SQLite databases, like https://inloop.github.io/sqlite-viewer/ or https://sqlitebrowser.org/

sqlite-viewer - View SQLite file online

The History file is an SQLite database. You can see its contents on this webpage: http://inloop.github.io/sqlite-viewer/

SQLite Viewer - Online .db, .sqlite3, etc. File Viewer. Open Source. Website.

I was able to open them with this tool: https://github.com/inloop/sqlite-viewer

Seems like you could do the same with rqlite [1], since SQLite supports JSON.

[1]: https://rqlite.io

rqlite[1] creator here, happy to answer any questions about rqlite, this latest release, and how it works.

[1] https://rqlite.io

I found simple distributed RQlite https://github.com/rqlite/rqlite based on raft and sqlite. How hard is to add it?

rqlite[1] creator here, happy to answer any questions. rqlite also supports read-only nodes, which can also help with reads at the "edge". It probably wouldn't scale to 100s of nodes, it is an option.

"rqlite supports adding read-only nodes. You can use this feature to add read scalability to the cluster if you need a high volume of reads, or want to distribute copies of the data nearer to clients – but don’t want those nodes counted towards the quorum. These types of nodes are also known as non-voting nodes."

[1] https://rqlite.io/

[2] https://rqlite.io/docs/clustering/read-only-nodes/