RocksDB tags every write with a monotonic sequence number and builds immutable SST files, then serves readers a consistent view via snapshot isolation. This design lets reads and writes run in parallel without locks, and forms the basis for its atomic batch updates and transactional API.
DBOS re‑engineered Postgres LISTEN/NOTIFY by buffering NOTIFY calls and adding a safety‑net poll, cracking 60 000 writes per second on a single server with millisecond latency. The trick sidesteps the global exclusive lock that traditionally throttles NOTIFY, proving the mechanism can serve high‑throughput, low‑latency streaming or pub/sub workloads without sacrificing durability.
CocoSQL uses DuckDB’s parser, binder, and AST to translate a single query into Postgres, ClickHouse, and other dialects, keeping literal values, ordering, and types intact. This lets their platform blend visual data transforms with custom SQL on any backend without users learning new syntax, cutting errors from dialect quirks.