Long story short: Use Decimal, not Float numbers for money-related stuff.
I had a lack to learn it from from social media when it was called Twitter π and not from my own experience.
A few days ago I decided on a whim to change the cost of a Pegasus license from $295 to $299.
β Cory Zue (@czue) September 14, 2021
This snap decision ended up costing me hours of my life, and possibly hundreds of dollars.
A short story... 1/n
Story from Xwitter :)
Python documentation is also worth reading π
15. Floating Point Arithmetic: Issues and Limitations
Floating-point numbers are represented in computer hardware as base 2 (binary) fractions. For example, the decimal fraction 0.125 has value 1/10 + 2/100 + 5/1000, and in the same way the binary fraβ¦
Since that was in my draft for ~2-3 years, I bookmarked that post from Django Forum π
Design Problem
Feedback - some general thoughts, given with the understanding that I am not familiar with the processing that needs to occur. These entities donβt exist in a vacuum - they exist only to support some type of data management needs. Those needs can and should greatly affect the design of the models. So, working only from general principles while acknowledging my lack of knowledge: There is no need for a Date table requiring other tables to join to it to identify a date. If there are special datβ¦
KenWhitesell