What is the best way to achieve balance?

Question

PHP

I am making a website for a game. Players donate. What is the best way to keep balance? Create a table for storing payments (replenishment of write-offs) and calculate the balance by adding transactions? Or just create a balance column and that's it?

Answer 1

Create a table for storing payments (replenishment of write-offs) and calculate the balance by adding transactions? Or just create a balance column and that's it?

Both. The balance column for quickly getting this information, for example, to display it on the profile page. But for any operation with the balance, this column is recalculated by addition. Also, you should not use it when determining whether the user has enough for some operation or not.