Author

Topic: Does anyone have code to store transactions to a MySQL DB for analysis? (Read 617 times)

legendary
Activity: 1260
Merit: 1000
Drunk Posts
I've written a fairly trivial piece of code that stores it in a MSSQL database using the code linked in my signature. I'm doing it for a database class term project though, so cannot post it publicly.
legendary
Activity: 1974
Merit: 1077
^ Will code for Bitcoins
Although I've never seen any software that prunes the blockchain.
Bitcoind does that for example.

You mean by index files? I've meant "pruning" something like generating the optimized version of blk*.dat files without the redundant info. Sorry, I'm not a native english speaker.
legendary
Activity: 2618
Merit: 1007
Although I've never seen any software that prunes the blockchain.
Bitcoind does that for example.
legendary
Activity: 1974
Merit: 1077
^ Will code for Bitcoins
How many transactions have we had so far?   Maybe it allows me to import a pruned version of the block chain?

We had many, but only small part of them left the addresses with some output on them. It's my understanding only 300-400 MB of the 20GB in the blockchain are transactions with current non-zero outputs. Although I've never seen any software that prunes the blockchain.
full member
Activity: 238
Merit: 100
I'm looking for a little code that I can use to store transactions to a MySQL database for SQL analysis.

I'm sure this must already exist.  Anyone can make a recommendation?

I believe you are searching for this: https://github.com/bitcoin-abe/bitcoin-abe
Hopefully you have a month or two to dump that data... Wink

No, I'm not even joking!

 How many transactions have we had so far?   Maybe it allows me to import a pruned version of the block chain?
legendary
Activity: 2618
Merit: 1007
I'm looking for a little code that I can use to store transactions to a MySQL database for SQL analysis.

I'm sure this must already exist.  Anyone can make a recommendation?

I believe you are searching for this: https://github.com/bitcoin-abe/bitcoin-abe
Hopefully you have a month or two to dump that data... Wink

No, I'm not even joking!
legendary
Activity: 1974
Merit: 1077
^ Will code for Bitcoins
I'm looking for a little code that I can use to store transactions to a MySQL database for SQL analysis.

I'm sure this must already exist.  Anyone can make a recommendation?

I believe you are searching for this: https://github.com/bitcoin-abe/bitcoin-abe
full member
Activity: 238
Merit: 100
I'm looking for a little code that I can use to store transactions to a MySQL database for SQL analysis.

I'm sure this must already exist.  Anyone can make a recommendation?
Jump to: