RE: Tower: A REST API implementation on the top of Hivemind

You are viewing a single comment's thread from:

Tower: A REST API implementation on the top of Hivemind

in utopian-io •  6 years ago 

Not with the api, yet :) I will add it if it returns in a feasible time to serve in the api.

utopian-io
6 years ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.03
  • Past Payouts $0.03
  • - Author $0.02
  • - Curators $0.01
2 votes
5
Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  
  • Trending
    • [-]
      ·  6 years ago 

    @emrebeyler I added an index for it (took about 15 minutes) with

    CREATE INDEX ON hive_posts_cache((json::json->>'app'));

    and then I could query like this

    SELECT json::json->>'app' as app, author, permlink, body, created_at from hive_posts_cache where json::json->>'app' like 'busy%' order by post_id desc limit 100

    image.png

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $1.35
    • Past Payouts $1.35
    • - Author $1.09
    • - Curators $0.26
    2 votes
    [-]
      ·  6 years ago (edited)

    This is great @jrawsthorne!

    How long does this example query take to complete after the index?

    Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

    • Disagreement on rewards
    • Fraud or plagiarism
    • Hate speech or trolling
    • Miscategorized content or spam

    Submit
    $0.00
      [-]
        ·  6 years ago 

      145ms
      image.png

      Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

      • Disagreement on rewards
      • Fraud or plagiarism
      • Hate speech or trolling
      • Miscategorized content or spam

      Submit
      $0.00
        [-]
          ·  6 years ago 

        Fantastic. Thanks for the tip. I will try adding an additional index after the hive update/migration.

        Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

        • Disagreement on rewards
        • Fraud or plagiarism
        • Hate speech or trolling
        • Miscategorized content or spam

        Submit
        $0.00
          [-]
            ·  6 years ago (edited)

          Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

          • Disagreement on rewards
          • Fraud or plagiarism
          • Hate speech or trolling
          • Miscategorized content or spam

          Submit
          $0.00