Building a remote SQLite explorer

https://ricardoanderegg.com/posts/sqlite-remote-explorer-gui/ · One of the main pain points of using SQLite in production deployments or VMs is managing the database. There are lots of database GUIs, but only work with local SQLite databases. Managing an SQLite database remotely requires: Adding a new service to the deployment (like Adminer, sqlite-web or postlite) Giving the new service permissions to access the volume with the database Exposing a port to access the service The alternative is usually SSH’ing to the remote VM and use the sqlite3 CLI to manage or explore the database.