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.

OpenCiv3: Open-source, cross-platform reimagining of Civilization III

The Waymo World Model

How we made geo joins 400× faster with H3 indexes

Show HN: Look Ma, No Linux: Shell, App Installer, Vi, Cc on ESP32-S3 / BreezyBox

Monty: A minimal, secure Python interpreter written in Rust for use by AI

A century of hair samples proves leaded gas ban worked

Dark Alley Mathematics

Show HN: If you lose your memory, how to regain access to your computer?

Show HN: I spent 4 years building a UI design tool with only the features I use

Microsoft open-sources LiteBox, a security-focused library OS

Sheldon Brown's Bicycle Technical Info

Hackers (1995) Animated Experience

PC Floppy Copy Protection: Vault Prolok

An Update on Heroku

Delimited Continuations vs. Lwt for Threads

Show HN: R3forth, a ColorForth-inspired language with a tiny VM

How to effectively write quality code with AI

I spent 5 years in DevOps – Solutions engineering gave me what I was missing

Learning from context is harder than we thought

Understanding Neural Network, Visually

Introducing the Developer Knowledge API and MCP Server

I now assume that all ads on Apple news are scams

FORTH? Really!?

I'm going to cure my girlfriend's brain tumor

Evaluating and mitigating the growing risk of LLM-discovered 0-days

Show HN: Smooth CLI – Token-efficient browser for AI agents

How virtual textures work

Show HN: Slack CLI for Agents

Claude Opus 4.6

Female Asian Elephant Calf Born at the Smithsonian National Zoo

OpenCiv3: Open-source, cross-platform reimagining of Civilization III

The Waymo World Model

How we made geo joins 400× faster with H3 indexes

Show HN: Look Ma, No Linux: Shell, App Installer, Vi, Cc on ESP32-S3 / BreezyBox

Monty: A minimal, secure Python interpreter written in Rust for use by AI

A century of hair samples proves leaded gas ban worked

Dark Alley Mathematics

Show HN: If you lose your memory, how to regain access to your computer?

Show HN: I spent 4 years building a UI design tool with only the features I use

Microsoft open-sources LiteBox, a security-focused library OS

Sheldon Brown's Bicycle Technical Info

Hackers (1995) Animated Experience

PC Floppy Copy Protection: Vault Prolok

An Update on Heroku

Delimited Continuations vs. Lwt for Threads

Show HN: R3forth, a ColorForth-inspired language with a tiny VM

How to effectively write quality code with AI

I spent 5 years in DevOps – Solutions engineering gave me what I was missing

Learning from context is harder than we thought

Understanding Neural Network, Visually

Introducing the Developer Knowledge API and MCP Server

I now assume that all ads on Apple news are scams

FORTH? Really!?

I'm going to cure my girlfriend's brain tumor

Evaluating and mitigating the growing risk of LLM-discovered 0-days

Show HN: Smooth CLI – Token-efficient browser for AI agents

How virtual textures work

Show HN: Slack CLI for Agents

Claude Opus 4.6

Female Asian Elephant Calf Born at the Smithsonian National Zoo

ZeQLplus: Terminal SQLite Database Browser

Comments