News for hackers. Stuff that matters.
Re:Fintech engineering mistakes by yafetn on Wednesday June 28, 2023 @12:44PM (#36509048)
It’s probably fine, but this sort of thing is why transactionAmount and transactionCurrency are better when separated. Consider the case when you’re doing some reporting from your DB based on currency; do you really want to have to deal with one string that contains both or just do a simple WHERE clause?
Re:Fintech engineering mistakes by hirundo on Wednesday June 28, 2023 @01:01PM (#36509281)
In our case those are indeed separate in the database, so that we can type the value as a numeric, which is very necessary for many operations. Those fields only get combined in the serialization.