News for hackers. Stuff that matters.
Re:Show HN: Pg_blkchain – Postgres blockchain extension by remcob on Saturday October 21, 2017 @01:27PM (#15522617)
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!

Re:Show HN: Pg_blkchain – Postgres blockchain extension by gtrubetskoy on Saturday October 21, 2017 @01:44PM (#15522688)
Apologies, the title should have contained POC.

I am not sure what you mean by "blockchain based distributed consensus" - did you mean the the ability to group transactions into blocks and being able to verify those? It's possible, and that's the plan, it is, however, very complicated to build something that you can actually trust like the bitcoin core.

I think that a better use for this sort of thing is the ability to analyze the blockchain.

But something that would provide "full node" functionality I think is interesting as well. There would still need to be some sort of a program running in front of it to do all the network communication...

Anyway - the point of this little project is to really get some feedback on the general approach and then see where to take it next. :)

Re:Show HN: Pg_blkchain – Postgres blockchain extension by NegativeLatency on Saturday October 21, 2017 @03:54PM (#15523322)
Sounds like they were thinking of some kind of way of running Postgres on a blockchain, vs using Postgres to process the blockchain.
Re:Show HN: Pg_blkchain – Postgres blockchain extension by misterdata on Saturday October 21, 2017 @01:51PM (#15522711)
So something like Catena (https://github.com/pixelspark/catena, I wrote this)? It does SQL based on Transactions stored in a Blockchain (and coincidentally speaks the postgres pq client protocol).
Re:Show HN: Pg_blkchain – Postgres blockchain extension by gtrubetskoy on Saturday October 21, 2017 @02:05PM (#15522776)
Cool stuff, interesting choice of language - are you not concerned that this limits you to mostly OSX?
Re:Show HN: Pg_blkchain – Postgres blockchain extension by unkown-unknowns on Saturday October 21, 2017 @04:21PM (#15523436)
Readme has instructions for building on Linux so it's not limited to OS X.
Re:Show HN: Pg_blkchain – Postgres blockchain extension by devrandomguy on Saturday October 21, 2017 @02:16PM (#15522823)
I thought that it was going to log transactions to a blockchain, as a sabotage-resistant backup strategy.