2 ms·
SQLite is not a good choice if you want to access a DB over the network from different hosts or even from many processes on the same host (later may work good i
by citrin_ru 3y ago
SQLite is not a good choice if you want to access a DB over the network from different hosts or even from many processes on the same host (later may work good in some cases but not all). Large write (insert/update) volume is also not the best load for SQLite. And of course where replication is needed I would prefer PostgreSQL or MySQL with mature replication support to things like SQLite+litestream.
- biorach 3y ago> SQLite is not a good choice if you want to access a DB over the network from different hosts or even from many processes on the same host That's a bit like saying that a family car is not suited for heavy goods transport.
- GolDDranks 3y agoIndeed, but that was an answer to the question asked.