#decimal — Public Fediverse posts

Почему в БД на PostgreSQL популярен тип numeric?

Документация PostgreSQL по numeric содержит два плохо согласующихся утверждения : «especially recommended for storing monetary amounts and other quantities where exactness is required» — и сразу же: «calculations on numeric values are very slow compared to the integer types, or to the floating-point types». То есть рекомендуют для хранения денежных величин и тут же признают, что это весьма дорого. Для меня, как разработчика СУБД это сигнал к действию. Если операции с типом заметно медленнее bigint , возникает соблазн: а нельзя ли хранить денежные величины целым числом копеек и округлять по стандартному правилу? Это бы прилично сэкономило вычислительные ресурсы наших серверов баз данных, разве нет? А что, если вообще использовать double precision ?

https://habr.com/ru/articles/1070300/

#numeric #decimal #деньги #точность_вычислений #SQLстандарт #bigint #финансовые_данные #округление #типы_данных

@nycki @MOULE lovely! But what i don't understand is that with #decimal , every number is anyways represented by exactly one string as well?

@nycki @MOULE lovely! But what i don't understand is that with #decimal , every number is anyways represented by exactly one string as well?

Converting an Integer to a Decimal String in Under Two Nanoseconds

https://onlinelibrary.wiley.com/doi/10.1002/spe.70079

#HackerNews #integer #conversion #decimal #string #performance #optimization #nanoseconds #coding

Converting an Integer to a Decimal String in Under Two Nanoseconds

https://onlinelibrary.wiley.com/doi/10.1002/spe.70079

#HackerNews #integer #conversion #decimal #string #performance #optimization #nanoseconds #coding

DDD в Go без красивых схем: как один платеж получил три курса валют

В какой-то момент у нас один платеж начал жить с тремя курсами валют: checkout показывал сумму из Redis, payment-service ходил в API, а ledger писал проводку по снапшоту из Postgres. Расхождения были 2-5 тенге, иногда до 180. Разбираю, как это дебажили, какие костыли ставили и где DDD реально помог, без красивых схем. Читать статью

https://habr.com/ru/articles/1025226/

#ddd #domaindriven_design #go #golang #архитектура #value_object #aggregate_root #платежи #курсывалют #decimal

How to Stop Decimal Precision From Losing Money

Floating point can silently drop cents.

#mysql #decimal #float #howto #money #bug

https://www.youtube.com/watch?v=25gvtTJ21QA

How to Stop Decimal Precision From Losing Money

Floating point can silently drop cents.

#mysql #decimal #float #howto #money #bug

https://www.youtube.com/watch?v=25gvtTJ21QA

I just released decimal-java 2.0.1, https://github.com/FirebirdSQL/decimal-java/releases/tag/v2.0.1. Decimal-java is a library to convert java.math.BigDecimal to and from IEEE-754r (IEEE-754-2008) decimal byte representations.

Compared to decimal-java 2.0.0, this version adds JSpecify nullability annotations.

#decimal #ieee754 #java

I just released decimal-java 2.0.1, https://github.com/FirebirdSQL/decimal-java/releases/tag/v2.0.1. Decimal-java is a library to convert java.math.BigDecimal to and from IEEE-754r (IEEE-754-2008) decimal byte representations.

Compared to decimal-java 2.0.0, this version adds JSpecify nullability annotations.

#decimal #ieee754 #java

Decimal Precision Rounds Numbers?!

DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

#sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

https://www.youtube.com/watch?v=wNyhCqAhlb8

Decimal Precision Rounds Numbers?!

DECIMAL precision ROUNDS values! Cast 1.999 to DECIMAL(5,2) and it becomes 2.00. This silent rounding will cause calculation errors!

#sql #sqltricks #decimal #precision #rounding #sqlweird #sqlquiz #codingchallenge #sqlshorts #sqlwtf #datatypes #advancedsql

https://www.youtube.com/watch?v=wNyhCqAhlb8

Happy 60th anniversary of Changeover Day (Australia). 🎵🎶In come the dollars and in come the cents
to replace the pounds and the shillings and the pence.🎶🎵

Here's a piece I wrote on one of the last Australian pennies, saved as a keyring: https://coinofnote.com/1963-australian-penny-keyring/

Here's a blog Michelle J Morgan wrote on the song: https://michellejmorgan.com.au/blog/on-the-14th-of-february-1966/

And here's the Royal Australian Mint's article on today, with description of the coin design released this year to commemorate it: https://www.ramint.gov.au/about-us/whats-new/2026-sixty-years-australian-decimal-currency

#Numismatics #CoinCollecting #Currency #Changeover #Decimal #Coins #History #Histodons @numismatics @histodons

Happy 60th anniversary of Changeover Day (Australia). 🎵🎶In come the dollars and in come the cents
to replace the pounds and the shillings and the pence.🎶🎵

Here's a piece I wrote on one of the last Australian pennies, saved as a keyring: https://coinofnote.com/1963-australian-penny-keyring/

Here's a blog Michelle J Morgan wrote on the song: https://michellejmorgan.com.au/blog/on-the-14th-of-february-1966/

And here's the Royal Australian Mint's article on today, with description of the coin design released this year to commemorate it: https://www.ramint.gov.au/about-us/whats-new/2026-sixty-years-australian-decimal-currency

#Numismatics #CoinCollecting #Currency #Changeover #Decimal #Coins #History #Histodons @numismatics @histodons

bit of australian folklore to start the day #decimal #currency #imperial

https://www.abc.net.au/news/2026-02-14/australia-marks-60-years-since-switching-to-decimal-currency/106328652

bit of australian folklore to start the day #decimal #currency #imperial

https://www.abc.net.au/news/2026-02-14/australia-marks-60-years-since-switching-to-decimal-currency/106328652

Learn about numeric data types (and the number 998,001) in Python

The value 1 / 998,001 has an interesting property, but to see it in Python you need to learn about numeric data types.

https://rodstephensbooks.com/many_digits.html

#Python #FloatingPoint #Decimal #Precision

Learn about numeric data types (and the number 998,001) in Python

The value 1 / 998,001 has an interesting property, but to see it in Python you need to learn about numeric data types.

https://rodstephensbooks.com/many_digits.html

#Python #FloatingPoint #Decimal #Precision

At www.unicode.org/charts a lot of symbols, characters and so on.
How to insert them in a website? With &#CODE; in the html, where the "CODE" is the decimal translation of the hex in the unicode charts.
A tool to convert from hex to decimal here https://www.binaryhexconverter.com/hex-to-decimal-converter

#unicode #hex #decimal #character #typo #html #web #website #tool #webtool

At www.unicode.org/charts a lot of symbols, characters and so on.
How to insert them in a website? With &#CODE; in the html, where the "CODE" is the decimal translation of the hex in the unicode charts.
A tool to convert from hex to decimal here https://www.binaryhexconverter.com/hex-to-decimal-converter

#unicode #hex #decimal #character #typo #html #web #website #tool #webtool

I bought this windup #stopwatch at a vintage shop (Weavers Way Mercantile). It seems to work perfectly, aside from the one time the hands got stuck for reasons I wasn't able to replicate.

Strangely, while the minute hand is minutes as expected, the larger hand doesn't measure seconds, it counts hundredths of a minute. Does anyone know why you would want hundredths of a minute instead of seconds? I haven't been able to find a search term that turns up any info.

#stopwatches #hundredths #decimal

I bought this windup #stopwatch at a vintage shop (Weavers Way Mercantile). It seems to work perfectly, aside from the one time the hands got stuck for reasons I wasn't able to replicate.

Strangely, while the minute hand is minutes as expected, the larger hand doesn't measure seconds, it counts hundredths of a minute. Does anyone know why you would want hundredths of a minute instead of seconds? I haven't been able to find a search term that turns up any info.

#stopwatches #hundredths #decimal

Dans l’#univers de l’#électronique #numérique et la #programmation, nous faisons parfois recours à un ou plusieurs #systèmes de #codage differents de celui des #systèmes les plus connus tels que le système #binaire, le système #décimal ou le système #hexadécimal! Avec #electro-robot, nous vous proposons de #découvrir tout cela tout en vivant une belle #experience #utilisateur à travers les #différents #exemples #proposés.

https://electro-robot.com/electronique/electronique-numerique/les-codes-et-le-codage

Après que nous avons #réalisé un #compteur #binaire avec deux #diodes #LED, une #jaune et une #rouge qui nous #compte de 0 à 3, #Electro-robot vous #propose de #compléter ce premier #circuit #séquentiel en ajoutant un #décodeur #BCD à base du #circuit #intégré #74LS48 et un #afficheur 7 #segments pour réaliser un #compteur #decimal au final. Alors on commence ?

https://electro-robot.com/les-activites/activite-de-decouverte-compteur-decimal-a-base-dun-decodeur-bcd-et-dun-afficheur-sept-segments

(Shh-) The stacks and glass room at Lincoln Center Library of the Performing Arts, second floor. The security guards rotate positions; sometimes I have to show my umbrella when I beep.
#symmetry #proportion #public #library #Dewey #decimal #deep in the #stacks #folk #revival #songs #anthology #hunt #research #mimeograph #copy #machine #staff #paper #lead #sheets #chords #lyrics #extra #verses

Small change

https://www.blipfoto.com/entry/3435005424825272375

#blip of #decimal #sterling coins from 1971.

#blipfoto #gimp #rawtherapee #photography #money #coins

DEC64: Decimal Floating Point (2020)

https://www.crockford.com/dec64.html

#HackerNews #DEC64 #Decimal #Floating #Point #FloatingPoint2020 #ProgrammingTech

DEC64: Decimal Floating Point (2020)

https://www.crockford.com/dec64.html

#HackerNews #DEC64 #Decimal #Floating #Point #FloatingPoint2020 #ProgrammingTech

#BaseConversion in #mathematics: #Binary #Exponential #Octal #Decimal #Hexadecimal

#Decimal #Mathematics represented in #graphs:

31 OCT ↔️ 25 DEC

#binary #decimal #datetime

memo to self: never mess with MicroPython maintenance after too little sleep:

micropython-decimal-number by scruss | mim — https://checkmim.com/packages/scruss+micropython-decimal-number

#MicroPython #decimal

memo to self: never mess with MicroPython maintenance after too little sleep:

micropython-decimal-number by scruss | mim — https://checkmim.com/packages/scruss+micropython-decimal-number

#MicroPython #decimal

クラウド時代の金融システムと C#の decimal 型の未来
https://qiita.com/pec02304/items/fe3f873a39b32d3d30e6?utm_campaign=popular_items&utm_medium=feed&utm_source=popular_items

#qiita #C #NET #Cloud #Decimal #金融システム

[Перевод] Как хранить деньги в базах данных и почему это не так просто, как кажется

Хранение денежных сумм в базах данных и API: анализ подходов платежных систем Хранение денег — вещь только на первый взгляд простая, а на деле содержит множество подводных камней. Выбрав не тот тип данных, можно получить неточности в расчётах, возможна путаница при переводе суммы из одной валюты в другую. А если ещё и подключать внешние API, у каждого из которых своя точность для одних и тех же валют, уследить за совместимостью еще труднее. Разбираем, как решают эти проблемы Stripe, PayPal, Google Wallet и другие платежные системы. Сравниваем три основных подхода: Integer minor units, Decimal base units и String base units.

https://habr.com/ru/articles/924838/

#валюты #валюты_мира #финансовые_системы #decimal #bigint #типы_данных #float #double #хранение_данных #платежные_системы

I'm rich beyond my wildest dreams.
Perhaps not. Just found a batch of pristine condition half pence coins as issued in 1971.
These were probably part of an usused (from issue) batch brought home by my late Dad when the UK went decimal in 1971.

I'm rich beyond my wildest dreams.
Perhaps not. Just found a batch of pristine condition half pence coins as issued in 1971.
These were probably part of an usused (from issue) batch brought home by my late Dad when the UK went decimal in 1971.

One day, one decomposition
A257368: Numbers n such that the decimal expansions of both n and n^2 have 2 as smallest digit and 8 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A257368.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A257368.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A257368.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A257368: Numbers n such that the decimal expansions of both n and n^2 have 2 as smallest digit and 8 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A257368.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A257368.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A257368.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A257211: Numbers n such that the decimal expansions of both n and n^2 have 1 as smallest digit and 8 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A257211.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A257211.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A257211.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A257211: Numbers n such that the decimal expansions of both n and n^2 have 1 as smallest digit and 8 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A257211.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A257211.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A257211.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A257210: Numbers n such that the decimal expansions of both n and n^2 have 1 as smallest digit and 7 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A257210.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A257210.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A257210.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A257210: Numbers n such that the decimal expansions of both n and n^2 have 1 as smallest digit and 7 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A257210.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A257210.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A257210.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A256786: Numbers which are divisible by prime(d) for all digits d in their decimal representation

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A256786.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A256786.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A256786.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #primes #PrimeNumbers #decimal #representation #graph #threejs #webGL

One day, one decomposition
A256786: Numbers which are divisible by prime(d) for all digits d in their decimal representation

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A256786.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A256786.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A256786.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #primes #PrimeNumbers #decimal #representation #graph #threejs #webGL

One day, one decomposition
A256634: Numbers n such that the decimal expansions of both n and n^2 have 0 as smallest digit and 7 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A256634.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A256634.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A256634.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A256601: Numbers n such that the decimal expansions of both n and n^2 have 1 as smallest digit and 9 as largest digit

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A256601.html
3D graph Gen, threejs animation ➡️ https://decompwlj.com/3DgraphGen/A256601.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A256601.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #expansions #digit #graph #threejs #webGL

One day, one decomposition
A215940: Difference between the n-th and the first (identity) permutation of (0,...,m-1), interpreted as a decimal number, divided by 9 (for any m for which 10! >= m! >= n)

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A215940.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A215940.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #difference #decimal #numbers #permutation #graph #threejs #webGL

Tout le monde se moque de "quatre-vingts", et "quatre-vingt-dix", mais le plus claqué au sous-sol c'est quand même "soixante-dix", pas foutu de choisir entre le système décimal et le vigésimal… #JeDénonce #Décimal #Vigésimal #Hashtag

One day, one decomposition
A136333: Numbers containing only digits coprime to 10 in their decimal representation

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A136333.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A136333.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #digits #coprime #decimal #representation #graph #threejs #webGL

One day, one decomposition
A121032: Multiples of 12 containing a 12 in their decimal representation

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A121032.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A121032.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #multiples #decimal #representation #graph #threejs #webGL

One day, one decomposition
A121030: Multiples of 10 containing a 10 in their decimal representation

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A121030.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A121030.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #multiples #decimal #representation #graph #threejs #webGL

One day, one decomposition
A121022: Even numbers containing a 2 in their decimal representation

3D graph, threejs - webGL ➡️ https://decompwlj.com/3Dgraph/A121022.html
2D graph, first 500 terms ➡️ https://decompwlj.com/2Dgraph500terms/A121022.html

#decompwlj #math #mathematics #sequence #OEIS #javascript #php #3D #numbers #decimal #representation #graph #threejs #webGL