Hacker News Re-Imagined

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://ricardoanderegg.com/posts/sqlite-remote-explorer-gui/

[1]: https://github.com/litements/litexplore

  • 12 points
  • 13 days ago

  • @polyrand
  • Created a post

Show HN: Explore remote SQLite databases over SSH


@khalidx 7 days

Replying to @polyrand 🎙

Nice explainer. Also your SQLite queue repository is cool. Good stuff

Reply


About Us

site design / logo © 2022 Box Piper