News for hackers. Stuff that matters.
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.
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.
Re:SQL on Ethereum Blockchain with Presto by granda on Tuesday July 25, 2017 @04:24PM (#14851529)
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.
Re:SQL on Ethereum Blockchain with Presto by runeks on Wednesday July 26, 2017 @01:47AM (#14853893)
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.
Re:SQL on Ethereum Blockchain with Presto by xiaoyao on Tuesday July 25, 2017 @04:54PM (#14851776)
+1, I have another project on payment channels, coming soon