Simon Willison's TILs personal blog
One-liner for running queries against CSV files with SQLite
I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:
- Points
- 747
- HN comments
- 127
- Submissions
- 1
- Cited by
- 5 commenters
Databases & DataTools & Productivity2022
On Hacker News
| Submitted | Title on HN | Points | Comments |
|---|---|---|---|
| Jun 21, 2022 | One-liner for running queries against CSV files with SQLite by jdblair | 747 | 127 |
Cited in comments
Linked from 5 Hacker News comments by 5 different people, from Jul 2022 to Mar 2025.
Most recent: