RE: Hive Librarian App Features Update - Where is the Money?

avatar

You are viewing a single comment's thread:

Nice work geekgirl! Is it possible to do this with Hive-engine stuff as well? E.g. See all the different tokens, delegations and rich list there? I think internal market would also be cool.

I've been getting my head around HiveSQL the last couple of weeks too and my head hurts a lot. Programming and databases are a totally different world haha

hive-167922
0
0
0.000
7 comments
avatar

Thank You! I am not ready to plunge into Hive-Engine world, since I saw some evidence that data in Hive blockchain itself or HiveSQL won't be as accurate. This may need API or data from Hive-engine itself as well. @amr008 pointed out some instances that hive-engine token transactions recorded as double-spent kinda situations due to some bug in keychain, I believe.

Yes, internal market definitely something interesting. I hope to get there at some point.

I used to getting data directly from the blockchain using Beem too. It is great, but for some situations not fast enough. That's why I like HiveSQL due to the speed of getting data back.

I agree programming and databases are not the same. I have been wondering that whole week, when simple things just were not working on sql side lol. But combining both makes things more interesting.

I have a csv file as a reference how the HiveSQL database is structured with tables and columns. So that it is easy to figure out where what is. I wrote about it in one of my HiveSQL posts how to get that. If you need it, I will be glad to share or anything else you might need.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

I agree completely .For hive-engine we need to use API but it is not as quick as HiveSQL .

The app that I have built is an example for this , it is not as quick as Hive Librarian. As the data gets bigger , it will further slow down (right now I am using csv whereever possible )

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

Yes I've seen that tool that @amr008 has developed and it's really handy too for checking dividends! That sounds a little concerning WRT the bugs you mentioned, can see why getting data off H-E is a lot more difficult...

Haha, I had so many teething issues trying to get data from HiveSQL but I'll check your post out as I would like to run a few queries myself relating to author/comment rewards and things like that. If you have a link to it, that would be great thanks!

0
0
0.000
Reply
avatar

I am not sure if it is actually a bug or not. H-E itself works fine, just some transactions are recorded twice on Hive for some reason. I think it may be possible to use both HiveSQL and the H-E Api for more efficiency. But I haven't used the api yet. So not sure.

I use SQL within my python scripts. Here are couple posts on how to get started with HiveSQL in python.

https://hive.blog/hive-167922/@geekgirl/using-hivesql-with-python-on-mac

https://hive.blog/hive-167922/@geekgirl/hivesql-with-python-tables-and-columns

I think for what you are trying to do, you will be using two HiveSQL tables - Comments and TxVotes.

I used to use those when I was active curating for Curie.

Posted Using LeoFinance Beta

0
0
0.000
Reply
avatar

When you plan to dive into Hive-engine, my request is to add to view only purchase/buy and only sell from any account like options which exclude the rest of the details about other transactions.

Posted Using LeoFinance Beta

0
0
0.000
Reply