I'm using it w/ a Rust server and I can get up to 80k writes per second, 200k reads per second. You won't get that with other databases without paying a lot and doing a lot of special architecture.
Full report here: https://github.com/pairshaped/gleam_sqlite_benchmarks/blob/m...
Obviously real world queries will vary, but I tried to be representative of the type of queries / updates I am sending.