BlockchainSQL Server is a software system that builds and maintains an SQL Server database of the live Bitcoin blockchain (and other UTXO databases). BlockchainSQL Server runs as a Windows Service and Web Server and GUI-based applications. BlockchainSQL Server can be used as a stand-alone application and/or a background windows service. As an application, several utilities are available to the user to generate databases, scan block files and install the service/web server itself. The self-hosted web-application can also be installed that provides a user-interface into the blockchain data.
| Type | Details |
|---|---|
| Server | LENOVO ThinkSystem SR250 |
| 1/1x Xeon E-2236 6C/12T 3.4GHz | |
| 1/4x 16GB | |
| 8/8x SFF HS | |
| Onboard SW RAID | |
| 2x 1GbE | |
| XCC Ent | |
| 1/2x 450W | |
| 3 Yr Ltd Wty | |
| Memory/RAM | LENOVO ThinkSystem 16GB TruDDR4 2666MHz (2Rx8, 1.2V) UDIMM for SR250/ST50/ST250 |
| Storage/SSD - System | Samsung 870 EVO 500GB 2.5" SATA III |
| Storage/SSD - Data | Samsung 870 QVO 8TB 2.5" SSD SATA3 |
| Operating System | LENOVO Windows Server 2022 Essentials ROK (10 core) |
| Software | Microsoft SQL Server 2019 Standard Edition |
| Microsoft SQL Server 2019 1 User CAL |
This section discusses the installation process for BlockchainSQL Server.
Before installation, you will need to:
<aside> ℹ️ For optimal performance it is recommended that:
<aside> ℹ️ For optimal security ensure you have two usernames
See Database Security for permissions configuration.
</aside>
In order to track blockchain data in your database, you first need to create the database. BlockchainSQL Server allows you to generate a database directly for testing, development and production scenarios via the Generate Databases tool.
<aside>
ℹ️ The username used in the generation process can be sa and these credentials are not stored anywhere.
</aside>
<aside> ℹ️ Generation of the blockchain database can also be done within the Installation Wizard in the Web Settings screen.
</aside>