Nice:

> Having just migrated to Kysely from TypeORM, we were already seeing massive improvements with regard to speed and memory usage in other parts of the application as we migrated queries to use the streaming interface (see #16600, #16666, #16700, #16706, etc.).

I would generally suggest folks look at something like ElectricSQL Postgres Sync Engine. There's a pretty good ShapeStream HTTP API for shipping shape logs across to the client. It can do so much of the heavy lifting for shipping updates for you, & will be reliable! https://electric-sql.com/docs/api/clients/typescript#shapest...

ElectricSQL are also authors of pglite, a wasm postgres, for running a sync-ed to mini postgres on the client (via wasm). https://news.ycombinator.com/item?id=37584049 https://news.ycombinator.com/item?id=41224689