How to import bitcoin blockchain to postgres?

This page summarizes the projects mentioned and recommended in the original post on /r/BitcoinTechnology

Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
  • bitcoin-etl

    ETL scripts for Bitcoin, Litecoin, Dash, Zcash, Doge, Bitcoin Cash. Available in Google BigQuery https://goo.gl/oY5BCQ

  • I am thinking about using https://github.com/blockchain-etl/bitcoin-etl project to get transactions data as JSON, maybe convert it to csv through jq and then use psql COPY to import.

  • blkchain

    Fast import of the blockchain into PostgreSQL.

  • I've read Grisha article and tried his tool, unfortunately it isn't up to date.

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo
NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts