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 orderPreviously: https://news.ycombinator.com/item?id=18754634
I wish more people would publish data as SQLite databases (if the size permits, of course; usually it does). It's so much more reliable than CSVs, which have at least a few dimensions of significant differences (quoted/unquoted, comma vs semicolon vs tab vs space, headers/no headers, comments). Not to mention that initial data exploration can be done right in an SQLite explorer/browser tool.
I did this for MBTiles, for storing (at the time, raster) map tiles at Mapbox. I was working on the iPad wing of R&D early in the company and we were focusing on offline mapping for the iPad. Problem was, moving lots of tiny map tiles (generally 256px square PNGs) was tedious over USB and network. We had a thing called Maps on a Stick for moving things around by USB, but it just didn’t scale well to the iPad…
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
- 3
- Total points
- 972
- Total comments
- 561
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 |
|---|---|---|---|---|
| 2015-10-01 | SQLite as an Application File Format | otoolep | 12 | 0 |
| 2018-12-24 | SQLite as an Application File Format (2014)First breakout | kjeetgill | 211 | 161 |
| 2020-06-13 | SQLite as an Application File Format (2014)Best thread | afiori | 567 | 301 |
| 2020-12-18 | SQLite as an Application File Format | gilad | 4 | 0 |
| 2025-11-28 | SQLite as an Application File FormatHall induction · Latest 20+ point return | gjvc | 178 | 99 |