Sort:  

You should never share your credentials!
Shall someone else uses them and does something harmful to HiveSQL, they could be permanently revoked and lock you out.

All right got it .

I used HiveSQL for everything related to hive but I learnt that custom json is not reliable so only for those transactions I had to shift to Hive-Engine API , any advice on this?

Posted Using LeoFinance Beta

Hive-Engine API is the way to go as their data is maintained off-chain.

Yup , doing that now.

Still i have to go through every block to retrieve the transaction details .

Right now I have stored one month data in persistent dictionary ( Shelve ) .