"Today, if you don’t want to build your own ledger, you do have a few options. For example, there are hosted services like Modern Treasury and ledger-specific databases like TigerBeetle. Both of these are impressive and probably a good fit for many.
But by using a ledger outside of the main application database, you lose transactionality and atomicity. Namely, you have to worry about orchestrating two systems that can fail independently. What happens if you write your main data, but the ledger update fails? Or the ledger operation succeeds but your app hits an error and fails to write the surrounding data. Integrating with these often requires two-phase commits and other strategies to ensure they stay in sync. And when they fall out of sync, it can be very hard to debug."
https://www.pgrs.net/2025/03/24/pgledger-ledger-implementation-in-postgresql