|
Title: SQL Schema for storing blockchain transactions Post by: BitCoinWarrior on May 09, 2013, 11:49:02 AM anyone have one they are willing to share/point us in the right direction?
Title: Re: SQL Schema for storing blockchain transactions Post by: spiccioli on May 09, 2013, 02:14:34 PM anyone have one they are willing to share/point us in the right direction? Hi, see here https://bitcointalk.org/index.php?topic=103277.0 spiccioli Title: Re: SQL Schema for storing blockchain transactions Post by: BitCoinWarrior on May 09, 2013, 03:03:55 PM thanks for that.
we were looking to store all inputs/outputs not just unspent outputs. we want to be able to query anything in the chain like blockchain.info. Title: Re: SQL Schema for storing blockchain transactions Post by: HeroC on May 09, 2013, 08:48:01 PM Nice topic number. :D
Title: Re: SQL Schema for storing blockchain transactions Post by: kiko on May 09, 2013, 09:21:57 PM libbitcoin by Amir Taaki (genjix) used a postgres back end:
https://gitorious.org/libbitcoin/libbitcoin/blobs/master/bitcoin.sql (https://gitorious.org/libbitcoin/libbitcoin/blobs/master/bitcoin.sql) hth. |