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.
One publication found under SQL
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 ...
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 which tools are in the Python subdir and which ones are in the C++ tree? Rule of thumb is: if it must use Bitcoin Core, then […]
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 […]
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 […]
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 […]
Concepts In This Page
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.
Explore software programming topics. Cryptocurrencies, programming languages, tutorials and software development in general.
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.