Hacker News new | ask | show | jobs
by williamcotton 3907 days ago
You're right, Bitcoin doesn't natively have a way to query a database, but here's an example of a how to read Blockcast transactions from the blockchain:

https://github.com/blockai/blockcast-state-engine/blob/maste...

The next step would be storing the results in a SQL database as we do with our production servers that maintain a queryable database of Open Publish registrations and transactions (Open Publish uses Blockcast for storing metadata on digital media assets).

https://github.com/blockai/openpublish-state

This is definitely a more piecemeal approach to creating smart contract applications than with Ethereum's one-stop-shop, but there are benefits to building on top of Bitcoin, especially for Open Publish, which uses native Bitcoin transactions for payments and royalties.