I usually use tools such as beem which is a python library for exploring the blockchain, but I agree I constantly refer back to steemd and stermdb .
I have to take this opportunity to plug a tool I developed for exploring user posting history. It's still in development but there is lots to come
https://eroche.shinyapps.io/SteemAnalytics/