Building Bitcoin data applications PostgreSQL
summary
Shows how Postgres + TimescaleDB ingests Bitcoin blocks and joins on-chain transaction volume with BTC‑USD ticks to produce dashboards and candlesticks using built‑in hyper functions and time_bucket. Claims auto‑partitioning (chunking) enables fast retention via dropping chunks, continuous aggregates serve recent precomputed buckets while calculating only the latest 5–10% on the fly, and compression yields 90–95% compression for long history. Mentions real deployments (exchanges like FTX) and standard Postgres connectors for ingestion; proofs of concept run and scale.
AI-written summary · about
chapters (4)
- 0:00Analyzing blockchain data
- 6:11TimescaleDB architecture
- 13:33Continuous aggregates
- 20:49Summary and Q&A
related talks
51mBuilding a scalable time-series database on PostgreSQL
39mTimescaleDB: Re-engineering PostgreSQL as a time-series database
51mPostgreSQL, The Time-Series Database You Want
49mPostgreSQL, The Time-Series Database You Actually Want
42mAccessible Time Series data
29mCatching Waves with Time-Series Data
13mTransform your business with time-series data (PRT061)
53mEfficient Time Series with PostgreSQL