Oh man this looks way easier than trying to pull data from the chain directly. Rebloged for later reference. Dose this SQL data base contain layer 2 info or just L1? Either way, I guess my next HBD will go to archange.
Edit: This is so easy to use! Thank you so much for putting this post together. Now I have made my first useful bit of code that interacts with the block chain!
Its not much, but a very fast start.
For sure and SQL offers some automation like in my example it pulled up all the relevant info for the curation rewards for @duo-curator for any dates from 2025-02-03 to a few hour earlier today, that would be a whole lot of manual work finding all the posts and doing the math, unfortunately getting information with hivesql in regards to layer 2 tokens is not going to work, I believe you will need to use the hive engine API to access such data I can look into releasing a guide once I figure it out 🤣