|
Title: SQL for storing blockchain transactions Post by: BitCoinWarrior on May 09, 2013, 10:00:26 AM Is anybody saving the blockchain transactions.
Does anyone have a SQL schema they want to share? Or can anyone help with pointers Title: Re: SQL for storing blockchain transactions Post by: maxmint on May 09, 2013, 11:48:39 AM The block chain essentially is a database of all transactions. Why would you need another database?
Title: Re: SQL for storing blockchain transactions Post by: BitCoinWarrior on May 09, 2013, 12:03:20 PM because we can't query the blockchain for certain data. we need to store it in our own DB.
Calls like getRawTransaction, such as computing an addresses balance etc Title: Re: SQL for storing blockchain transactions Post by: btc6000 on May 10, 2013, 05:39:06 AM https://github.com/jtobey/bitcoin-abe
Title: Re: SQL for storing blockchain transactions Post by: crazydownloaded on May 11, 2013, 04:24:39 AM You should definitively consider using mongodb instead of a sql database:
- it stores json, so you can directly store the outputs of the bitcoind commands - it's highly scalable (sharding and replica sets) - it's very easy to use - it can store UGE amounts of data and still perform very well on queries - sql databases aren't a great thing because of the number of "sub tables" needed (to store the inputs/outputs of the transactions, etc.) |