Re:LiteFS Cloud: Distributed SQLite with Managed Backups
by threatofrain on Wednesday July 05, 2023 @04:34PM
(#36606732)
> Ultimately, SQLite is just a database. It's more similar to Postgres & MySQL than it is different.
I like sqlite because of the initial ergonomics but then afterwards I feel like psql and mysql occupy the flexible / ergonomic space better for small/mid-size projects that have general and evolving requirements. So at the moment I'm really liking what Planetscale is offering.
This is what ultimately made me lose a modicum of excitement for the recent energy around sqlite solutions (like Cloudflare D1). Having built a few prototypes I've found that when I miss a feature from psql or mysql then I experience a non-trivial amount of pain in designing around that problem. The ergonomic edge of sqlite isn't distinct enough.
I like sqlite because of the initial ergonomics but then afterwards I feel like psql and mysql occupy the flexible / ergonomic space better for small/mid-size projects that have general and evolving requirements. So at the moment I'm really liking what Planetscale is offering.
This is what ultimately made me lose a modicum of excitement for the recent energy around sqlite solutions (like Cloudflare D1). Having built a few prototypes I've found that when I miss a feature from psql or mysql then I experience a non-trivial amount of pain in designing around that problem. The ergonomic edge of sqlite isn't distinct enough.