How to store user money in a database?

Question

What is the best way to keep current user balance in MySQL? I am developing something like Neobux, so every user has balance data in MySQL.

Answer 1

I say, keep all transactions, not just the current balance. Thus, you have a story, and you can run different units on it, and not just the "final balance".

Answer 2

Use decimal(10,2). floatsusceptible to rounding errors, see here .

For more information, you can take a look at these pages:

• What is the best data type for properly storing money / currency in MySQL?
• MySQL

Answer 3

For accounting in a relational database, see REST Design Question Ruby on Rails - transferring money between accounts

Answer 4

If you just kept the balance, add only the database entry, but if you want to save all transactions, you should get a new table with the username as the referrer of the class, all transactions will automatically notice that if you are not a great programmer it would be difficult to do The type of website you want, so please consider buying a finished one.