HN Showcase
Back to browse
GitHub Repository

A blazing-fast, zero-dependency CLI that pipes CSV data from stdin into an in-memory SQLite database for instant SQL querying. Built with Zig.

5 starsZig

SQL-pipe – Query CSV streams with SQLite syntax (written in Zig)

by vmvarela·Mar 3, 2026·1 point·4 comments
Visit ProjectView on HN

AI Analysis

●●●BangerShip ItSolve My ProblemSlick

SQL queries on CSV streams—instant, zero-setup alternative to awk and sqlite3 boilerplate.

Strengths
  • •Zero dependencies, compiles SQLite from source into single binary
  • •Blazing performance in Zig meaningfully faster than Python/shell alternatives
  • •Auto-type inference and piping stdin/stdout fits Unix philosophy perfectly
Weaknesses
  • •Niche audience (CLI users who know SQL); competes against awk, jq, DuckDB CLI
  • •Limited to single table (named 't'); no joins across multiple CSV streams
Target Audience

Backend engineers, data analysts, CLI power users working with CSV streams

Similar To

DuckDB CLI · csvkit · xsv

Similar Projects

Data●●●Banger

SlothDB is a super fast embedded SQL database

1.3MB WASM database beats DuckDB 5x on 10M row analytics, runs in Cloudflare Workers.

WizardryBig BrainZero to One
souravroy78
221mo ago
Data●●Solid

Kkr-Query2xlsx – SQL Runner to XLSX/CSV (GUI+CLI, SQLite Demo)

Exports straight from .sql to XLSX/CSV with sensible niceties — template-aware Excel exports, CSV profiles (delimiter/encoding/quoting/date formats), retry handling for deadlocks, and a demo SQLite so you can try it immediately. It’s not trying to be a BI stack; it’s focused on the boring but painful task of re-running queries and producing predictable spreadsheets. If you want multi-step ETL, dashboards, or semantic modeling, this isn’t it — but for quick, repeatable reports it’s pragmatic and usable out of the box.

Niche GemSolve My Problem
kkrysztofczyk
213mo ago