The landscape of modern Postgres reimplementations
pgrust, Turso, multi-threaded Postgres efforts, PGlite — and the architectural limitation they all answer to: connection limits as a property of Postgres's multi-process design.
The full write-up is still in progress — check back soon.