nowfound

Dev tools · June 23, 2022

ER

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…

Explore remote SQLite databases over SSH launched on June 23, 2022 with 12 votes, #950 of 3,005 launches that month and more than 75% of that year's launches.

In plain words

This web application allows users to explore SQLite databases on remote servers through SSH without installing additional services. It works by sending sqlite3 CLI commands over a multiplexed SSH connection and converting the JSON output into an accessible interface. The tool is designed for developers who need to query remote SQLite databases and prefer a simpler setup than traditional client-server solutions that require extra services running on the host.

written from the facts on this page · September 2026

From the sources

In the maker’s words, at launch

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…

Does a similar job

all alternatives →
  • MongoDB Protocol for SQLite2023 · github.com · ▲147

    A truly Open Source MongoDB alternative. Contribute to FerretDB/FerretDB development by creating an account on GitHub.

  • Query SQLite files stored in S32022 · github.com · ▲160

    Query SQLite files in S3 using s3fs. Contribute to litements/s3sqlite development by creating an account on GitHub.

  • I wrote a RDBMS (SQLite clone) from scratch in pure Python2023 · github.com · ▲371

    I wrote a relational database management system (RDBMS) (sqlite clone) from scratch in pure Python.

  • Bi-directional sync between Postgres and SQLite2023 · powersync.com · ▲356

    Hi HN, Today we’re launching PowerSync, a Postgres<>SQLite bi-directional sync engine that enables an offline-first app architecture. It currently supports Flutter, React Native and web (JavaScript) using Wasm SQLite in the browser, with more client SDKs on the way. Conrad and I (Ralf) have been working on our sync engine since 2009, originally as part of a full-stack app platform. That version of the system is still used in production worldwide and we’ve learnt a lot from its use cases and scaling. About a year ago we started on spinning off PowerSync as a standalone product that is…

  • SQ
    SQLite query inside a Bash function2021 · ▲134

    Part of the workflow for building my website is the generation of a table in tab-separated column format (.tsv). The source data is found in four other .tsv files. I use an SQLite query to perform a 4-way join and write out the new table. For convenience, I wrote a script that encapsulates the query inside a Bash function. The example below illustrates this technique. repertoire() { pushd $CMM_SOURCES&#x2F;_data sqlite3 <<EOS .headers on .mode tabs .import category.tsv category .import composition.tsv composition .import concert.tsv concert .import program.tsv program .once repertoire.tsv…

  • SQLSite – serve simple websites, APIs and files directly from SQLite2020 · github.com · ▲52

    NO LONGER MAINTAINED! A tool for serving simple websites, JSON APIs and static files directly from a SQLite database - j4mie/sqlsite

More dev tools this month

the category →
  • Contribute to oosexgang/hackios-xnu-kernel development by creating an account on GitHub.

    Dev tools · 1d ago · github.com

  • /dev/null▲492

    a social network for devs

    Dev tools · 4d ago · dev-null.sh

  • open-source IDE for thoughtful software design. Contribute to devdotfast/whiteboard development by creating an account on GitHub.

    Dev tools · 29d ago · github.com

  • Contribute to reladraw/reladraw development by creating an account on GitHub.

    Dev tools · 27d ago · github.com

  • OpenBot▲362

    Grok Bot alternative: free, local, open-source, multiplayer

    Dev tools · 24d ago · openbot.run

  • Talanoa▲346

    Hi HN, I’m a fullstack developer, and honestly, I’ve lost count of how many side projects I’ve worked on over the years. But one idea kept coming back to me: a different kind of email client. It first came to me in 2014: “What if we could handle emails more like conversations?” Every year, I’d revisit this concept in my “Build Notes.” Ten years later, no one had built exactly what I had in mind — so I finally decided to do it myself. That’s how Talanoa was born. I wanted something focused on people, not timelines. I was tired of marking messages as unread just to remember to reply later, or…

    Dev tools · 22d ago · talanoa.email

Source: Show HN post ↗ · launch text quoted in part

Launched alongside, June 2022

the whole month →
  • AF

    I've seen some interests in (simulation) video games here on HN so I thought I'd share a short version of our story. More than 6 years ago, me and my friend from university were playing around with an idea of making a game we always wanted to play. We worked on it on weekends but the progress was quite slow, especially due to so many dead ends and wasted effort. Eventually however, we solidified our direction and decided to take the risk to resign from our well paid SWE jobs and work on it full time. It took more than a year but yesterday we have finally released it on Steam:…

    Life & fun · 2022

  • Life & fun · 2022 · benoitessiambre.com

  • min(DALL·E) is a fast, minimal port of DALL·E Mini to PyTorch - kuprel/min-dalle

    Life & fun · 2022 · github.com

  • 1,100+ free Figma icons for modern UI design.

    Dev tools · 2022 · untitledui.com

  • MakerBox▲621

    600 tools with generous free plans for indie entrepreneurs

    Dev tools · 2022 · makerbox.club

  • Display your Notion data beautifully on your site, no-code

    Dev tools · 2022 · typedream.com