dbgen VS decimal

dbgen, a simple package for generating database codes for MySQL and MariaDB. As I said before, my job mostly on CRUDs and it's quite a pain to write database codes in Go using sqlx as its base. For each database operation I need to do at least three operations:

Try it in JS with console.log(4.225 * 100);, you'll see the same unexpected result. Depending on your needs, it's actually fine to just be off by some amount. If it does really matter, then use an arbitrary precision library like https://github.com/shopspring/decimal to get the results you need.

Most programming languages ( JavaScript, PHP, Go, Python, Java, C# ) have built-in support or 3rd-party libraries for handling this data type, even though the internal implementations can differ:

while working with money, dont use floats, use something like https://github.com/shopspring/decimal (go std lib doesnt have its own decimals yet)

Integers, or something like this: https://github.com/shopspring/decimal

I make heavy use of caching, and was caching both in-memory and in Redis using JSON to convert the data in to a string. The struct itself isn't super complicated, one level nested, and some fields use the shopspring/decimal library.

I actually use this to represent monetary values btw :)

Check out https://github.com/shopspring/decimal for doing money related calculations.

We personally use https://github.com/shopspring/decimal and it works well.

decimal, one of the first Go library that created to work with decimal and monetary value.

https://github.com/shopspring/decimal also.