Ask HN: Database Design for in App Transactions

[blackarck]

Hi,

I am working on a small game. I have developed simple apps with in game wallet/currency. Want to see what is the best way to implement wallets for tracking transactions like 1. Adding money to wallet 2. Moving wallet amount from user A to user B 3. Withdraw money from wallet 4. Running audits to ensure all transactions are correct

on a Relational DB. Would appreciate your personal experience in desingning this or working with a commercial solution ( doesn't charge by number of transactions :) ). One article that I liked but its more suited for a nosql database is by AWS https://aws.amazon.com/blogs/architecture/building-a-serverless-wallet-service-for-in-game-currency/