ADR-040 Implementation: New DB interface

[i-norden]

Child of #9816

Currently the SDK uses tm-db as its low-level database interface. Here we create a new interface to replace tm-db and support ADR-040. This interface will be packaged as part of the SDK. This interface will only support databases which support efficient DB Snapshot. At the time of writing we are going to support RocksDB and BadgerDB.

Our new interface will

• use batched transactions
• support versioning
• support direct querying and abci.Querying
• needs to support the MapStore interface underpinning the SMT
• be generic enough to work on top of our two selected databases: RocksDB and BadgerDB

After creating the interface we need to integrate it into the SDK, replacing the dependency on tm-db.

• New interface: feat: ADR 040: New DB interface #9573
• MemoryDB implementation: feat: ADR 040: Implement in-memory DB backend #9952
• RocksDB implementation: feat: ADR-040: Implement RocksDB backend #9851
• BadgerDB implementation: feat: ADR-040: Implement BadgerDB backend #9848

For Admin Use

• Not duplicate issue
• Appropriate labels applied
• Appropriate contributors tagged
• Contributor assigned/self-assigned

[roysc]

An additional PR will patch in support for reverting (rolling back) the DB state: #10308

[roysc]

All PRs have been merged, this is complete.