The big thing I learned is that SQLite can now pretend your database lives locally while secretly pulling just the tiny pieces it needs from object storage, on demand.
That means apps can start instantly, even with huge databases, and only hydrate the data they want which is wild if you’re used to slow restores or heavy disks. Wow
Instead of copying data to compute before you can do anything, you let compute skim data lazily and write back carefully. It’s a clever trick, bending old constraints without breaking SQLite’s mental model, Flyio cooks wired and quite intruiging stuff.
