sqlite-web

I was looking for a simple, no bloat sqlite explorer that runs in a container and ended up deploying sqlite-web[1] in read-only mode. Very impressed, no external dependencies, works great. A CLI tool is nice, but then still have to ssh into the remote server to access the db file. [1] https://github.com/coleifer/sqlite-web

Hi, author of litexplore here! I agree remote management is the "least convenient" aspect of SQLite. If you have control over the remote VM where the DB is hosted, you can also run something like ClouDBeaver[0], Datasette[1] or sqlite-web[2] as a Docker container, then connect to it from your laptop. The reason I wrote litexplore was that those approaches require exposing extra ports, managing authentication, etc. With litexplore, you just need the sqlite3 CLI (compiled with the JSON1 extension) installed in the VM and a way to access it over SSH. litexplore is still in early stages and I have some updates planned in the following 2 months, but the basics are working. [0]: https://github.com/dbeaver/cloudbeaver [1]: https://datasette.io/ [2]: https://github.com/coleifer/sqlite-web

> These kinds of dismissive comments make me wonder if the writer ever created anything of substance in their life. Ad hominem [0]. And he has. I use the things he has built in production. He has contributed to Python community (and SQLite) to a great extent. Some of the amazing things he built [1], [2], [3]. [0] - https://yourlogicalfallacyis.com/ad-hominem [1] - https://github.com/coleifer/peewee [2] - https://github.com/coleifer/huey [3] - https://github.com/coleifer/sqlite-web

The immutable thing is pretty key to the whole project - if you do need a writable API there are a few options out there already though. https://github.com/coleifer/sqlite-web looks particularly good.

SQLite definitely presents some unique challenges, despite it generally being the "simplest" relational database. I've written a web-based SQLite database browser, which you can find here: https://github.com/coleifer/sqlite-web -- importantly, it supports all the `ALTER TABLE` statements you'd expect (add column, drop column, rename column, etc). This is done by renaming the table temporarily, creating a new table with the desired changes, then copying the data into the new table. Kinda clunky, but it works :)

I wrote a little web based sqlite database manager: https://github.com/coleifer/sqlite-web