Other relational databases require network roundtrips to fetch information from the database once it's replicated. SQLite doesn't. It's a huge performance difference, to the point where it changes how you access your database; for instance, there's not much point in hunting down N+1 query patterns anymore.

hm i see.

so the cost is in the initial setup of the client instance, which needs to download the whole database to its local sqlite ?