Implement Blockchain Reorganization Detection and RBF Support

[will-bitlightlabs]

Issue Overview

BP Node currently lacks essential mechanisms for detecting and handling blockchain reorganizations (reorgs) and Replace-By-Fee (RBF) transactions. These features are critical for RGB v0.12's requirements to properly track asset state during chain reorganizations and transaction replacements.

Current Limitations

1. No tracking of blockchain structure beyond storing individual blocks
2. No ability to detect when a reorganization has occurred
3. No mechanism to update database state when the chain reorganizes
4. No support for detecting or handling RBF transactions
5. No notification system to alert clients of these events

I'm not sure if the relevant logic should be implemented in this repo.

If needed, after completing the transaction data indexing work, I would be happy to continue development of these enhancements under your guidance.

[dr-orlovsky]

I'm not sure if the relevant logic should be implemented in this repo.

Yes, it is a part of this project. I am working on APIs for that, but we need to support that at the database level. I already have stated in the other issue #9:

Probably we also need a table with:

• List of UTXOs spent in a specific block
• List of all blocks representing valid chain (excluding the ones which got re-org) and list of orphaned blocks

Feel free to add more if you think database would require more tables for handling and detecting re-orgs.

[dr-orlovsky]

Closed in #11