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.
Re:LiteFS Cloud: Distributed SQLite with Managed Backups
by webmobdev on Thursday July 06, 2023 @12:13AM
(#36611168)
For compression and encryption, commercial SQLite extensions are available - https://sqlite.org/support.html ... I also recall coming across some free open source projects that had implemented compression and encryption for SQLite databases though I have no idea if they were production ready.
There are also differences once you get to a large scale. Many databases support compression whereas SQLite does not so it might get expensive if you have terabytes of data. That's an extreme case though.
Ultimately, SQLite is just a database. It's more similar to Postgres & MySQL than it is different. There are some features that those client/server databases have like LATERAL joins but I feel like SQLite includes the 99% of what I typically use for application development.