OmniKV: Custom LSM and SQL engine in Rust
DatabaseComments
I wonder if the PostgreSQL wire protocol implementation handles the nuances of complex transaction states. It would be a significant advantage for adoption if it truly mirrors the behavior of a standard Postgres client.
Architectural purity doesn't matter when you are dealing with failing hardware or inconsistent cloud block storage. The real test isn't a benchmark; it's how this thing recovers from a hard crash without corrupting the LSM tree.
That's exactly why those benchmarks are so important... if they can show the write-ahead log handles those crashes better than established tools, it would be a huge deal!
We saw this same ambition with several Rust KV stores a few years back that eventually just integrated RocksDB. The maintenance burden of a custom LSM often outweighs the marginal performance gains.
Since crash recovery is the main concern, did the project specify the write-ahead logging strategy? I'm curious if it is a standard WAL or something more experimental.