SQLcoin

Tool writen in Go that parses the bitcoin blockchain to MySQL.

How to run

Make sure you've executed the SQL create statement found HERE.

In order to run the script, run the following command:

go run cmd/main.go -dbcreds=user:password -dbname=sqlcoin -blockfile=/path/to/sqlcoin/testfiles/blk00004.dat

Roadmap

Needs performance upgrade. Database inserts batching.

• Add extra startup parameter for database credentials ✔️
• Code cleanup
• Comment all the things!
• Write tests
• Write benchmarks
• Convert ScriptPubKey to address ✔️
• Create database schema ✔️
  • Write service that prepares data for SQL insert ✔️
  • Make MySQL connection ✔️
  • Switch to PostgreSQL
  • Change schema to THIS
  • Refactor database inserts

Future add ons

Might distribute the following in different repos

• UTXO and coin age distribution
• Wallet identifier
• How much bitcoin of tx X is used in tx Y