Re:SQL on Ethereum Blockchain with Presto
by AlwaysBCoding on Tuesday July 25, 2017 @03:22PM
(#14851030)
Business model for you: Host a node yourself, and charge a micropayment in ETH to make SQL queries against the DB.
[ Parent
| on HN ]
Re:SQL on Ethereum Blockchain with Presto
by WaxProlix on Tuesday July 25, 2017 @05:02PM
(#14851829)
Interesting - Presto-As-A-Service is hard to do because of the way it handles permissions / auth. With an inherently shared resource like a blockchain it becomes a lot more feasible.
Re:SQL on Ethereum Blockchain with Presto
by pweissbrod on Tuesday July 25, 2017 @06:01PM
(#14852277)
If im not mistaken presto-as-a-service is the power behind aws athena. They charge by the bytes scanned.
Re:SQL on Ethereum Blockchain with Presto
by WaxProlix on Tuesday July 25, 2017 @06:13PM
(#14852349)
I'm not interested in the charging so much as how they handle privacy and security for multiple users/accounts in (supposedly) a single Presto cluster.
How do you account for the cost of the transaction itself? Those aren't cheap.
Re:SQL on Ethereum Blockchain with Presto
by meesterdude on Tuesday July 25, 2017 @04:36PM
(#14851627)
Querying the blockchain does not cost anything, just making changes to it. Otherwise, verifying transactions would be a recursive cost. I could be wrong though, but pretty sure since it's distributed reads are free, writes are where it costs.
Re:SQL on Ethereum Blockchain with Presto
by tylersmith on Tuesday July 25, 2017 @04:42PM
(#14851669)
I think he means for the micropayment. For that system to be viable it would need Raiden or some other payment channel system.
Re:SQL on Ethereum Blockchain with Presto
by tylersmith on Tuesday July 25, 2017 @04:43PM
(#14851677)
The tech isn't quite here yet but payment channels would be a good solution.
Payment channels alone are only a good solution if you consider it acceptable to establish a payment channel with everyone you want to pay. So, in other words, it only makes sense for recurring payments to the same merchant, and you pay the blockchain fee once for each merchant you want to pay. Consequently, if you only pay once you pay the same fee as an on-chain transaction, and if you pay 1000 times you pay, in average, 1000th the blockchain fee per payment.