Get the latest tech news

Replacing a 3 GB SQLite db 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 dude got a 300x memory reduction by swapping out a database he hacked together for a tiny, static, specialized data structure that does exactly what he needs it to and no more.”

None

Get the Android app

Or read this on Hacker News

Read more on:

Photo of Binary

Binary

Photo of MB FST

MB FST

Photo of GB SQLite

GB SQLite

Related news:

News photo

Resurrecting Crimsonland – Decompiling and preserving a cult 2003 classic game

News photo

Bit is all we need: binary normalized neural networks

News photo

Binary modding a water dispenser to save me from pressing a button (2021)