ZeQLplus: Terminal SQLite Database Browser

82•amadeuspagel•7mo ago

Comments

amadeuspagel•7mo ago

This is the best tool in its category that I've found. It's the only that can stream results (so you can run SELECT without LIMIT and see the first results immidiately) and display them as a table.

EDIT: Crashes often though.

deafpolygon•7mo ago

How is that best in class, then? If it crashes often, it’s not production-ready.

amadeuspagel•7mo ago

I wrote that in a burst of enthusiasm before I noted the crashes.

0cf8612b2e1e•7mo ago

If only my production tools did not crash.

ugh123•7mo ago

For development (and table browsing purposes), some crashing is acceptable (to me at least), as long as the tool overall gives me a productivity boost. Perhaps OPs use-case of streaming large sqlite files for browsing purposes is not typical.

Intralexical•7mo ago

If it crashes a lot because it's full of undefined behavior/unhandled errors, then what is it doing when it encounters those issues and doesn't crash?

zX41ZdbW•7mo ago

My SQL Playground can stream results and display them as a table: https://play.clickhouse.com/

And for a command-line client, clickhouse-client has been around since 2016.

amadeuspagel•7mo ago

Impressive, but the category I was refering to is SQLite clients.

smartmic•7mo ago

Interesting to see a tool written in V in the wild. I will try it out just for that reason.

CraigJPerry•7mo ago

The UI looks a lot like Harlequin https://github.com/tconbeer/harlequin

darkteflon•7mo ago

I really like Harlequin. Discovered it by accident when I was assessing Textual - I think they showcased it.

I can’t think of another DB TUI tool as nice. I use it mainly with DuckDB, for which I believe it was originally written (although the web notebook UI that now ships with the DuckDB binary is also nice).

Slightly OT, but PyCharm / Datagrip always feels quite flaky with DuckDB. Thanks to Harlequin, I never needed to dig into it too deeply. I only wish that DuckDB supported writes while attached (in read-only mode) from another process! Although I understand there are good reasons for not doing so.

nodesocket•7mo ago

I was looking for a simple, no bloat sqlite explorer that runs in a container and ended up deploying sqlite-web[1] in read-only mode. Very impressed, no external dependencies, works great. A CLI tool is nice, but then still have to ssh into the remote server to access the db file.

[1] https://github.com/coleifer/sqlite-web

qingcharles•7mo ago

It hasn't been updated in two years?

bomewish•7mo ago

Visidata I thought had totally nailed the tui db browser category. It’s got intuitive key bindings, lots of helpful built in functions, works on csv, and so on. Will give this one a go too.

Hello

FSD helped save my father's life during a heart attack

Show HN: Writtte – Draft and publish articles without reformatting, anywhere

Portuguese icon (FROM A CAN) makes a simple meal (Canned Fish Files) [video]

Brookhaven Lab's RHIC Concludes 25-Year Run with Final Collisions

Transcribe your aunts post cards with Gemini 3 Pro

.72% Variance Lance

ReKindle – web-based operating system designed specifically for E-ink devices

Encrypt It

NextMatch – 5-minute video speed dating to reduce ghosting

Personalizing esketamine treatment in TRD and TRBD

SpaceKit.xyz – a browser‑native VM for decentralized compute

NotebookLM: The AI that only learns from you

Show HN: An open-source starter kit for developing with Postgres and ClickHouse

Game Boy Advance d-pad capacitor measurements

South Korean crypto firm accidentally sends $44B in bitcoins to users

Apache Poison Fountain

Web.whatsapp.com appears to be having issues syncing and sending messages

Google in Your Terminal

Shannon: Claude Code for Pen Testing: #1 on Github today

Anthropic: Latest Claude model finds more than 500 vulnerabilities

Brooklyn cemetery plans human composting option, stirring interest and debate

Why the 'Strivers' Are Right

Brain Dumps as a Literary Form

Agentic Coding and the Problem of Oracles

Malicious packages for dYdX cryptocurrency exchange empties user wallets

Show HN: I built a <400ms latency voice agent that runs on a 4gb vram GTX 1650"

Penisgate erupts at Olympics; scandal exposes risks of bulking your bulge

Arcan Explained: A browser for different webs

What did we learn from the AI Village in 2025?

Hello

FSD helped save my father's life during a heart attack

Show HN: Writtte – Draft and publish articles without reformatting, anywhere

Portuguese icon (FROM A CAN) makes a simple meal (Canned Fish Files) [video]

Brookhaven Lab's RHIC Concludes 25-Year Run with Final Collisions

Transcribe your aunts post cards with Gemini 3 Pro

.72% Variance Lance

ReKindle – web-based operating system designed specifically for E-ink devices

Encrypt It

NextMatch – 5-minute video speed dating to reduce ghosting

Personalizing esketamine treatment in TRD and TRBD

SpaceKit.xyz – a browser‑native VM for decentralized compute

NotebookLM: The AI that only learns from you

Show HN: An open-source starter kit for developing with Postgres and ClickHouse

Game Boy Advance d-pad capacitor measurements

South Korean crypto firm accidentally sends $44B in bitcoins to users

Apache Poison Fountain

Web.whatsapp.com appears to be having issues syncing and sending messages

Google in Your Terminal

Shannon: Claude Code for Pen Testing: #1 on Github today

Anthropic: Latest Claude model finds more than 500 vulnerabilities

Brooklyn cemetery plans human composting option, stirring interest and debate

Why the 'Strivers' Are Right

Brain Dumps as a Literary Form

Agentic Coding and the Problem of Oracles

Malicious packages for dYdX cryptocurrency exchange empties user wallets

Show HN: I built a <400ms latency voice agent that runs on a 4gb vram GTX 1650"

Penisgate erupts at Olympics; scandal exposes risks of bulking your bulge

Arcan Explained: A browser for different webs

What did we learn from the AI Village in 2025?

ZeQLplus: Terminal SQLite Database Browser

Comments