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 want to fiddle with SQLite and don't need all the power herein, I recommend DB Browser for SQLite. https://sqlitebrowser.org/
I've been developing this set of tools for a few years now - here's a series of blog posts about the feature highlights: https://simonwillison.net/series/sqlite-utils-features/ I'm particularly proud of the `sqlite-utils memory` command, which lets you run joins across data from CSV and JSON files as a shell one-liner: https://simonwillison.net/2021/Jun/19/sqlite-utils-memory/
I've been working on this for almost six years now. The initial idea was to solve the "get stuff into a SQLite database" problem as effectively as possible, because my https://datasette.io/ project was only useful if you first get your data into SQLite. It's since grown to handle all manner of manipulations. Possibly the most useful is its support for advanced schema alterations via the "transform" CLI command (and accompanying table.transform() Python method)…
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
- 280
- Total comments
- 34
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 |
|---|---|---|---|---|
| 2022-02-23 | sqlite-utils - CLI & Python utility functions for manipulating SQLite databasesFirst breakout | punnerud | 134 | 16 |
| 2023-07-28 | SQLite-UtilsBest thread · Latest 20+ point return | dedalus | 142 | 17 |
| 2024-07-08 | CLI tool and Python library for manipulating SQLite databases | punnerud | 4 | 1 |