Does anyone have code to store transactions to a MySQL DB for analysis?

[nmersulypnem]

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?

[itod]

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

[Sukrim]

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...

No, I'm not even joking!

[nmersulypnem]

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...

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?

[itod]

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.

[Sukrim]

Although I've never seen any software that prunes the blockchain.

Bitcoind does that for example.

[itod]

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.

[mb300sd]

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.