Explore remote SQLite databases over SSH

Hacker News

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

Visit product View on Hacker NewsJun 23, 2022

Share card

Actual performance

12points

1comments

Made the leaderboard

Launch Intel predictions

Analyze your own launch →

Hacker NewsStrong engagement from HN community · Strong signals: ide, io · Missing: https docs, excited, just released

65%65% predicted probability of success on Hacker News, based on ML models trained on real launch data.

nativeThis product was originally launched on this platform.

AppSumoStrong fit for a featured deal · Strong signals: host · Missing: plus, platform, intuitive

51%51% predicted probability of success on AppSumo, based on ML models trained on real launch data.

Indie HackersIH features products with proven revenue · Missing: supports, reddit linkedin, podcasting

48%48% predicted probability of success on Indie Hackers, based on ML models trained on real launch data.

Product HuntUnlikely to reach the leaderboard · Missing: mac, agents, macos

44%44% predicted probability of success on Product Hunt, based on ML models trained on real launch data.

TrustMRRLess likely to generate early MRR · Strong signals: way · Missing: mobile apps, ios, personal

44%44% predicted probability of success on TrustMRR, based on ML models trained on real launch data.

Acquire.comPre-revenue stage for this audience · Missing: arr, mrr, revenue

19%19% predicted probability of success on Acquire.com, based on ML models trained on real launch data.

BetaListMay not resonate with beta-testers · Missing: web3, chat, crypto

0%0% predicted probability of success on BetaList, based on ML models trained on real launch data.

Correct prediction on native model

Similar products

Remotedotool, remote controlling graphical systems over SSH55%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Remotedotool, remote controlling graphical systems over SSH

Hacker News4

SSH for DigitalOcean63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SSH for DigitalOcean

Hacker News1

SSH for EC269%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SSH for EC2

Hacker News4

Ssh-aliases63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Ssh-aliases

Hacker News2

RabbitHole – YAML Configured SSH Tunnels61%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

RabbitHole – YAML Configured SSH Tunnels

Hacker News1

Caddy-SSH63%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Caddy-SSH

Hacker News280

Crowdsourced Databases and Sui Generis Rights44%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Crowdsourced Databases and Sui Generis Rights

Hacker News2

Crowdsourced Databases and Sui Generis Rights52%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Crowdsourced Databases and Sui Generis Rights

Hacker News1

ShellYard21%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

SSH, RDP, APIs, and databases in one desktop app.

Indie Hackers

Noauth SSH server for remote port forwarding; like ngrok, but using SSH60%Launch Intel prediction score: how likely this product is to succeed on its source platform, based on its name, tagline, and description.

Noauth SSH server for remote port forwarding; like ngrok, but using SSH

Hacker News6

Browse all products Analyze your launch