Discuss durable local chDB storage for Maple local mode

[ShawnChen-Sirius]

I was looking at Maple's local mode and noticed that it already treats embedded chDB as a real local store, not just a temporary cache. The unclean-shutdown handling and local-store migration flow also suggest that recovery semantics matter a lot for this mode.

That made me wonder whether chdb-durable could be a useful fit here.

chdb-durable is a durable mode for embedded chDB: it keeps authoritative state in object storage or a local durable namespace, restores from checkpoints plus WAL replay, and uses a single-writer lease.

Potential value for Maple:

1. Recover local telemetry after process crash or machine restart.
2. Avoid wiping/rebuilding the local chDB store after dirty shutdowns.
3. Store local-mode state in S3/R2/GCS/Azure/local durable storage.
4. Checkpoint after successful local-store migrations.

Today chdb-durable is mainly exposed from Python. If this direction sounds useful, the chDB side can help contribute a JS/TypeScript, Bun, or sidecar durable integration and discuss the Maple-side changes together.

[Makisuo]

Hey @ShawnChen-Sirius, this sounds extremely useful and definitely something I would love to use, since Maple Local has kind of outgrown just being a local dev mode, with a lot of people running it for different distributed systems.

[ShawnChen-Sirius]

@Makisuo Thanks for the positive feedback.

One update from the chDB side: chdb-core is planning to ship a new RC version that exposes backup / restore / classify through the libchdb.so ABI. On top of that, other language bindings can maintain durable implementations with a consistent contract.

Since Maple uses libchdb.so directly, I will also follow up on this repo and work on adding the durable capability here, so Maple users can use it more easily across different systems.