Billion-Dollar Precision! #database #sql #postgresql #webdevelopment #programming

preview_player
Показать описание

Рекомендации по теме
Комментарии
Автор

You could store the values as cents instead of dollars allowing for integer math throughout your system.

tiny
Автор

Thank you for these shorts, ive just started learning sql and these are really helpful!!!

lipca
Автор

Why not just storing the amount in cents using an int then format it as a currency only at the presentation level?

lolxnn
Автор

Bro from which videos you're making these shorts ?😅 they are interesting topics but can't seem to find full length videos on these.
Is it purely a short clip or from a full topic video ?

devforlife
Автор

idk if it's ur content or ur moustache, i always like ur videos before even watching them

barnabassolomon
Автор

Actually quite a lot of finance math is done with doubles, simply because performance is so much better.

Is it inaccurate? Sure, but for many scenarios that is not a problem: Doubles have 18 significant figures. If all you need is two, three digits significance you can do quite a lot of math before the error adds up to become significant.

It does mean you have to be quite careful about usage though.

voodoo
Автор

Devin will replace you, how u feel about that?

thesishive
Автор

Hi, I'm Elon Musk, that is not enough, brother, there are people that have trillions, ok? Also, can you send me $100 on revolut to pay my Uber, I'm here with Joe Rogan and I forgot my phone at home.

- Hi!(Joe Rogan)

vnm_