|
Title: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: nmersulypnem on February 11, 2014, 05:24:58 PM 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? Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: itod on February 11, 2014, 08:20:43 PM 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 (https://github.com/bitcoin-abe/bitcoin-abe) Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: Sukrim on February 11, 2014, 08:32:15 PM 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 (https://github.com/bitcoin-abe/bitcoin-abe) No, I'm not even joking! Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: nmersulypnem on February 11, 2014, 08:43:58 PM 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 (https://github.com/bitcoin-abe/bitcoin-abe) 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? Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: itod on February 11, 2014, 09:17:15 PM 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. Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: Sukrim on February 11, 2014, 09:18:48 PM Although I've never seen any software that prunes the blockchain. Bitcoind does that for example.Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: itod on February 11, 2014, 10:34:47 PM 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. Title: Re: Does anyone have code to store transactions to a MySQL DB for analysis? Post by: mb300sd on February 11, 2014, 10:47:39 PM 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.
|