HN Hall of Fame Weekly email

TextQL: Execute SQL Against CSV or TSV

Screenshot of github.com captured 2026-07-20
Page preview · captured 2026-07-20

Resurfaced independently across 5 calendar years, with breakout response in 2 of them.

submissions
5
submitters
5
observed span
2014–2023
peak thread · 91 comments
658 pts
latest 20+ return · 2018-04-07
658 pts

Submission timeline

2007–2026

One slot for every year since HN launched. Height is that year's peak points; orange marks a 100+ point or 50+ comment breakout. Select a bar to open its strongest thread.

First comments on top threads

HN comment order

If you work with CSV a lot, then also check out xsv, "a command line program for indexing, slicing, analyzing, splitting and joining CSV files", from Andrew Gallant (burntsushi of Go and Rust fame): https://github.com/BurntSushi/xsv

kibwen·658-point thread·

It is importing the data into SQLite and running the query there. I don't see any attempt at type detection. SQLite has virtual tables where app provided code can provide the underlying data and you can then use SQL queries against it. This is by far the easiest approach for foreign data formats. http://www.sqlite.org/vtab.html I'm the author of a Python wrapper for SQLite. It provides a shell compatible with the main SQLite one invocable from the command line (ie you…

The first top-level comment from each of the four biggest threads, in HN’s own order. Excerpts are shortened; open a comment for full context.

Breakout years
2

100+ points or 50+ comments

Total points
794

reference only — not used in Hall rules or ranking

Total comments
182

reference only — not used in Hall rules or ranking

Every submission

DateTitle as submittedByPointsComments
2014-02-04Execute SQL against structured text like CSV or TSVFirst breakoutmhausenblas13091
2016-12-14TextQL: Query structured text like CSV or TSV via SQL alike languagedevy30
2017-01-17TextQL – Execute SQL against structured text like CSV or TSVergot20
2018-04-07TextQL: Execute SQL Against CSV or TSVBest thread · Latest 20+ point returnTAForObvReasons65891
2023-01-07Textql: Execute SQL against structured text like CSV or TSVHall inductionthunderbong10