You are viewing a single comment's thread from:

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

in #utopian-io • 6 years ago (edited)

Yes. It's possible. But I limited the options on posts and post_cache tables because these tables are huge. To make the queries efficient I need to add indexes targeted for them. For example, Tower will support json_metadata.app filters soon.

6 years ago in #utopian-io by
$0.04
  • Past Payouts $0.04
  • - Author $0.04
  • - Curators $0.00
1 vote
Reply 3
Sort:  
  • Trending
    • [-]
     6 years ago  

    Do you have an idea when such search API will be available? With AskSteem being shutdown, I’m looking for a replacement for my @steemtelly project

    Posted using Partiko iOS

    $0.00
      Reply
      [-]
       6 years ago  

      Probably in the next couple of weeks. What kind of queries do you use? I am gathering this data to create additional indexes on the database side.

      $0.00
        Reply
        [-]
         6 years ago (edited) 

        Great!
        I use the same asksteem queries as on dtube website. They are still there despite the asksteem API returning an error, so you can see what they are exactly. But to summarise:

        • recent dtube posts for an author
        • related content, probably dtube posts that are using the same tag as the current post. The way you make sure it’s a dtube content that has a video is by checking that json_metadata contains the ‘video’ property
        • searching posts by keywords inside title and body
        • searching posts by tag
        • searching posts by author
        • combine the three above with a filter that look for the ‘video’ property in the json_metadata

        I believe asksteem is using Solr or Elastic search and you can enter the lucene query in the URL query string

        Posted using Partiko iOS

        $0.00
          Reply