Re:Show HN: An SQL database on top of a blockchain
by misterdata on Tuesday June 13, 2017 @04:54PM
(#14548560)
Yes, so what this does is timestamp transactions (in this case SQL DML) in a decentralized way between nodes that do not or cannot trust each other. All this while enforcing write permissions ('grants') that were agreed upon earlier.
The idea that some of these transactions store data is not any different from the idea that some transactions in Bitcoin add new coins to the system, or that some transactions in Ethereum create and store contracts (which are code and data).
Now of course you could, instead of storing the actual data and/or SQL, put data in a DHT and reference and timestamp that.
Re:Show HN: An SQL database on top of a blockchain
by dozzie on Tuesday June 13, 2017 @05:10PM
(#14548675)
> Yes, so what this does is timestamp transactions (in this case SQL DML) in a decentralized way between nodes that do not or cannot trust each other. All this while enforcing write permissions ('grants') that were agreed upon earlier.
And this should be the very first thing to put in README. This is the single most important thing about any program that uses a blockchain protocol: what exactly is the decentralized, adversity-proof timestamping used for. Right after that should be placed rationale, i.e. how does the hostility resistance help compared to cooperation-based protocols.
Re:Show HN: An SQL database on top of a blockchain
by GhostVII on Wednesday June 14, 2017 @08:13AM
(#14552137)
Why would that need to be in the README? Isn't it the whole point of blockchain?
Re:Show HN: An SQL database on top of a blockchain
by misterdata on Wednesday June 14, 2017 @10:00AM
(#14552740)
I think it is actually a good idea to describe the whole point of using a blockchain as suggested. A lot of organisations I encounter don't really have a clue and do not realize that even a traditional database could fill their need perfectly in many cases.
Quite the opposite. Using blockchain for anything but timestamping is worthless, because there are faster and less resource-intensive protocols for about everything. Data storage, for instance, has distributed hash table, and change coordination has leader election or consensus protocols.
> Bitcoin, Ethereum and others don't use a blockchain just for timestamping either, but store all sorts of data in it (transactions in Bitcoin and even complete programs in Ethereum).
You're putting the cart before the horse. These "all sorts of data" in blockchain are in fact documents that get timestamped -- the timestamp says "document X was issued before document Y". A Bitcoin transaction in isolation from all the other transactions is nothing more than a semi-random string of bytes. For it to be a money-like thing you need to have previous transactions (and how do you know they're previous? by timestamp) that testify the account had enough resources for all the output.