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
Roast it!
Roast topics
Find topics
Find it!
Roast topics
Find topics
Find it!
