Show HN: Pg_blkchain – Postgres blockchain extension

gtrubetskoy | 75 points

Please rename this. This is not a pg-based blockchain or anything like that, just a Bitcoin extension to pg. And guess what Bitcoin is not the only blockchain out there...

dna_polymerase | 6 years ago

From the name and the title, I was hoping it would be a prototype blockchain based distributed consensus extensions for Postgres. I have to admit that I was a little bit disappointed to discover that it is a collection of transaction parsing functions for the Bitcoin blockchain.

Nevertheless, cool project! Definitely something I should have used a year ago instead of the slow cludge of Python scripts I build!

remcob | 6 years ago

This is awesome. I can't seem to under why most blockchains insist on using leveldb as their transactional data store. In fact, the bitcoin devs have admitted some of the attacks are specifically targeted towards the non ACID nature of leveldb.

It would be so much better to use postgresql as the data store. But it seems there is a natural aversion to non-embedded databases.

sandGorgon | 6 years ago

For a good C-bitcoin library you can use breadwallet-core: https://github.com/breadwallet/breadwallet-core

ssutch3 | 6 years ago

Can someone explain what this is for or could be used for? It seems like it allows you to store, process, and verify the blockchain inside postgres, right?

0xCMP | 6 years ago

A colleague was hard-pressing me about which advantages could Postgres have in relation to M(ySQL|ariaDB), these extensions (not this particular extension, but the concept of) seems to be a definitive advantage.

epx | 6 years ago