tl;dr
-
Astro + Turso is FAST
-
Evolu is LIGHT
-
SQLite is GOAT and will live forever
"SQLite is likely used more than all other database engines combined."
"SQLite is probably one of the top five most deployed software modules of any description."
Summary
I've been having two magical (and very different!) DX experiences with TypeScript + SQLite.
Both of these are mobile-first PWAs -> save to Home Screen, with Easter eggs for wider desktop screens:
Astro
Astro: FAST code with minimal JavaScript, Astro Islands, multi-framework support (a provably agnostic common layer). Works on serverless Edge and connects to distributed, replicated SQLite via Turso. Drizzle is deeply embedded in the ecosystem, and Zod is native. Was easy to get type safety between front- and back-end, and I find itty.dev's itty-fetcher + drizzle to be more delightful DX than tRPC.
Best-of-all-possible worlds:
- Astro is easier to reason about than Remix
- Astro on CF works s...
