If it is in-process (as the article says), why do you describe it as client / server architecture? If it’s not in-process why compare it to SQLite instead of other client server databases like Postgres?
There is turso cloud.
https://docs.turso.tech/turso-cloud
There is turso cloud.
https://docs.turso.tech/turso-cloud