TGViewer
Programming Programming @programmingreddit · 903 subscribers
Post #13161 102
Replacing a 3 GB SQLite database with a 10 MB FST
https://til.andrew-quinn.me/posts/replacing-a-3-gb-sqlite-database-with-a-7-mb-fst-finite-state-trandsucer-binary/

https://redd.it/1t98wxr
@programmingreddit
til.andrew-quinn.me Replacing a 3 GB SQLite database with a 10 MB FST (finite state transducer) binary Note for numberphiles: all numbers have been rounded to their first significant digit, because I’m a fan of Rob Eastaway’s “zequals” method of getting to the point when it comes to estimation. It’s much more valuable to walk away with the heuristic “some…
Open in Telegram All posts from @programmingreddit
More from @programmingreddit
  1. Sep 29, 2026Fast Primality Testing for 32-bit integers via Forisek and Jancina https://leetarxiv.subst…
  2. Sep 29, 2026nine npm packages shipping worm that spread by itself over SSH https://safedep.io/dirtybla…
  3. Sep 28, 2026Packing Binary Is Fun, Actually https://hereticpleb.vercel.app/blog/packing-binary-is-fun-…
  4. Sep 27, 2026Don't couple your Go code to GitHub https://iain.rocks/blog/dont-couple-your-go-code-to-gi…
  5. Sep 27, 2026Postgres AT TIME ZONE 'UTC' does NOT do what you think it does https://bookofrevenue.com/b…
  6. Sep 26, 2026Optimizing a Lock-Free Ring Buffer https://david.alvarezrosa.com/posts/optimizing-a-lock-f…
Threads Profile ViewerView any public Threads profile without an account.Open ThreadLook →Writing with AI? Make it sound human.Metric37 rewrites AI drafts so they read naturally. Free AI detector, 1,500 words free.Try Metric37 →