6 ms·

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 l

by remcob 9y 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!

gtrubetskoy 9y ago
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. :)
- NegativeLatency 9y ago
  Sounds like they were thinking of some kind of way of running Postgres on a blockchain, vs using Postgres to process the blockchain.
misterdata 9y ago
So something like Catena (https://github.com/pixelspark/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).
- gtrubetskoy 9y ago
  Cool stuff, interesting choice of language - are you not concerned that this limits you to mostly OSX?
  - unkown-unknowns 9y ago
    Readme has instructions for building on Linux so it's not limited to OS X.
devrandomguy 9y ago
I thought that it was going to log transactions to a blockchain, as a sabotage-resistant backup strategy.

by remcob 9y ago

gtrubetskoy 9y ago

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. :)

NegativeLatency 9y ago
Sounds like they were thinking of some kind of way of running Postgres on a blockchain, vs using Postgres to process the blockchain.

misterdata 9y ago

So something like Catena (https://github.com/pixelspark/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).

gtrubetskoy 9y ago
Cool stuff, interesting choice of language - are you not concerned that this limits you to mostly OSX?
- unkown-unknowns 9y ago
  Readme has instructions for building on Linux so it's not limited to OS X.

devrandomguy 9y ago

I thought that it was going to log transactions to a blockchain, as a sabotage-resistant backup strategy.