Skip to content

Instantly share code, notes, and snippets.

@TrevorBenson
Last active January 15, 2021 14:49
Show Gist options
  • Select an option

  • Save TrevorBenson/575206f357fab9f2a58c337856c40db3 to your computer and use it in GitHub Desktop.

Select an option

Save TrevorBenson/575206f357fab9f2a58c337856c40db3 to your computer and use it in GitHub Desktop.
What db-sync queries I would like to see.
Quantity of current valid pools
Get the stake distribution for a specified pool, for [a given epoch | any epoch | >= or <= epoch]
Get the number of blocks created by a specified pool, for [a given epoch | any epoch | <= or >= epoch]
Get the number of blocks created by a specified pool for every epoch
Get the delegation history for a specified wallet
Get the reward history for a specified wallet
@TrevorBenson
Copy link
Author

@rcmorano Thanks for the content contribution to this gist.

This is the first time I have looked at dandelion.link, I had not realized it was a free API backend for Cardano which tied into GimbaLabs, which I also hadn't had a chance to check out yet. I'm already loving seeing new content about token transactions and using asciinema "asciicasts" as video demo's.

These provide options which remove the requirement for db-sync. I will have to review the API's, most likely I will build a postman collection to compare the datasets between the db-sync query and the dandelion.link output to see if we can construct the same table datasets.

If your interested in contributing thoughts we are starting a discussion under the cardano-community which I invite your input on. Your mentioned in the initial discussion so will know of it momentarily.

Thanks!

@rcmorano
Copy link

You are welcome @TrevorBenson, glad you are liking our open stuff :)))

I'll be working on updating the postgREST doco on gimbalabs.com this week to include all the examples in this gist and some others, and I was also thinking on adding, not a postman collection, but a hopsscotch (former postwoman) one :D
As I commented on cntool's related issue, feel free to use dandelion endpoints, my aiming is to keep them open/standard so no one is locked in, and eventually maybe democratize such service so it becomes something greater than a playground for people prototyping things :)

@TrevorBenson
Copy link
Author

TrevorBenson commented Jan 12, 2021

@rcmorano

I'll be working on updating the postgREST doco on gimbalabs.com this week to include all the examples in this gist and some others, and I was also thinking on adding, not a postman collection, but a hopsscotch (former postwoman) one :D

I'm not stuck on postman by any means. Any tool to help build a swagger/openapi like spec/def is acceptable to me.

Also interested in your thoughts on democratization. My goals are to support the testnet(s) and mainnet in various ways and that includes collaborative efforts. One thing I'm (slowly very very slowly) working on is providing something like minimum pooltool.io for the testnets. Feel free to DM me for further discussion if you have interest.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment