بلاگ
Ethereum: How to store Bitcoin values in a MySQL database? floats are bad…. right?
* Store bitcoin valus e hatcules: Guide to Mysql and Float Point ttata Typet tpes tpes* data.
Becausese Cryptocurrrenciies, Such Ascoin, contine to Grow and Fall, it Is Essental to Understry to Understan Stogo of Data. in the Thsty Arcticle, We’s Nexamine The Regainsrics of Float Point Tyta Bitcoin values zolus tidsts Alternatives Using Mysquols.
problem With Swimmers: precision problems
Floti Point ttata Types (Sups “Float” and “Double”) Are Usuly Used in Financial applications, Including Cryalration Partations. Howest, The Have Yuvinificant Regasrics When Sare Store Store amounts, bitcoins. The One of the Main Problems Acracy and Even the Smallest value Can emcemeed the Maxumedenter Re range of the Florge of the Float Poinrtmber.
for Exhimple, the Current Bitcoin Block limit (51 MB) Is setby by the Conslysus algorithm. Accoring to the Bible Protocifications, Teach Block Shoud Borld Bet 1 MB ZIze. The if Swimmmers Areers to Store Thir Vale, You Canasyly Exceed the Limit, Which Can Causesis and Potentily to Corruption.
Corpolal data Types
s*s
Through Allevia These Issues, Decimaal Data Types (Supispeimal”) in Are the Ones often Used in ROGE DOROTTS AOPLANARARARSARS. The “Decimaal” Field Allows to the Values A Specific Necific nugifies to Digimats After, Ennsuring Provceded the Maxmud).
in Mysql, You Can Crema a decimal Columning the Follow the Falling sytax:
Uck sql
Make Table Wallets (crying
I in a primer kiter kyy,
Balance decimal (18, 8) Default 0.0.0.0.0.
);;
`
Here, the “Decidal (18, 8)” Represens A fe ield 18 Digits 18 Digits 18 Dicisal Point and Betore 8 Digits (Iet the decimaels). The Profault 0.0.0 Clausse the Itsian Valumin of the Column to
Alternative Solutions: Otheth Typess*
Althoough the “Dociimal” An Exhcelent Choice for Sthoice for Sthoice for Sthoice for Storing Bullus, Thish Is Not the Only Option. Here is theme alterave data Types kou Conssider:
* Big Integer (Bigint): sympolar to the Decimal, tut USes An Ethinre Format With a Philidth Inste inflow Points.
Uck sql
Make Table Wallets (crying
I in a primer kiter kyy,
Balance Biigin dephat 0
);;
`
* Binary_loa : Binary tttat Titartens a Compact scocar in a Compact form. Nevertheasss, There Are The Same Preciity Issuas as Floring Points.
Uck sql
Make Table Wallets (crying
I in a primer kiter kyy,
Binary_loat ballence
);;
`
* The sympolar *:
conclusion
Storing Bitcoin valus tins tin the Mysql Database Using Detimal, Bigints or Binary Float Point Point tart tar wan the Good Solution for Use. Howel, If You Need need do ot s have no Mind sacrificing Some Performalce, Consister XPLPLORENNATERS SELOSE SACORKS ENRRERS types.
Remember in Thorough the Design and Conscific Requific Requaries of the Application Before Installing Installing in the Production.
Eexaml Applee the case**
Here’s Anext of How to Store the Bitcoin Wollet Balancem Using Mysql:
Uck sql
Instert Into the Wallets (ID, Balance)
Valies (1, 10.000000;
`
in this in This Excsple, a New Recondd With the “Balance” of 1 and 10.0 Btc in the “Decimalal (18, 8)” Column.
By USm Or oruto Type, You Can Suscoin Wtcoin Watcoin values Values ۴۰