steemQL 0.6.2 - Voting and Metadata

in #utopian-io6 years ago (edited)

A new update for steemql is out. This one adds the ability to vote and query votes for posts. Hence all basic features to interact (posting, commenting, voting) are available now. As an extra benefit, the json_metadata field of posts is now parsed and the standard fields like image, tags, links etc. are now returned as a direct property of posts. If the don't exist, null is returned. No need to deal with that on your own. Have fun...

New Features

  • Vote on posts
  • Get active votes for posts (standalone or inside a post query as a sub query)
  • Standard properties from json_metadata as direct post properties (pre-parsed)

Roadmap

  • Add related data, e.g. get all comments of posts inside a user query
  • Adding missing properties for important custom queries like posts, user etc.
  • Adding extra convenience properties like formatted or calculated values (e.g. total balance, reputation)
  • Subscriptions for post/comment related queries, to use with GraphQL Clients like Apollo

Contribution

Any kind of contribution is welcome, mainly feedback and feature requests.

GitHub: steemQL

Discord: https://discord.gg/NgezG

steemit.chat: @sarasate

Projects using steemQL:

steemQL In Action

The whole Insteem Site is using steemql. If you e.g. wanna figure out who mentioned you in a post or comment, have a look here: https://www.insteem.com/mentions/@sarasate

Here is a sample query to get posts including images, tags and links and the user object:

{
  posts {
    id
    title
    tags
    format
    app
    links
    community
    user {
      id
      name
    }
  }
}

Play with it: steemQL Server. To get documentation for available queries, hit the green Schema button on the right.

Screen Shot 2018-02-14 at 23.39.10.png

If you're not familiar with GraphQL, here you go.



Posted on Utopian.io - Rewarding Open Source Contributors

Sort:  

Thank you for the contribution. It has been approved.

You can contact us on Discord.
[utopian-moderator]

Hey @sarasate I am @utopian-io. I have just upvoted you!

Achievements

  • Seems like you contribute quite often. AMAZING!

Community-Driven Witness!

I am the first and only Steem Community-Driven Witness. Participate on Discord. Lets GROW TOGETHER!

mooncryption-utopian-witness-gif

Up-vote this comment to grow my power and help Open Source contributions like this one. Want to chat? Join me on Discord https://discord.gg/Pc8HG9x

Sneaky Ninja Attack! You have been defended with a 1.22% vote... I was summoned by @lupo! I have done their bidding and now I will vanish...Whoosh

Hey, I've tried contacting you through discord but there's and error saying your invitation link has expired

Hi, which link did you use? you can find me as @sarasate directly..

Coin Marketplace

STEEM 0.28
TRX 0.12
JST 0.032
BTC 69731.54
ETH 3810.82
USDT 1.00
SBD 3.84