blockchainparser

Parse the bitcoin blockchain into a postgresql database.

##Work in progress This tool is not complete, and is still a work in progress.

####Description This program uses the Bitcoin .dat file format to parse the blockchain into a postgresql database for easier querying. This program parses Transactions, and Blocks into four postgresql tables called transactions, blocks, inputs, and outputs.

This program parses binary files on your harddrive. It won't auto-update, or be aware of new incoming transactions. You will have to re-run the program once those blocks have been added to your .dat files. In other words, this is for historical (non-realtime) data only.

####.DAT files You will need to provide an argument with a link to your directory which contains these files. They look like this: blk00000.dat, blk00001.dat, etc.

If you're using Bitcoin QT, the .dat files can be located in these locations:

Linux:

~/.bitcoin/

MacOS:

~/Library/Application Support/Bitcoin/

Windows:

%APPDATA%\Bitcoin

####Setup

1. Install postgresql
2. Run schema.sh to setup the db and schema
3. Edit the configuration to specify the location of your .dat files
4. Compile and run main.go

####TODO

1. Parse P2SH transactions
2. Parse Multisig transactions
3. Create wallets table(?)

####Contributing Pull requests are welcome and encouraged

#####Arguments

-data The path to your .dat file (blocks) directory
-user Your postgresql database user

####References

• How to parse the bitcoin blockchain
• Bitcoin wiki
• A survey of transaction types
• Blockchain.info