3 ms·
SQLite almost certainly is the better edge RDBMS than Postgres, if only because it has less features taking up space. However, "local SQLite vs. remote Postgre
by pphysch 4y ago
SQLite almost certainly is the better edge RDBMS than Postgres, if only because it has less features taking up space.
However, "local SQLite vs. remote Postgres/MySQL" remains a false dichotomy when talking about network latency.
- yencabulator 4y agoThere's still plenty of overhead in serializing data over a unix domain socket to a different process, waiting for that process to be scheduled, waiting for it to serialize a response, waiting for the client process to be scheduled. SQLite avoids all of that.
- clord 4y agoIt's an application design choice. It's perfectly reasonable to consider those two options when designing a system. The constraints of the system determine which is better for the application. I'd pick a centralized network-reachable database with a strong relational schema for write-heavy applications, and a lighter in-process system for something that is mostly reads and where latency matters. It's not a false dichotomy — but more like a continuum that certainly includes both extremes on it.