Have you missed the defunct phist.steemdata.comretired in May 2018 and the community was left without an easy tool to check the edit history of posts and comments. by @furion? Unfortunately, the project was
PhistSBDS (Steem Blockchain Data Service) instance on the SSD server for blazing fast searches. I tested SteemSQL but the searches were extremely slow for some reason, whereas on SBDS MySQL they took milliseconds! was written in Python and ran on a MongoDB back-end, which were both not my cup of tea. For a while I wanted to create a replacement for it but got busy with other coding projects. Until recently, the idea reoccurred to me, so I decided to dig into it, although the Python+MongoDB combination had previously dissuaded me from reviving the project. I looked at the code for inspiration (https://github.com/SteemData/phist.steemdata.com) and built a similar website fully in Node JS. For the database, I setup an
In a nutshell, SBDS allows dumping the blockchain into a MySQL database. Once I had that, after days of waiting for SBDS to build the database...
... I sprinkled some JS magic, then added some nifty loops with long hours of testing/debugging... and voilà, I proudly present to you:
Steem Scribe
https://scribe.steemian.info
(also accessible via non-SSL at http://scribe.steemian.info)The scribes were monks and clerics dedicated to record keeping. I found that notion appropriate.
Usage
- Paste the URL of the post or comment, then press
<Enter>or click the Submit button. You can use URLs from https://steemit.com or other websites like https://busy.org. - Click the scribe image to clear and go back to the main page.
Here's what a result would look like:
Notes
- SBDS is still experimental and may be buggy. In fact, the latest version doesn't run, so I used an old fork I had in my repository, with some little adjustments.
- I could have done it in PHP, however for the learning experience I went fully with Node JS. Besides, setting up a PHP website requires many packages (PHP, Apache, Let's Encrypt, etc.) and numerous configurations.
- Although the web page is mostly done, it's still a work in progress and may require more optimizations and tweaks. There may be some short down times.
- The database is a fat 675 GB, taking up 745 GB!
Switching from SBDS to S2DB
SBDS has fully built the database (with a few hick-ups) but it was having trouble streaming blocks to keep them updated. While searching for solutions, I've discovered today this kick-ass alternative S2DB by @dehenne (https://github.com/pcsg/pcsg-steem-blockchain-parser), which I implemented to take over where SBDS left. Things are looking good so far and the DB is keeping up with the blockchain every 10 seconds. You should be able to find results up to date 😃
Easter Eggs
The usual 404 will make you smile. If you achieve a 500 you'll laugh harder.
Available & Reliable. I am your Witness. I want to represent You.
🗳 If you like what I do, consider voting for me 🗳
once.
bookmark to open any post I am currently on into it.I use this everyday for @steemcleaners, so much so I created a
Just create a new bookmark and put this code as the URL, like shown in the screenshot. (works in Chrome, possibly Firefox? But it doesn't work in Edge. But why would you be using that 😁)
javascript:(()=>{location.assign("//scribe.steemian.info/?url="+location.href)})();Glad you find it so useful :)
I know I'm late to the party, but I just wanted to say this is a great tool, thanks for all your hard work!
The reason is very simple: there are no indexes on
authorandpermlinkon theTxCommentstable in SteemSQL.This table is rarely used and creating indexes on these columns will consume (waste) a lot of disk space because of the length of permlinks. That's why you got a huge database after dumping the blockchain into your MySQL database.
Should I add those indexes, you would get the same milliseconds results, like the one you have on the
Commentstable.oh this is pretty awesome. Excellent timing too Drakos, because now that we can edit the posts, some Batman activities would benefit greatly from this.
The Steem detectives will surely appreciate.
appreciated :)
steem is in good way
yeah your right brother :)
Great tool @drakos!!
I concur with @meno that this new tool will be indeed pretty valuable for us. Specially after the announcement that we can now edit our posts on steemit no matter how old they are.
Actually, I think your Monk went a few steps further than the also great tool Steemviz Viewsource by @ausbitbank that I've been using for the same task so far.
With your more evil one, it even shows us how many errors & edits we did the first time. Hahahaha
Good job buddy!! Continue polishing your 'evil' tool. };)
Nice, wasn't aware of his Viewsource tool.
Well, there you have it mate. That's the spirit to share knowledge & inspiration in a 'true community'. Isn't it? };)
thank you for your sharing, I like it !
I hope so you visit my blog. Welcome !
Hey Drakos -- I see we appreciated the same post by timcliff recently.
I keep intertwining with you -- you're someone I do appreciate on here.
Can you read my comment with bold-faced "thank you" on timcliff's recent post and see if you like it?
We're going to talk a lot more.. you and I.. as time goes on... cuz your name keeps coming up in my books. You're good for steem and I like your attitude towards it a lot.
....from a far... a friend. :)
@intelliguy
Steem post is very great i like dear brother you are a great man i like this post
Very good, I like this article, I hope you can give me voted, I have voted for you.@zero12345
Awesome tool @drakos! This goes to my handy Steem tool links
Nice work Sir. This is good for someone to use for their purposes in aiding their steemit experience. I already voted for your witness. Keep it up.
I like it...going to 1 terabyte :•}
Oh lord no! I'll have to upgrade the server, mucho expensive. There are lots of affordable high storage HDD servers, but building the database on them takes forever (I tried). SSD or NVME is the way to go. That being said, apparently S2DB allows creating specific tables instead of all the tables in SBDS. For Steem Scribe, the required table is only 115 GB. I'll play with that later, it would save a lot of space and expenses.
Thanks for the Easter eggs, atleast a surprise.
While not connected to your post, I came across this post , and realized you might just be the person to help me!
('cos you are dead clever with all this stuff, and I'm not)
Any help appreciated, mate.
https://steemit.com/blog/@lucylin/is-there-a-reason-i-can-t-scroll-back-more-than-6-months
wow thats great.. its realy helpful to us.
Always interesting reading and learning more about how all of this stuff works. Cool read @Drakos!
Thanks for that, @drakos! Bookmarked :-)
Interesting post!
(Would be great if you take a look my latest drawings )
Handy tool 😊
WARNINGCONFIRMED SCAM!
DO NOT FOLLOW any instruction and DO NOT CLICK on any link in the comment! - The message you received from @dulborah is a
For more information about this scam, read this post:
https://steemit.com/steemit/@arcange/phishing-site-reported-steem-link-premium https://steemit.com/steemit/@arcange/anti-phishing-war-the-crooks-continue-their-bashing-campaign
If you find my work to protect you and the community valuable, please consider to upvote this warning or to vote for my witness.
Flagged him as soon as he commented.
Nice post sir.
Keep steeming@drakos
Nice work, and thanks for bringing SBDS to my attention. I'm going to have a go at setting that up and maybe forking it for something I have in mind.
Hi @drakos!
Your post was just upvoted by @utopian-io. We invite you to join our developer community on the Steem blockchain to crowdsource your project development and promotion with Utopian.
Contributing on Utopian
Learn how to contribute on our website.
Want to chat? Join us on Discord https://discord.gg/h52nFrV
This post has received a 52.82 % upvote from @boomerang.
I am New Here But when i read post every one about steemit that time i say wowowowo...
Somehow you make coding sound intriguing, even fun. I'm glad you like it, anyway. Thanks for working on making the blockchain even more awesome!
After doing your magic tricks and dedicating hours you get a great job, to help the Steemians! Congratulations and thanks for contributing your knowledge for the good of the communityThis is amazing @drakos, you're always thinking of something!
Sehr guter und sorgfältig recherchierter Beitrag, weiter so
I suggest trying RocksDB!
I'm working on that to store custom_json ops in the database for using in the Dapps
I will give you a follow in return and possible future votes!I gave you an upvote on your post! Please give me a upvote(to this link https://steemit.com/@hammad97) & follow.
I see that you're freshly new on Steemit. I suggest you avoid doing "follow for follow" and "vote for vote". It's considered spam and will get you flagged. Instead, write meaningful comments to build an interested audience.
Your post was mentioned in the Steemit Hit Parade in the following category:Congratulations @drakos!
Don't understand much of that, but thank you for being someone who does, @drakos.
And thank you for your supportive upvote on our recent post! 🍌
thank you for your sharing, I like it !
I hope so you visit my blog. Welcome !
Steem is the best blockchain ever! I've never experienced an online community where my desire to create has been so uninhibited. I'm free to create content as I wish and others are free to read it. The beauty is in the simplicity and uncensored nature of this system that affords us a place to be free and explore.
There is no place like home and Steemit, to me, feels closer to home than I've ever gotten before as a creator. Truly a blockchain of opportunity and for that, I say thank you so much.
pretty awesome post.Really good approach on Posts and Comments History
upvote to me
Quite extensive information, it is worthwhile to keep sniffing about it hehehehe.
Just stumbled upon this tool and it seems to be working great!
Thank you for the great tool :)