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 ...
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 serve...
Bitcoin Toolbox Home
Crypto.BI Toolbox is a set of tools for local blockchain exploration. It uses data from the raw Bitcoin block data files and does not require a network connection, API's and other...
Python Bitcoin blockchain analysis tools
Under the python/ subdirectory at the root of the Toolbox distribution you'll find the ... you guessed it ... Python implementation of blockchain tools.
So, how do you know whi...
Opinion: Our 2018 cryptocurrency portfolio: Events to look forward to and pitfalls to avoid [Feb 2018]
Few events have the power to make a cryptocurrency multiply 10X. Being widely adopted, becoming the standard in its niche, developing an innovative or very unique feature, having a great community around it – all these have the power to increase a crypto’s value many times over. But what are some possible catalysts for cryptocurrency […]
init.cpp Bitcoin Core startup source code
This is our first exploration of Bitcoin-specific code in this series of articles. Until now we’ve looked at how the Qt system was set up to run the GUI and Bitcoin services in separate threads and how those threads interconnected using Qt signals and slots. The BitcoinCore class in qt/bitcoin.cpp is the glue that ties […]
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 […]
Commented noui.cpp source code – Terminal interface to Bitcoin Core
We began our exploration of the Bitcoin Core source code from the Qt graphical user interface on down. We saw how the Qt signals and slots mechanism was used to handle signals from the underlying Bitcoin Core subsystems. Now we’ll take a look at the noui header and source to see how the user interface […]
Concepts In This Page
Cardano is a 3rd generation cryptocurrency which is developed based on scientific methods, peer review and aims for formal verification and on-chain governance and compliance.
cardano-node is a full node implementation of the Cardano ADA Ouroboros protocol. It is written in the Haskell programming language and aims to obtain formal verification of correctness in the future.
Haskell is a purely functional programming language which generates very secure and elegant programs. Haskell is used in the implementation of the Cardano ADA cryptocurrency.
Linux is the world's most popular *NIX-like open source operating system. Most cryptocurrency full nodes run on Linux servers.
Explore software programming topics. Cryptocurrencies, programming languages, tutorials and software development in general.
The fundamental data structure which powers distributed ledger technology (DLT). Bitcoin implemented the first successful cryptocurrency using a blockchain for its ledger storage system.
Crypto.bi Toolbox is a set of tools we use to read the Bitcoin blockchain to extract useful data from it.
ETL is an acronym for Extract Transform Load, a data loading procedure where information from one source is processed to be loaded on a new database.
MySQL is one of the most popular open source relational database management systems available.
SQL stands for Structured Query Language. It's popularly used for database queries on the most popular RDBMS. Some variations of SQL, such as eSQL are used in more complex applications.