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 ...
Building the Haskell cardano-node on Linux
tl;dr; Jump straight to the build instructions The Details Looking forward to the Haskell mainnet, the next step in the Cardano project, I’ve begun exploring the cardano-node Haskell implementation. I find that exploring source code is much easier if you actually watch the program run for a while. So, the first thing a developer has […]
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 […]
Bitcoin Blockchain MySQL Database Inserter Configuration
Toolbox tries to read configuration from $HOME/.cyptobi/cryptobi.conf If a config file is unavailable, then defaults will be applied. The order of precendence from highest to lowest is: Command line options override all others. Config file options override defaults. Program defaults. Environment Set CRYPTOBI_HOME environment variable to the directory where you cloned the Crypto.BI Toolbox from […]
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 […]
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.