- Migration complete and a few thoughts on it's future.


Well, it took longer than I anticipated, but is slowly coming back to life.

The data migration I started a couple days ago completed earlier today and I'm bringing the services back online. If you still see the "DB Migration" message still (on every page), your DNS has not updated to the new server. The DNS should update in the coming hours and the site will then become available once more.

If you're very impatient, you can always access the site via it's IP address:

New Server

The new server SteemDB is hosted on is now provided by @privex, and I've had great support from @someguy123 getting this all setup.

SteemDB went from a 96gb RAM server with 8 cores to a 256gb RAM server with 12 cores. I've optimized and upgraded all of the software to the latest versions, configured the filesystem for high IO throughput, and should have plenty of room to grow over the next year or so.

Current Issues and Status

A few notes about this new deployment and issues surrounding the migration:

  • The database sync is currently catching up, as I write this it was processing block 18636474 (2018-01-02). So currently the 9 most recent days of data are missing from some sections. This new server is processing these blocks at a rate of about 3-6 blocks/second. We are currently at a height of 18892572, which means there's about 250k blocks that need to be processed. At a rate of 3 blocks per second (to be conservative), it will catch up to the current block height and finish processing in about 24 hours.
  • The witness pages and other sources that pull data live are unaffected by the sync process, but pages like an accounts transfers/votes will be impacted by the sync.
  • The account history module is disabled for the next 24 hours, so no new snapshots of accounts will be created until the sync is completed.
  • The apps page is missing data and somewhat broken, and I will investigate what's happening here. It's most likely due to the inactive history module, which also creates snapshots of app usage.
  • The homepage is no longer cached, so it's somewhat slow. I'll work on caching this again in the future.
  • Any missed blocks by witnesses during this migration were not recorded unfortunately.

Where SteemDB goes from here

Over the past month I've been doing a lot of thinking about the various projects I maintain in regards to the Steem ecosystem, and one reoccurring thought I have is that I have too many active projects. I am still in the planning phases, but one of my goals in 2018 is to shed or offload some of this workload so I can focus on the projects that actually matter to me, as well as the ecosystem as a whole.

With that being said, SteemDB isn't one of the projects that I want to personally stop maintaining. For months now in casual conversations I've mentioned that I really want to rebuild SteemDB and create a v2 of my block explorer code, and I am hoping to find the time to do so this year. SteemDB was my 2nd Steem related project (created Aug 2016) and I've learned so much since it's creation.

In 2018, I would very much like to take the time to sit down and rebuild SteemDB into something better. Improve the technology, the scalability, it's responsiveness, and usefulness. These foundational tools (wallets, blockexplorers, etc) are crucial to on-boarding new users and developers alike, while providing external transparency into the operations happening on the blockchain.

Luckily, this new server has room to grow, and I can fit a v2 right alongside v1 until it's ready to replace it :)

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  trending

Awesome, now lets get some content to the top thats has some artistic nature to it! Right now its all dominated by memes and blockchain news. Please check out my new grand canyon time lapse films if you have a moment. Thanks!


I couldn't agree more. Once we start having less of a crypto focus and more of a general focus... that's when Steemit will really start to take off.

Good luck taking this app to the next level.

  ·  작년

Hi @Jesta,

I heard you during the meeting on Discord in December. I use this comment section as an opportunity to thank you for the work you are carrying out for the community. I discovered Steemit about 3 months ago, am now completely immersed into it and am pretty amazed about what is going on here!

And a lot of this originates from people like you.

So, warm thanks :-)

  ·  작년

It's a pretty deep rabbit hole :)



@jesta my Dear friend Your Such Great posts Check My Blogs Did You like Support Me Thank you bro

  ·  작년

yes its great.
thanks for nice words.


we're pioneers ;)

Best of luck for your data migration work, I hope you did it very well and in the future you will do better work.

That's a monster server!

Out of curiosity is the data stored on SSD drives?

  ·  작년

Yup, all stored on SSDs, and the entire DB is kept loaded in RAM for even faster access.


Explains why you need that monstrous amount of ram lol kudos!

  ·  작년

Checking it now, very cool!

so interesting!

  ·  작년

Never knew this wesite and I know almost all the tools. Thanks man, I'll check it out!


Hey all!
I have put together some picks. They are low market cap coins that I believe have great potential for profit. Obviously there is risk and do your own diligence before buying. I am not a financial planner or advisor.
In no particular order:

  1. AirSwap AST (Binance)
  2. Lamden TAU (EtherDelta)
  3. Loopring LPC (Binance)
  4. aelf ELF (Binance)
  5. Luxcoin LUX (Cryptopia)

(Follow me on my new Steemit for daily picks, and have an excellent day!)


I bought AirSwap in Binance some weeks ago.Good call

  ·  작년

good . thanks for sharing nice information.


Absolutely. All the analytics sites that are being built are a huge help to managing accounts.

  ·  작년

You are right bro, the system needs more tools to gain control of our accounts.


I'm learning about new tools as I don't know about more #steemit tools.

  ·  작년

Yes, I've the same minings as you, shohana1


wow we both are learning, nice to meet you new friend


I also will check this out! Thank you 👍🏽
Upvoted 👍🏽👍🏽👍🏽

  ·  작년



How did I not know about this, the website looks amazing man! Glad someone tipped me off to follow you, please keep improving the site, I think it's looking clean and professional already, and so much info, this is an awesome find for me.

Voted for you as witness, really appreciate the work!


true, totally agree with you! there needs to be more awareness of the site!



it's good!

Finally I can see how much my reputation SUCKS :P


better than mine. I'm not even worth 3 bucks. Way to depreciate one's organs, steemit.

  ·  작년

Well, it took longer than I anticipated, but is slowly coming back to life.

Glad to know @jesta. Thank you for your contribution! SteemDB is a very helpful service!

Sounds like things are progressing well. You always do the best work and i can tell you work hard. Thanks for everything you do here for all of us

wow, thats some upgrade ,from 8g to 25g, its nice to have back online, missed using it,a very resourceful steemit/steem data collection site

I love jesta creations. Thanks for the hard work you do. We need it. :)


I agree with you, we need it.

Thanks for the update, @jesta. Which projects are you thinking about offloading? I agree that a richly featured block explorer is vital for people to understand what's going on under the hood. I'm glad that's not the one you are considering dropping.

Thanks for the updated information and looking forward to SteemDB.

  ·  작년

Glad to see it coming back as I know so many of us rely on it!

Great though on future.

Are there plans for dealing with the copy/paste reply bots that people are using to game this system? How about for disincentivizing people to post crap comments that contribute nothing? These kinds of things are going to be very bad for this platform in the long run if a stop isn't put to it early on.


While I agree with your sentiment, the question then becomes (as in the real world) who is to judge what is a bad comment or in searching for the users gaming the system? How do we find the middle ground where that type of system doesn't censor opinions that are unpopular or that deal with sensitive topics? The second this turns into a Twitter or Facebook with censoring users I believe this platform is heading in the wrong direction.

  ·  작년

I agree, they are problems. There's a lot of talk happening on this subject at this point between the witnesses but no concrete answers as of yet.

SteemDB won't solve those problems though :D

  ·  작년

Thanks @jesta for bringing back online again...

Great, it would be super cool to have a chart area also!

The only place for steem to go from here is up!!!!!!!!

  ·  작년

Say no more.

  ·  작년

I will check this. Thanks for sharing

I have no idea about the #steem ecosystem. If it's growing up, that's good sign.


@jesta did you do all this? Wow, you must be so smart!..

you guys are doing a great job

@jesta Goodluck hopefully it is going to be fully functional soon!

sounds good, I remain hopeful of the future

  ·  작년

100% UpGoat.

Amazing and very interessing post thank you for sharing
resteemed and shared in the steemit

  ·  작년

I'm glad to hear that you will continue to support SteemDB. Thank you!

Great job man, big BRAVO!

This is great news! I regularly use and steemd, but less familiar with SteemDB. Would love to hear from others what the most useful data on SteemDB is so that I can better take advantage of it!

Que buen recuento, tratare de volverlo a ver, para aprender mas .

This is the best post on Steemit. I gave you a vote now, ya heard?

  ·  작년

I keep seeing this comment copied and pasted all over from different individuals. The exact same words are even on my last reply I recieved on a post. Is this a group ?

happy to join in steemit, successful greetings for steemit lovers,
continue to work
hopefully hope and dream of steemit users in this year can be achieved all..!

I've missed SteemDB, welcome back!

@jesta thank you for the SteemDB!

This are very good informations. thanks

A few days were in great trouble.I'm glad that the problem is partly healed. Thank you for the information.

This website is going to rock just like steemt.Everythinh is clean and awesome th wonderful features.God bless u.God luck to u and everyone.have a blessed day

i am happy to see this post. since i joined i started using and depended on the site. but i had some problems and as a new user thought i did some mistake and it didn't work for me. late i came to know there are some issues and finally they are getting rectified. good to know this. when we are used to one site conginuing on it is very conveninet for me.

finally it is back, everytime I went to visit this site, always got the error|

Cracking work you have done.. witness vote your way!!


Is this what you mentioned?

this is great and useful . thanks!

Glad to know @jesta. Thank you for your contribution! SteemDB is a very helpful service!<3 Resteem

I really have alot to research about this, because i honestly didn't understand more than half of this

wow! so youre the one who is running this thing. Man you rock!! this thing helps, the realtime data and stats. thanks for this.

I just started last week and I only had it for a day or two before it went down and I was wondering what was up with that. Thanks for the hard work.

I'm not familiar with this site but I had a good omen when I checked it out

Hey that was really amazing man .. we need something like that to learn from ❤
Thanks buddy ❤

thanks @jesta, this article is very useful for me, thanks many of my brother

How did I not know about this, the website looks amazing man! Glad someone tipped me off to follow you, please keep improving the site, I think it's looking clean and professional already, and so much info, this is an awesome find for me.

Voted for you as witness, really appreciate the work!

How did I not know about this, the website looks amazing man! Glad someone tipped me off to follow you, please keep improving the site, I think it's looking clean and professional already, and so much info, this is an awesome find for me.

Voted for you as witness, really appreciate the work!

Didn't knew this part of the steem ecosystem. Nicely done, keep on doing the good work!!!

Wish you best of Luck

hi to work well with your willingness to pay for your work

  ·  작년

Thanks for this endeavor, I appreciate it.
The system needs more tools to gain control of our accounts.

Wow the website looks amazing, i will check it out soon!!

All I can say is that the future looks bright and secure. I just hope the programmer breaks the code before they steal it. Hahaha!!!

amazing! now I don't have to click on page by page to check the value of steem vs btc.. thanks for this @jesta. helps alot!!

Really thannk you for this service!

Great feat! You inspire me greatly with this project! Keep up the good work!

This post has single-handedly dealt with issues of immense importance. It was so helpful especially to new people here'. Thanks @jesta

Do you have a discord group??

Thank you, will check it out. I'm already using your steemstats monitor and find it very useful. Just voted you for a witness, thanks for all your work to make stemmians lives easier

Wow, I'm quite excited that I belong to this great family of diverse opportunities

We cannot create an account unless we have steempower already? Thanks :)

great information sir. Hope you could follow me someday

It requires a lot of effort, thanks for the had work :)

all the tools is old add something new in the site.


nice..i am hopefull you will upvote my posts also

So thankful for the awesome information, waoooh this is rich. Thank you.

Great info and I will check it out. Voted you as witness.

  ·  작년

@jesta what is happening with ?
seems it is falling weeks behind

  ·  작년

Probably the same issues that SteemDB has been suffering from over the past couple months.

Over the past few weeks I've made tweaks to golosdb, but the RPC nodes available to retrieve data from are also very slow on the golos end of things. It's still running... just slowly.

Yet another reason why I really want to start working on a new version of the explorer (so it better supports multiple chains).

thanks a lot for such information as I look for some answers which I get from here!

very good

Thank you for your contribution! SteemDB is a very helpful service! ;)

you have to be patient

  ·  작년

follow me and I follow you @sahari

  ·  작년

Excelente iniciativa @jesta
Como verás hace poco me inicié en Steemit y realmente estoy fascinada con todo lo positivo que se maneja en éste mundo de aportes.
Considero que vienes trabajando de una manera genial y te deseo muchos éxitos y más crecimiento...!!!

Thanks for that information sir. Hope you could follow me someday

  ·  작년

I hear that we can earn steempower when comment? really?

  ·  작년

Thanks for the update

Excellent! I was going to test with connecting apps I was developing only recently and appreciate your efforts, and monster server :D Are there any public projects that I may help out with? Cheers!

i ever seen this site...after all reading your blog i saw that and i kindly requesting to improve your site, i'll check out of there

Good post! .. I will follow you follow me too and we help each other ... I would appreciate a vote in my last post thanks

Thank you so much for all the hard work you have put into the site. It clearly shows. Right now I've been trying to tell my friends to migrate over here and leave the exploitive nature of so many other places. I feel really cherished on here.

Hey all, I'm sorry to be commenting on an unrelated article, but I am new to STEEMIT, and I would like to do livestreams a few times a week. How does one start this process ?? Any help is greatly appreciated. Thank you all.

  ·  작년

I'm not sure I have a great answer for ya on how to accomplish that. I've seen people that write posts when they start live streaming, to direct them to other platforms where the live stream is happening, but I'm not sure how that'd work here. Sorry I'm not of much help in this regard!

congrats, good news

It is nicce to have a v2 for this platform! Thanks for your effort!

What sort of tech stack are you working with? Just curious.

  ·  작년

Primarily, all the new stuff I'm doing is a combination of ReactJS standalone apps that then access APIs written in python (flask). I've gotten pretty good at replicating the blockchain into my own indexes via mongodb/redis using python services which then feed into some pretty simple REST APIs.

SteemDB v1 right now is written all in PHP. I've done PHP since the 90's so it was a language I didn't have to think hard about, and while learning how Steem and it's blockchain worked, I didn't want to make things more complex than they had to be. At this point now though, I understand how they work rather well and have been slowly migrating them to better (Non-PHP) solutions and hope to do the same with SteemDB.


Awesome! Thanks for the response :)

  ·  작년

I am proud myself, actually no, lucky person that I saw your post about steemDB. To be quiet honest, I've never heard about steemDB untill now. I just went through that site. I am not aware of it as much, but getting used to it. I wish you can rebuild SteemDB. SteemDB will be the leading one by your efforts. And I myself will have been learning it. Thank you for your enthusiasm which gives me a lot of motivation

Hi sir @jesta your creation is really amazing.we need it and it will big help 😊 not only me but for us 😉😉

Nice Post Dear Steemian. Shared LOVE With My Upvote. Cheers and Have a Peaceful, Profitable Year . Keep Posting

Very good, please help me follow and voute

Good job!!!:this is indeed helpful

  ·  작년

Thanks man for sharing the wonderful details and also a complete source. I will definately check it.

steem being a population on its own i never knew it would have a sample website til my friend @ogochukwu schooled me more on steemit, what ever the problem is, it can be fixed

congrats for server upgrade .

  ·  작년

Thanks, wow .. enter the link, do not know about this page. sure I'll take a lot of work .. I just found out about this.

Fantastic post friend

Interesting and informative, this is my first time hearing about, I will visit there straight away.

thanks for the news

Waoh, i never knew and have not heard about this kind of website but i'm grateful i stumbled on it this morning. Thank you and i will surely love to know more about this


Good job my friend

Why just 12 cores !!! I was expecting it to the the beast - Intel i9 7980XE .. the 18 core one ..

  ·  작년

At this point the RAM is the most critical piece of hardware SteemDB needs. The processors themselves are never really that taxes :D

OMG! This is such and great work thanks for sharing good keep it up

Upvote resteem done

To truly reflect the big data value of the work you do, you'd need to move that decimal point above 6, maybe 7 places to the right!

So... I visited the site and it is very impressive. Don't have a clue what I was reading, but I'm impressed and these are the pieces of my education that I will hopefully one day actually understand. Thank you.

This is quite unclear to me 🤔

Hay jesta, nice to meet you. Iam ubay. Lover of cryptocurrency. I want to know about all cryptocurrency. I am happy to see increase his capacity. I hope your project will be successful project.

Glad to have the platform up and running again. Thanks for your work @jesta!

  ·  작년

posts section is not accurate.

  ·  작년

Yeah, I forgot to mention that in the OP.

One of the things I disabled in a last ditch effort to keep the site running in december was the collection of posts. They make up a huge amount of data within the database.

At this point I'm not going to re-enable it for version 1 of steemdb, but with version 2 I do plan on recording that data once again.

I definitely need to use those tools more often, including SteemDB ><

In any case, do whatever you feel you need to do ^^ I hope you're taking time for yourself, since you're saying you have too many projects.

  ·  작년

one of the things i like about steem, from a software development perspective, is that if you develop the right app, make it free (as you have), if enough people like it you'll make just as much money as if you charged for it elsewhere.

great work. Hopefully i can think of something to provide to the community at some stage in the future.

owo really interesting @jesta keep it up sir

The world of hacking we are the best, we are the best hackers when it comes to hacking.
Contact : for
+University grades hack,
+Bank account hacks,
+Control devices remotely hack,
+Facebook Hacking Tricks,
+Gmail, AOL, Yahoomail, inbox, hack are available,
+Database hacking,
+PC computer tricks
+Bank transfer, Western Union, money gram, Credit Card transfer +Wiping of credit,
+VPN software,
+ATM Hack
we are the real deal when it comes to hacking, carding, WU transfer, Money Gram transfer etc
contact us now on :


Seriously, this as a comment on someone post come oooo.


Spammer are everywhere ... blockchain is a paradise for them as can't be deleted ...
sad ...

Well! I'm totally agree, This thing is risky and need discretionon to invested or trade. I am happy take your appreciation flowers here>

I don't know about this site ..
Whats is this all about?

What is this steemDB about? Is it a part of steemit, like a tool on steemit or its different from the website?

Good writing you post .I like it post .Never know the site .I try to writer if you too.Thank you!

  ·  작년

Finger cross this will remain how it is :)

Nice work

Good job on the site! I gives me very interesting stats that help me undertand how Steemit works since im kinda new. Its also good to see who upvoted me! :)

  ·  작년


I visit for the first time and i'm really impressed. Good work!

Im sorry but im still a little lost on what is best to buy i bought shares but why exactly does anyone need those steem$ and power? Thank you

I love this, I'm moved
Gat new write up please steemians help upvote

I really want to rebuild SteemDB and create a v2 of my block explorer code

That is such a good news. Steemdb is such a important part of Steem.

  ·  작년

evolving and changing world steemit

  ·  작년

waoooo this is interesting

Hello steemians im sorry if i comment this one that is not related to this post.
But please all i need is your vote, PLEASE VOTE FOR ME , I worked so hard in this competition, just comment in the link (@kanekken #4)
Please please please guys



Use steemchat to promote posts ... It's never a good idea to beg in unrelated posts :-) thrust me.


Ohhh thanks actually im a newbie ,and i didnt know that there is a steemchat


you're welcome :-)

Nice post

I really like steem but i kinda think its a bit slow

The new site looks GREAT. It is actually quite difficult to present so much info in a logic, nice-looking and readable way. This one looks spectacular.

Thank you very much for the hard work. Voted you as a witness, thank you!

Can someone please explain this like I'm 5?

amazing bro, ty

  ·  작년

i am trying to understand the features on steemdb , i m not a tech geek so @jesta i try searching every keyword possible :P & understand them

looking forward to all the innovation for the users!! thanks for the info

Thumbs up..

Kudos on that! Very beneficial! Serves as breakthrough and milestone.

good content!

Great Information

Thank you for all the great work you are doing for this blockchain. I use Vessel and SteemDB regularly and appreciate the hard work you put into developing these useful apps.

oh baby god damn when your right your right @jesta you rock straight up

Thank you for sharing. Thank's man,!@jesta

very good post thanks :)

why cannot I create an account ??

Very interesting and good post

Follow me guy's

very very impressive

This needs to go mainstream 🤘🏽

  ·  작년

Great news. More oil on your shoulder.

  ·  작년

Really nice post, keep up improving the site, looks great :)

  ·  작년

thanks for your information

Hi @jesta. Thank you for your work.

Teamwork. It takes a team to get this stuff done and I know that with every task, months of planning were required.

Thank you for contributing so much to my user experience on Steemit.

  ·  작년

follow me and I follow you @sahari

  ·  작년

Thanks for the info

thank you so much :)

Great stuff thanks for the great info . Awesome :D

Thank you for working behind the scene to bring Steemit from glory to glory. I will cast a vote for you to be witness now. Appreciate your contribution and your heart of giving.

Great to see this website is advancing as the blockchain technology continues to develop. I love using this site along side steemit as it helps me to better understand whats what on the site. Im excited to see what new features will be included in the updates. Thanks for all the wonderful efforts you guys have put towards this site.


Nice Post
Please Follow My Blog as Well @asifgoraya123
To Receive Exciting News And Signals About Bitcoin and Altcoins.

NICE I will check it thanks!

that's a great idea. can't wait

I will definitely check it out.

Good project. I will learn it.

thanks...this is very helpful...

Great tool! I love to come across all these applications for @Steemit community. Following!

@jesta just stumbled on this loaded information. Kudos to your team. Although I didn't really comprehend all that was put up. I shall try to ask my geeks around for help. Thanks for sharing this with us.

Nice to know !!!
Which storage box is being used for storing the data ?

What a great contribution so precious to climb a place where we could see our statistics and we can know how our account is going.

Greetings from Venezuela, A big hug for you I hope we can keep reading to you

  ·  작년

Seriously so many things looks really new on steemit to me. But posts like this is getting me more understanding. Thanks

This is very informative, thank you for sharing


This is very important, thanks

good . thanks for sharing nice information.

your info is awesome But how we can do this

I will this new development, Keep it up.

  ·  작년

Our hope is also hopefully together we achieve future steemit gemilang

very nice and very informative post. i followed you because u always share valuable content,keep sharing such posts.very good, I am happy to share kind your important imformation.
By regular read your post i known more about steemit imformatio..
Go ahead
many thanks to you this like shareing,
Cool to see posts like this that support our content creators. Amazing to see how much traction this one gained!
Follow me @mustafarazy

thats a great post.
keep it up
thank you @jesta

Great article you have to know a lot in writing. I am not like you , can't be. But hope of your pity.

Always slowly in my life

  ·  작년

Very very nice post, I like it

Congratulations @jesta!
Your post was mentioned in the hit parade in the following categories:

  • Comments - Ranked 7 with 239 comments
  • Pending payout - Ranked 1 with $ 1144,88

Thanks for all your work @jesta

This SteemBD is such a nice creation, many Steemians will be benefit from this website for sure.

Thanks for cotrebution to the community by telling us about I have got to know abut it from your post

good post.
thanks for sharing.

I give one vote and share your post due to the posing posts.

Just hearing this. I think it is worth checking out. Still new to all these. Thanks.

You are amazing, hopefully I can afford that