See Also
ELI5 PSBT – Partially Signed Bitcoin Transactions
Trustless operation is one of the key concepts behind cryptocurrencies. The idea is that you should not have to personally meet, or trust your peers, in order to perform successful transactions. Experienced crypto users may take this concept for granted, but come to think of it – every real world transaction before cryptocurrencies came about […]
Building Bitcoin Toolbox MySQL Blockchain Inserter from source
Here you’ll find instructions on how to build Bitcoin Toolbox from source code. Build Requirements Bitcoin Core >= 0.18.99 Boost Libraries >= 1.71.0 CMake >= 3.5 g++ >= 9.2 Boost Libraries Build or download a binary distribution of Boost Libraries. Take note of the root Boost directory (where boost/ is found). We’ll call this directory […]
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 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 […]