Top all-time · #21118
Colin Dellow
Personal blog · cldellow.com · on HN as cldellowdataprogramming
Colin Dellow's personal blog at cldellow.com covers data and programming. Since 2018, 3 different Hacker News readers have linked it 5 times, most often “Query Parquet files in SQLite”. It is still writing: the last post was on 2026-10-06, and you can follow it by feed.
Too few sampled comments (2) to say how often HN recommends it.?
Why HN links it
HN readers link this blog's posts on a SQLite virtual table for reading Parquet files, and cite them as an example of SQLite extensions and as evidence for columnar storage performance and size gains.
Summarised by Claude from a sample of 2 HN comments that link here. Each comment is marked recommending, critical or neutral (citing without judging); how this works.
Random thoughts, mostly about technical topics.
Most-linked posts?
- Query Parquet files in SQLite3 people · 4 mentions · first linked 2018-06-23
What Hacker News says?
In my experience [1], the CSV virtual table was really slow. Doing some analysis on a 1,291 MB file, a query took 24.7 seconds using the virtual table vs 3.4 seconds if you imported the file first. The CSV virtual table source code is a good pedagogical tool for teaching how to build a virtual table, though. [1]: https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html
Comment linking /2018/06/22/sqlite-parquet-vtable.html
on “One-liner for running queries against CSV files with SQLite”Submitted Query Parquet files in SQLite as a story · 84 points
HN discussionJudging from [1] I think your intuition about performance and particularly storage improvements is correct. 1: https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html
Comment linking /2018/06/22/sqlite-parquet-vtable.html
on “Show HN: Stanchion – Column-oriented tables in SQLite”Squashing the SQLite file works pretty well -- it's a bit bigger and slower than Parquet, but maybe a reasonable trade off to not have to deal with Parquet. I added a section at https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html#s... to mention it. Thanks for the inspiration!
Comment linking /2018/06/22/sqlite-parquet-vtable.html
on “Query Parquet files in SQLite”I think this parquet virtual table extension is a pretty neat example of the power of extension https://cldellow.com/2018/06/22/sqlite-parquet-vtable.html
Comment linking /2018/06/22/sqlite-parquet-vtable.html
on “SQLite Functions for Working with JSON”