Re: [Bitcoin-development] Blockchain alternative storage

2013-06-06 Thread Jouke Hofman
Abe is able to do what you want. https://github.com/jtobey/bitcoin-abe https://bitcointalk.org/index.php?topic=22785.0 With kind regards, Jouke Hofman Bitonic.nl On 06/06/2013 02:53 AM, Marko Otbalkana wrote: > Could anyone point me to work/project(s) related to storing the block > chain in a

Re: [Bitcoin-development] Blockchain alternative storage

2013-06-05 Thread Petr Praus
BitcoinJ is storing parsed blocks (not the whole chunks of bytes) in H2, an embedded SQL database for Java. On 5 June 2013 19:53, Marko Otbalkana wrote: > Could anyone point me to work/project(s) related to storing the block > chain in a database, like PostgreSQL, MySQL? How about any tools tha

Re: [Bitcoin-development] Blockchain alternative storage

2013-06-05 Thread Patrick Strateman
If you're only interested in storing the best chain then a fairly simple schema is possible. CREATE TABLE blocks ( hash bytea NOT NULL PRIMARY KEY, index integer NOT NULL UNIQUE, CONSTRAINT block_hash_size_check CHECK ((octet_length(hash) = (256 / 8))) ); CREATE TABLE transaction_inpu