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