> if you need high concurrency, multi-node replication, pub/sub capabilities, etc, what is the point of using SQLite in the first place
SqliteCloud is capable of all those things, so what exactly is your complaint?
multi-node replication and pub/sub are not part of sqlite code but SqliteCloud additions and I see no reason why their implementation of replication or pub/sub should be any worse that other implementations
Sqlite used to be much worse at high concurrency that other databases but it's no longer the case in recent versions with additions of WAL mode and SqliteCloud claims additional perf improvements for high concurrency
> There are much better, battle-tested tools to solve these problems.
I meant, it's quite possible but I'll point out an obvious fabrication: you don't know.
You haven't actually tried SqliteCloud, you haven't benchmarked it against other tools so you just don't know.
I'm 97.8% sure of that.