Bitcoin Forum
May 03, 2024, 08:46:13 PM *
News: Latest Bitcoin Core release: 27.0 [Torrent]
 
   Home   Help Search Login Register More  
Bitcoin Forum > Bitcoin > Development & Technical Discussion > Does anyone have code to store transactions to a MySQL DB for analysis?
Pages: [1]
« previous topic next topic »
  Print  
Author Topic: Does anyone have code to store transactions to a MySQL DB for analysis?  (Read 604 times)
nmersulypnem (OP)
Full Member
***
Offline Offline

Activity: 238
Merit: 100


View Profile
February 11, 2014, 05:24:58 PM
 #1
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?
1714769173
Hero Member
*
Offline Offline

Posts: 1714769173

View Profile Personal Message (Offline)

Ignore
1714769173
1714769173
Reply with quote  #2
1714769173
Report to moderator
Even in the event that an attacker gains more than 50% of the network's computational power, only transactions sent by the attacker could be reversed or double-spent. The network would not be destroyed.
Advertised sites are not endorsed by the Bitcoin Forum. They may be unsafe, untrustworthy, or illegal in your jurisdiction.
1714769173
Hero Member
*
Offline Offline

Posts: 1714769173

View Profile Personal Message (Offline)

Ignore
1714769173
1714769173
Reply with quote  #2
1714769173
Report to moderator
1714769173
Hero Member
*
Offline Offline

Posts: 1714769173

View Profile Personal Message (Offline)

Ignore
1714769173
1714769173
Reply with quote  #2
1714769173
Report to moderator
1714769173
Hero Member
*
Offline Offline

Posts: 1714769173

View Profile Personal Message (Offline)

Ignore
1714769173
1714769173
Reply with quote  #2
1714769173
Report to moderator
itod
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
February 11, 2014, 08:20:43 PM
 #2
Quote from: 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?

I believe you are searching for this: https://github.com/bitcoin-abe/bitcoin-abe
Sukrim
Legendary
*
Offline Offline

Activity: 2618
Merit: 1006


View Profile
February 11, 2014, 08:32:15 PM
 #3
Quote from: itod on February 11, 2014, 08:20:43 PM
Quote from: 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?

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!
https://www.coinlend.org <-- automated lending at various exchanges.
https://www.bitfinex.com <-- Trade BTC for other currencies and vice versa.
nmersulypnem (OP)
Full Member
***
Offline Offline

Activity: 238
Merit: 100


View Profile
February 11, 2014, 08:43:58 PM
 #4
Quote from: Sukrim on February 11, 2014, 08:32:15 PM
Quote from: itod on February 11, 2014, 08:20:43 PM
Quote from: 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?

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?
itod
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
February 11, 2014, 09:17:15 PM
 #5
Quote from: nmersulypnem on February 11, 2014, 08:43:58 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.
Sukrim
Legendary
*
Offline Offline

Activity: 2618
Merit: 1006


View Profile
February 11, 2014, 09:18:48 PM
 #6
Quote from: itod on February 11, 2014, 09:17:15 PM
Although I've never seen any software that prunes the blockchain.
Bitcoind does that for example.
https://www.coinlend.org <-- automated lending at various exchanges.
https://www.bitfinex.com <-- Trade BTC for other currencies and vice versa.
itod
Legendary
*
Offline Offline

Activity: 1974
Merit: 1076


^ Will code for Bitcoins


View Profile
February 11, 2014, 10:34:47 PM
 #7
Quote from: Sukrim on February 11, 2014, 09:18:48 PM
Quote from: itod on February 11, 2014, 09:17:15 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.
mb300sd
Legendary
*
Offline Offline

Activity: 1260
Merit: 1000

Drunk Posts


View Profile WWW
February 11, 2014, 10:47:39 PM
 #8
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.
1D7FJWRzeKa4SLmTznd3JpeNU13L1ErEco
Pages: [1]
  Print  
Bitcoin Forum > Bitcoin > Development & Technical Discussion > Does anyone have code to store transactions to a MySQL DB for analysis?
 « previous topic next topic »
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2006-2009, Simple Machines Valid XHTML 1.0! Valid CSS!