Show HN: Explore remote SQLite databases over SSH https://ift.tt/5OvqdYB

Show HN: Explore remote SQLite databases over SSH Hi! As a big fan of SQLite, I always found the tooling to explore remote databases a bit lacking. Current solutions involve running an extra service in the remote host and exposing a port to access it. I built a small web app that can explore remote SQLite databases without having to run any service on the remote, you just need SSH. It works by sending sqlite3 CLI commands over a multiplexed SSH connection. The commands use the "-json" flag from the sqlite3 CLI. This basically turns the SSH connection into an JSON API for the remote SQLite database. The project is hosted on GitHub[0] and I wrote a blog post with more details about the project and how it works[1]. I'm still exploring multiple ideas and implementations details, but feedback is more than welcome. [0]: https://ift.tt/65KorRU [1]: https://ift.tt/UKteabR June 24, 2022 at 06:34AM