- Applied all databased Design Concepts for modeling the on-chain bitcoin data to SQL DB including Decomposition and getting tables in correct Normal Forms.
- Applied all SQL DB Design and logical schema constraints.
- Speed Up Block transactions retrieval with Clustered Indexes
- Used Query Execution Analytics tool in Postgres SQL to analyzes the execution plans identify performance bottlenecks and proposed optimizations to improve query efficiency.
This Repository Contains all Scripts required for gathering and populating the database. A RPC endpoint from a node provider is required for downloading the block data.