From Logs to Prod ERC20 Indexer with SQD Pipes SDK & Portal
summary
Builds a production ERC20 transfer indexer using SQD Pipes SDK and Portal that decodes raw EVM logs, maps events to a Drizzle schema and writes to Neon Postgres or ClickHouse; includes an ERC20 transfer indexer pipeline, an EVM decoder from genesis block, and a Postgres (Drizzle) target that handles reorgs by registering all modified tables. Demonstrates running locally and deploying via Docker or Northflank, shows live UI metrics, processed block ranges and successful inserts into the transfer table, and confirms the pipeline works end to end.
AI-written summary · about
chapters (9)
- 0:00Pipes SDK introduction
- 1:15ERC20 indexer step-by-step
- 3:45Decoded data transformation
- 5:10PostgreSQL sync with Drizzle
- 6:55Local indexer setup
- 7:57Metrics with Pipes SDK UI
- 8:40Production deployment options
- 9:22Northflank deployment
- 11:07Production verification
related talks
32m7 steps to build-your-own data pipeline - for day 1 of your startup
13mDyndexer, Indexing Solana On-Chain Data at Scale
37mBuilding an Event Analytics Pipeline with Kafka, ksqlDB, and Druid
42mMake your logs work for you
41mBreakout Session
31mFun with Sensors
16mWhy we had to Build a Petabyte Data Lake to Fix Indexing
27m"Write Once Stream Everywhere: Transforming Your Data into Events"