sqlite-viewer VS sqlite-plus

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

People should check out Nalgeon's work on SQLite extensions: https://github.com/nalgeon/sqlean.

Extra - Not sure what you are doing with the database but I came across this repo of extensions that seem pretty solid - https://github.com/nalgeon/sqlean

The simplicity of tree-navigation in "closure" is pretty amazing for how simple it is: https://github.com/nalgeon/sqlean/issues/27

Given that SQLite supports huge sizes for text, you could almost use the above as a way to create an outliner, with everything stored in the database itself ...

https://github.com/nalgeon/sqlean/blob/main/docs/define.md

I've been considering using that. Anyone have any experience with it?

Author here, happy to answer questions!

Simon already gave a great intro to my SQLite extensions, and I just want to point folks to Anton Zhiyanov's sqlean project, for pure-C extensions: https://github.com/nalgeon/sqlean

Also, some of these extensions are also packaged as Datasette plugins, so you can also run `datasette install datasette-sqlite-regex` or `datasette install datasette-sqlite-ulid` to add these extension to your Datasette instances! https://docs.datasette.io/en/stable/plugins.html

And much more! See documentation for details.