View this post on Hive: Steem Scribe - Posts and Comments History
Steem Scribe - Posts and Comments History
6 years ago by drakos (70)
$208.78
- Past Payouts $208.78
- - Author $165.80
- - Curators $42.98
574 votes
- + utopian-io: $61.767 (25%)
- + therising: $26.540 (34.5%)
- + boomerang: $23.929 (52.82%)
- + acidyo: $18.617 (75%)
- + wackou: $14.924 (100%)
- + ausbitbank: $13.661 (100%)
- + pfunk: $9.358 (100%)
- + surpassinggoogle: $7.954 (23%)
- + drakos: $4.244 (100%)
- + ipromote: $4.031 (25%)
- + newhope: $3.321 (22%)
- + clayop: $3.279 (100%)
- + followbtcnews: $2.107 (100%)
- + timcliff: $1.777 (87%)
- + firepower: $1.746 (25%)
- + verodato: $1.374 (100%)
- + pfunk3: $1.201 (100%)
- + roxane: $0.787 (20%)
- + nainaztengra: $0.706 (100%)
- + techslut: $0.623 (100%)
- … and 554 more
I use this everyday for @steemcleaners, so much so I created a bookmark to open any post I am currently on into it.
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 😁)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Glad you find it so useful :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
The Steem detectives will surely appreciate.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
appreciated :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
steem is in good way
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
yeah your right brother :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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. };)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice, wasn't aware of his Viewsource tool.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Well, there you have it mate. That's the spirit to share knowledge & inspiration in a 'true community'. Isn't it? };)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you for your sharing, I like it !
I hope so you visit my blog. Welcome !
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Steem post is very great i like dear brother you are a great man i like this post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very good, I like this article, I hope you can give me voted, I have voted for you.@zero12345
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for that, @drakos! Bookmarked :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Interesting post!
(Would be great if you take a look my latest drawings )
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Handy tool 😊
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
WARNING - The message you received from @dulborah is a CONFIRMED SCAM!
DO NOT FOLLOW any instruction and DO NOT CLICK on any link in the comment!
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Flagged him as soon as he commented.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@drakos
Nice post sir.
Keep steeming
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This post has received a 52.82 % upvote from @boomerang.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I am New Here But when i read post every one about steemit that time i say wowowowo...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Awesome tool @drakos! This goes to my handy Steem tool links
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is amazing @drakos, you're always thinking of something!
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 community
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Just stumbled upon this tool and it seems to be working great!
Thank you for the great tool :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Sehr guter und sorgfältig recherchierter Beitrag, weiter so
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I suggest trying RocksDB!
I'm working on that to store custom_json ops in the database for using in the Dapps
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I gave you an upvote on your post! Please give me a upvote(to this link https://steemit.com/@hammad97) & follow.
I will give you a follow in return and possible future votes!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @drakos!
Your post was mentioned in the Steemit Hit Parade in the following category:
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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! 🍌
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I like it...going to 1 terabyte :•}
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for the Easter eggs, atleast a surprise.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you for your sharing, I like it !
I hope so you visit my blog. Welcome !
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
pretty awesome post.Really good approach on Posts and Comments History
upvote to me
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Quite extensive information, it is worthwhile to keep sniffing about it hehehehe.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow thats great.. its realy helpful to us.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Always interesting reading and learning more about how all of this stuff works. Cool read @Drakos!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
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.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit