View this post on Ecency: How to save Steem blockchain to MySQL?
How to save Steem blockchain to MySQL?
7 years ago by good-karma (76)
$194.06
- Past Payouts $194.06
- - Author $156.21
- - Curators $37.84
642 votes
- + good-karma: $43.976 (100%)
- + teamsteem: $42.829 (100%)
- + famunger: $10.888 (100%)
- + arama: $10.591 (80%)
- + gtg: $9.210 (100%)
- + sweetsssj: $7.878 (10%)
- + trafalgar: $5.645 (10%)
- + slowwalker: $4.890 (18%)
- + adol: $4.100 (100%)
- + inchonbitcoin: $3.936 (100%)
- + geoffrey: $3.155 (71%)
- + ausbitbank: $2.954 (10%)
- + inertia: $2.435 (100%)
- + furion: $2.254 (99%)
- + chris4210: $2.091 (100%)
- + hipster: $1.875 (100%)
- + mangos: $1.581 (24%)
- + ebejammin: $1.553 (100%)
- + goldmatters: $1.484 (100%)
- + someguy123: $1.391 (100%)
- … and 622 more
Man, you sure deserve the title you are wearing on Steem, "@goodkarma"! thanks for sharing your knowledge and clear easy-to-follow information with us all, namaste :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Agreed! I found this post to he very informative! I always wondered about this steemit development topic
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
very great@eric-boucher
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great! Thanks 🙏. How many records are there already? Would it be better to use MongoDb instead ?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
As I mentioned there are SQL, Mysql and Mongodb options, all possible and depends on developer preference.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Appreciate your services @good-karma, voted you as a witness already, but I guess it's a bit difficult if you are not a developer, wht you say dude?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I have never used docker before. Why do I need it ? Can't I simply use my local mysql ?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Of course you can, above is my setup. You can use sbds and mysql without docker as well. I have one instance without docker, I ended up doing a lot of fiddling and custom changes.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Ok, thank you.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That is awesome, since my day one on steemit I was trying to find a way to put the blockchain on mysql. How big is the mysql database?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I got one server synced up in 8 hours which is taking 134 GB.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good, but do you think the currency is high steem in the future?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Do you know if there is available mysql instances to connect to? I am learning programming might try few things or do some testing... Thanks!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great job, but still for the techy people, since i am just a writer, but still I know the importance of having this set up correctly. Keep up the good work, my friend
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for the lovely post, wishing you all the best.:) information is sure to come in handy, but more than that, it gives me great confidence to know your hard work is being the useful.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello @good-karma 🙂
Give information only
why is the end of this app esteem is often difficult to open? Any open page esteem not showing?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is good and shows the ingenuity of steem blockchain . Thanks for sharing , upped.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Even though the code is all Greek to me, I wish to learn it at some point.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
One word for you..."The Boss". Nice piece
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
this is a great idea sir ,,thanks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks. I generally avoid Docker, is there a walkthrough for a non docker approach for MySql?
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello fraind i follow u and upvote your top 3 post so you also follow back and upvote my top 3 post plez fraind...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @good-karma! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOPDownvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello!, Kindly visit my new created profile and Bless me with your best wishes. @fotographi
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thankyou for sharing.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
seems cool Im not great with computers but learning more everyday thanks for the tips I just installed The Steemit More Info 1.4 - Chrome Extension by @armandocat .
Have you checked it out and if so what are your opinions on it for someone new like me?
Also I am not really great with tech talk but I work for a service industry and we have this simple website https://www.sflodorremoval.com/ what do you think we could do with blockchain all we use the site for is to advertise on google and receive phone calls to get work.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank you for sharing your knowledge and information easily followed by us all, namaste :) @goodkarma
mere nam @Scotting
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
extraordinary applications that you describe, a very wide range ,, thanks @good-karma good luck always with you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great job! Thank you for sharing , my friend @good-karma ! Have a wonderful day!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks. Hope to see python or R Api for steem.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thank info @good-karma
vote and resteem ok
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you so much for this very informative tutorial. I am also a developer but i am just starting to learn on how to program in steem blockchain. This is very helpful for me.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great Post, I always wait ever your posting @good-karma
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very helpful to all users in steemit, keep thinking @ good-karma for the development of all members steemit, hopefully your day is always fun, because your kindness can be felt by others, that good person is useful for others.
Thank you very much.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Amazing information. Thanks for share @good-karma.
I resteem now :
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good post! I'm going to follow you to see more post like this and for support us!
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
awesome post :) i followed you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very good information. Thank you very much
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
Wow..... its amazing post ,,,,,,,,, thanks for sharing this. People like you are the best!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow........amazing post my dear friend ,,,,,,,,,, thanks for sharing this. People like you are the best!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Love your work @good-karma! Resteemed!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is amazing......
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
That's it? Thanks for sharing, I'll try that later when I got to my pc :D
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for sharing ,
Upvoted !
By the way ,I started following you and I would appreciate your follow back too .
please visit my blog and vote me too
Its so exciting to be on the ground floor. I think most people don't realize how lucky we are to be a part of this as a community. Things of this magnitude are usually only available to the elite. If the power of the community could be harnessed the growth could be exponential
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow!
It's good to know that so much more is done to make life easier on steemit
Thanks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
good your post and sharing
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Good information, thanks.....
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice info
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
Okay. You just became amazing.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Always love your updates !! Never disappointed
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @good-karma!
Your post was mentioned in the hit parade in the following category:
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
You are wonderful! Thank you!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hey, I just wanted to mention that I appreciate your work on Steem very much. I notice your votes on my posts. I think you bring great value to the community!
I hope you well, and I will vote you as witness!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Very nice bruv. thanks for this. it will be used. upvoted followed and resteemed!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks @good-karma for this interesting and useful information.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I often learn about sql or mysql .. because I often use it when I create programs and web ,, because SQL is a sub-programming language specifically used to manipulate the database.
SQL is one of the most popular DBMS (Database Management System) for database and embedded operations (embedded) in almost all programming languages that support relational databases.
Great post @good-karma l like this your post..
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @good-karma! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOPDownvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
great post as always, and thank you for all that you do on Steemit to make it a great place.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
articles that are very useful, it can be stored in mysql databases, thanks for sharing knowledge, I will try mysql test and my configuration..
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Awesome buddy.... Good revolution.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great @good-karma...i ama learning...thanks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Congratulations @good-karma! You have completed some achievement on Steemit and have been rewarded with new badge(s) :
Click on any badge to view your own Board of Honor on SteemitBoard.
For more information about SteemitBoard, click here
If you no longer want to receive notifications, reply to this comment with the word
STOPDownvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for the knowledge, very useful @good-karma
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
wow !!! awesome!!!!!!!!!!!!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for this post, @good-karma. I tried out building and running
sbdsin a container as you did here (but with the built-in sqlite), but hit an issue I reported in https://github.com/steemit/sbds/issues/76. I'm commenting here in case you or others reading this noticed the same problem, so we can figure out how to fix it more easily.Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
nice post
i like it
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
I LIKE APLICASI ESTEEM U..... THANKS YA...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Vielen Dank für Steemit 🙏🇹🇭
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for sharing the nice info
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is nice
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This is a good information to developers. There are so many things to learn on steemit and about steem. This is awesome. Thanks for sharing 👍
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great post! I gave you a follow and upvote
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for sharing this :) Followed for more news
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice integration. Resteemed.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Nice post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
very nice sharing, thanks for sharing with us i am following with pleasure ...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great!
Voted you as witness :-)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
smart posting. thank you
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
It looks complicated in my eyes... Lol, i need to start learning more about computers, website developers and all...
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
With the recent changes in Steemit's framework, the following line should be changed in the Dockerfile from:
ENV STEEMD_HTTP_URL https://steemd.steemitdev.comto
ENV STEEMD_HTTP_URL https://api.steemit.comOtherwise it will spit a load of RPCError and not synchronize.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Arrrrggghhh!
I am replying to this @drakos comment as a marker as I will be setting this up this weekend.
Glad you posted this Matey!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
you just saved me hours of confusion. Thanks !
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Great. Have fun with SBDS :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thank you for sharing @good-karma science. this is very useful for us
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
This new feature really helps my ms @good-karma in monitoring my steemit account, this will increase my spirits in managing steemit accounts
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thanks for sharing this useful article @good-karma
You are my inspirator
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Thankyou for information
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@good-karma,
Very useful article! I was trying to find out how to get data from STEEM Block Chain and you solved it just now! Great work and thank you very much for sharing such useful guideline with us!
Cheers~
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Wow thanks for sharing this. People like you are the best!
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks my best friend @good-karma.
has been sharing information that is very useful for us eSteem user.
hopefully just eSteem growing all over the world.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Hello good post my name is Yudexis Jaume and I am from venezuela can you give a vote to my last post? @good-karma
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks for sharing your knowledge and clear easy-to-follow information with us all.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
@good-karma
thanks for all...i mentioned you on my post
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Pretty awesome update explained very nicely and easily thanks for that :)
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Test post, please ignore *:)
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
What does this have to do with the post you are replying too? I don't know much about mysql and how it relates to the blockchain, but I'm pretty sure it is not about shopping for groceries.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
Keren bg @clen.civil kita ubah transaksi dunia sekarang.
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit
thanks
Downvoting a post can decrease pending rewards and make it less visible. Common reasons:
Submit