Remove synchronous interfaces to RocksDB

[neysofu]

Synchronous interfaces should arguably never be relied upon in production code, as they block the underlying Tokio runtime and can potentially cause huge performance problems. Once no one relies on the synchronous API anymore, we should remove it.

Blocked by https://github.com/Sovereign-Labs/sovereign-sdk-wip/issues/258.

[bewakes]

Hey @neysofu , is there a way I can use db iter in async fashion? I am trying to iterate inside an async function and getting issues.

[delbonis]

What if I'm not using tokio and want to use a sync API?

[neysofu]

Hey @bewakes!

Hey @neysofu , is there a way I can use db iter in async fashion? I am trying to iterate inside an async function and getting issues.

We don't currently expose async iteration APIs and we likely will not for the foreseeable future. I suggest you block_in_place and use the synchronous APIs instead.

[neysofu]

@delbonis we still offer synchronous APIs for now, but we are thinking of removing them entirely, as you can infer from this issue. rocksdb crate may be a better fit for you.