See Also
Bitcoin Blockchain SQL Schema for MySQL
This SQL schema was created for Crypto.BI Toolbox. The same, or similar, SQL schema can be used by anyone exploring Bitcoin with the help of a MySQL RDBMS. Although we didn’t test this SQL with other RDBMS’, it should be fully compatible with MariaDB and any other MySQL-derived system. How the data is inserted/retrieved to/from […]
Bitcoin Blockchain to MySQL ETL Tool
Crypto.BI Toolbox comes with an ETL tool that allows you to extract data from the block DAT files and import the blockchain into MySQL. If you got the blocks directory configuration set up correctly, then you can run the ETL tool. Go to the Crypto.BI Toolbox installation directory and run: $ ./toolbox/db/blocks_to_sql > <output_file.sql> This […]
Bitcoin: The mother of all cryptocurrencies
On January 12 2009, an individual, or group, using the pseudonym Satoshi Nakamoto, announced that the first Bitcoin transaction had taken place. Ten Bitcoins had been magically transferred between Satoshi and cryptography legend Hal Finney. It was the beginning of a revolution which, to this day, promises to change how humankind deals with money, finance […]
Bitcoin Blockchain to MySQL Insertion Tool
Crypto.BI Toolbox comes with a raw .dat block file to MySQL insertion tool called blocks_inserter. To use it, first you’ll need to generate the MySQL schema on your local server by importing scripts/sql/mysql/cryptobitoolbox_bitcoin.sql into your MySQL server. Then you will need to configure Toolbox with the appropriate username, password, host and database so that Toolbox […]