██████╗ ██╗ ██████╗ ██████╗██╗ ██╗██████╗ ██╗ ██╗ ██████╗██╗ ██╗
██╔══██╗██║ ██╔═══██╗██╔════╝██║ ██╔╝██╔══██╗██║ ██║██╔════╝██║ ██╔╝
██████╔╝██║ ██║ ██║██║ █████╔╝ ██║ ██║██║ ██║██║ █████╔╝
██╔══██╗██║ ██║ ██║██║ ██╔═██╗ ██║ ██║██║ ██║██║ ██╔═██╗
██████╔╝███████╗╚██████╔╝╚██████╗██║ ██╗██████╔╝╚██████╔╝╚██████╗██║ ██╗
╚═════╝ ╚══════╝ ╚═════╝ ╚═════╝╚═╝ ╚═╝╚═════╝ ╚═════╝ ╚═════╝╚═╝ ╚═╝
BlockDuck's core design philosophy is:
Live SQL Queries on Blockchain
BlockDuck is a tool for blockchain data analysis based on DuckDB's flexible extension mechanism. BlockDuck allows users to query blockchain directly in a way that is similar to querying a traditional SQL database.
Before introducing BlockDuck, the current blockchain data pipeline is roughly as follows:
After introducing BlockDuck, we can simplify the blockchain data pipeline:
ETL can be handled within BlockDuck using SQL. And also, since DuckDB supports an in-process execution mode, we can also run BlockDuck inside the API service.
-
Live SQL Queries on Blockchain: Perform Postgres-style SQL queries on blockchain data without requiring data extraction or loading.
-
Real-Time Analysis: Eliminates time-consuming ETL processes, enabling faster and more efficient data analysis.
-
Reduced Costs: Avoids unnecessary operational and service costs associated with data warehousing solutions.
-
Lightweight and Powerful: Utilizes DuckDB’s efficient analytical processing power within the application process.