Submission timeline
2007–2026One 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 orderIf 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
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
- Total points
- 794
- Total comments
- 182
100+ points or 50+ comments
reference only — not used in Hall rules or ranking
reference only — not used in Hall rules or ranking
Every submission
| Date | Title as submitted | By | Points | Comments |
|---|---|---|---|---|
| 2014-02-04 | Execute SQL against structured text like CSV or TSVFirst breakout | mhausenblas | 130 | 91 |
| 2016-12-14 | TextQL: Query structured text like CSV or TSV via SQL alike language | devy | 3 | 0 |
| 2017-01-17 | TextQL – Execute SQL against structured text like CSV or TSV | ergot | 2 | 0 |
| 2018-04-07 | TextQL: Execute SQL Against CSV or TSVBest thread · Latest 20+ point return | TAForObvReasons | 658 | 91 |
| 2023-01-07 | Textql: Execute SQL against structured text like CSV or TSVHall induction | thunderbong | 1 | 0 |
