If you have been posting on Hive for any length of time your posts can become lost, difficult to find.
To quote @scaredycatguide "The Blockchain is the opposite of Vegas, what goes on the blockchain stays on the blockchain!"
but
for most people that doesn't mean you will ever be able to find your old posts again.
If you are technical you have many ways to access your posting history. Hive SQL is by far the best resource for Hive, it's built and maintained by @arcange and serves up all the important data and makes it easily accessible to the hive Community.
Post List and Voting History...
Today I was running a few different queries on HiveSQL and wanted to share an easy to use broswer the community could use.
The links below are two front ends that query Hive SQL to get the data but present it in a searchable webapp format. You don't need to be a technical user.
Try it out today, amd let me know what you think.
Vote List
Get a list of all the votes any user has made
https://eroche.shinyapps.io/hiveVotes/
Post List
Get a list of all the posts any user has made
https://eroche.shinyapps.io/hivePosts/
A Trip down Memory Lane
To see these in action why don't you take a trip down memory lane.
- Who was the first account you voted for?
- What was your first post?
The first person I voted for was @krnel for this post https://hive.blog/@krnel/what-is-the-blockchain-blockchain-2-0-and-steemit-building-the-future
The first post I made was https://hive.blog/@eroche/blockchain-beyond-bitcoin
The first comment I made was in reply to my second post https://hive.blog/@eroche/re-jahtech-re-eroche-do-you-use-a-bitcoin-debit-card-20161024t080210279z
- This post is my daily contribution to a challenge by @dragosroua to "publish a meaningful post every day of January"
Who's Up For A January Writing Streak?
The vote list sounds great!! I assume you can search search by account? Can I do it by date as well? I'm on mobile so can't see the full function, gonna check it out on computer in a minute
I can add a date filter for you no problem. I should probably put one in to limit the default queries also. I'll sort it out in a couple of days. In the meantime you can sort the table by date which might give you what you need.
Just got on the site on my computer and sorting votes by dates. The default page is 10 posts starting from 21st June 2017 (wow! such a long time ago),
If I click on date sort, this is what I see. The dates looks a bit random?
But data filter would definitely be great. Thanks!!
Just looked at this and not sure why this sorting isnt working for you, but I will put in some date filters and a download button which will help too
In the meantime if you try sorting by the timestamp column you might have more luck.
Just made some updates so let me know if that works better.