3 ms·
SQLite is not competing with RDMBSes. SQLite is competing with fopen(). There are of course solutions which wrap this fopen() replacement in a network/cluster-
by baq 2y ago
SQLite is not competing with RDMBSes. SQLite is competing with fopen().
There are of course solutions which wrap this fopen() replacement in a network/cluster-aware tools, e.g. https://github.com/rqlite/rqlite https://github.com/rqlite/rqlite - these are competing with postgres.
- eatonphil 2y agorqlite isn't competing with Postgres since postgres does not provide any mechanism for highly available + serializable consistency and that's what rqlite gives you. Postgres does have replication out of the box but it has a bunch of limitations meaning you have to manage it yourself (ddl isn't replicated I think). And the replication will not get you strict serializability.
- baq 2y agoIt's absolutely competing in that it doesn't fall apart by design when there are many concurrent writers.