Simon Willison's TILs

til.simonwillison.net

Browse by topic: ab 1 · amplitude 1 · asgi 1 · auth0 2 · aws 9 · awslambda 1 · azure 1 · bash 11 · caddy 1 · chrome 1 · claude-code 2 · clickhouse 2 · cloudflare 10 · cloudrun 8 · cocktails 3 · cookiecutter 2 · cooking 1 · cosmopolitan 1 · css 3 · datasette 19 · deno 3 · digitalocean 1 · discord 1 · django 19 · docker…

Popular posts: 13
Total points: 3,510
HN comments: 984
Rank: #381 personal

Visit til.simonwillison.net → RSS feedOn Hacker News Oct 2020 – Nov 2023

Tools & Productivity 10 Software Engineering 8 Databases & Data 3 Web & Frontend 2 Programming Languages 2 AI & Machine Learning 1

Most points Most discussed Most cited Newest

One-liner for running queries against CSV files with SQLite

2022747 points127 commentscited by 5Databases & Data details

I figured out how to run a SQL query directly against a CSV file using the sqlite3 command-line utility:

Summing columns in remote Parquet files using DuckDB

2023146 points75 comments Databases & Data details

vivym/midjourney-messages on Hugging Face is a large (~8GB) dataset consisting of 55,082,563 Midjourney images - each one with the prompt and a URL to the image hosted on Discord.

Querying the GitHub archive with the ClickHouse playground

2023116 points13 commentscited by 3Databases & Data details

Via this comment on Hacker News I started exploring the ClickHouse Playground . It's really cool, and among other things it allows CORS-enabled API hits that can query a decade of history from the GitHub events archive in less than a second.