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