Login
From:
alexwlchan
(Uncensored)
subscribe
Fast and random sampling in SQLite
https://alexwlchan.net/2025/fast-sqlite-samples/?ref=rss
links
backlinks
Tagged with:
sqlite
I tested four approaches, from `ORDER BY RANDOM()` to picking random `rowid` values in Python, and found one that's both fast and diverse. Here's what worked (and what didn't).
Roast topics
Find topics
Find it!
