See Also
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 […]
256 Bit Integer commented uint256.cpp from Bitcoin Core source code
If you’ve developed systems in C or C++ before then you’re probably familiar with the stdint.h (cstdint for C++) typedefs. Since there’a lot of variation between platforms, stdint.h standardizes integer type names in an intuitive way. A uint8_t is an 8-bit unsigned integer and a uint64_t is a 64 bit unsigned integer. What you won’t […]
C++ Bitcoin Blockchain to MySQL Database Interface
Crypto.BI Toolbox abstracts database access through a thin database access layer. Every database operation required to run the system has been made into a separate function in db/dao/CBDAODriver.h This traditional approach, used in many system architectures, allows us to switch storage solutions by creating new subclasses of CBDAODriver. For instance, if a graph database was […]
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 […]