Articles

Notes on running SQLite in production.

Long-form writing about SQLite, remote database access, and the tools we build at Cloudmanic Labs.

Guide · May 22, 2026 · 9 min read

How to Browse Your Fly.io SQLite Database with a GUI (Without Downloading It)

Fly.io makes deploying SQLite trivial. Browsing it in production has been a mess of `flyctl ssh sftp get` and stale snapshots. Here's how to point TablePlus directly at your live Fly.io SQLite database over SSH — no downloads, no extra services.

Read article

Tutorial · May 17, 2026 · 11 min read

How to Connect TablePlus to a Remote SQLite Database Over SSH (2026 Guide)

TablePlus has no native support for remote SQLite. Years of open GitHub issues, no canonical answer. Here's the workflow that finally works — TablePlus pointed at a local proxy that talks to your remote SQLite file over a persistent SSH session.

Read article

Manifesto · May 15, 2026 · 6 min read

Why I Built Remote SQLite

SQLite is the best database for most web apps. The moment you deploy, you lose every GUI tool you've ever loved. Here's why I got tired of it and built the thing I wanted.

Read article