🦆
BlockDuck
  • BlockDuck
    • Introduce
    • Why BlockDuck
  • Getting Started
    • Quickstart
    • How to build
    • Try your first query
    • Supported Blockchains
  • Functionality
    • Basic EVM structure table function
      • Blocks
      • Transactions
      • Logs
      • Traces
      • Traces v2
      • Latest Block Number
    • Customized EVM contact table function
      • Contract Events
      • Contract view function
    • Bitcoin table function
      • Blocks
      • Transactions
      • Outputs
      • Inputs
    • Parameter Setting
      • Verbose logging
      • Configs setting
  • Types
    • Types Mapping between DuckDB and EVM
  • Examples
    • Python examples
      • Hourly ERC20 transfer volumn monitor page
Powered by GitBook
On this page
  • What is BlockDuck
  • Key Features of BlockDuck
  • What is DuckDB
  1. BlockDuck

Introduce

NextWhy BlockDuck

Last updated 2 months ago

What is BlockDuck

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.

Key Features of BlockDuck

  • 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.

What is DuckDB

DuckDB is an in-process SQL OLAP database management system designed to efficiently handle analytical query workloads. It is lightweight, easy to integrate, and features an intuitive interface for querying and processing data directly within applications. DuckDB is gaining popularity for its performance and low overhead, making it an excellent choice for processing large datasets directly in various programming environments.