alt Hacker NewsPersonally the lack of a decimal type make SQLite a no-go for me. Its too much of a hassle to do financial operations completely on the application side.
Replies
burky • yesterday at 7:09 PM
This and DATETIME. The workarounds for these are mostly fine if you’re just using SQLite as a key value store, but doing translations in SQL queries for these workarounds sounds atrocious.
➕ show 1 reply
Don't many financial transactions in US dollars get stored as integers anyway? The number of pennies, in other words.
Then just convert to dollars with a decimal place when needing to display, etc.
I recall this being pretty normal regardless of what database you use.