SteemData meets sbds - SQL Users Rejoice

in #steemdata7 years ago

What is SteemData?

SteemData offers a database layer for Steem. It allows people to query for large amounts of data very fast, as well as construct complex aggregate queries.

SteemData is using an awesome document based database called MongoDB. MongoDB is the 5th most popular database in the world (source), and is especially favored by younger developers.
Some people have reached out to me on steemit chat, and told me they're learning MongoDB just so they can use SteemData. I think this is pretty cool, and I commend your efforts.

There is however a large group of developers out there whom are more familiar with SQL based databases, such as MySQL. These people were out of luck...until today.

SteemData_Thumb2_small.jpg

What is SBDS?

sbds is the official database layer for the Steem blockchain, developed and maintained by Steemit Inc. It is based on the popular MySQL database.

The credits for the sbds project go to john-g-g and @sneak.

SQL and SteemData

In addition to the open MongoDB database, SteemData now also hosts a publicly accessible MySQL database, populated by sbds.

MySQL Instance

Host: sbds-mysql.steemdata.com
Port: 3306

.
Credentials

Database: sbds
Username: steemit
Password: steemit

.
Example
Screenshot from 2017-05-30 02-16-30.png

Steem Blockchain at your fingertips

Once you connect to the MySQL instance, you can query for any operation that ever happened on Steem.

Screenshot from 2017-05-30 02-19-44.png

Recap

SteemData now offers 3 convenient ways to access Steem blockchain data:
1.) MongoDB
2.) MySQL
3.) API

An API?

SteemData also ships with a powerful HTTP JSON WebAPI.
This option is great for developers whom don't want to use either database solution directly, and just want to quickly integrate SteemData as a data source in their apps.

For more info, please see https://steemdata.com/api

Sort:  

Yay for more public data :)

I also added your #steemdata tag to the Community Projects section on chainBB. Hopefully it's not too polluted with other random posts about data haha.

errrm @jesta, well-done with the chainBB project, have tried to reach you concerning that but my commments doesn't display on your walls....can i have a link to it please?

What's not working? What are you looking for a link to? I'm confused :)

ChainBB!.....anywhere i can read more about it, whitepaper or something. please don't be confused.

I don't have anything elaborate as a white paper yet, still working on the full plan. I just announced the beta for it a couple weeks ago, that might be a good starting place:

https://beta.chainbb.com/chainbb/@jesta/chainbbcom-a-blockchain-forum-platform-for-steem

Okokokok.......Thanks, this should do mate.

ya just go to beta.chainbb.co ! ust tell people to ggo there, sign in with their steemit username and POSTINg key which can be found in that "permissions" tab in ur steemit profile....its just a posting passwordnota transfer password , so ur only giiving tis website ability to post for u....so its not a security issue signing into chainBB

youl make so much more posting to chainBB its not even funny....i hate to say it like that but itstrue! go use chainBB and the whales there will help u out with upvotes

Thanks a million mate....i appreciate

Great work @furion. I am learning MongoDB because of Steemdata but since I am not very good on the backend side I will look into your API's now.

Oh cool! I just finished a course on SQL, time to put it to good use!

Thank you for your explanation.
I am not a computer guy, but your explanation made me understand Steemdata easily.

This is TERRIFIC! Awesome work both on the social aspect of things as well as the technological connection you just exposed the SQL Communities around the world to! ;)

Thanks a bunch, all for one and one for all! Namaste :)

This is awesome! Great work!

Feeling bad i abandoned my coding lessons😢. Few of this terms are very familiar, others are just Wizadry terms to me😣

youre like me, sad u didnt take up prorgamming earlier, we must accept that it would take us way too long to learn and we could do SO much more for steemit by spreading links and being marketeers forsteemit just make youtbe videos about how aamzing steemit is ima make youtbe videos again about how much i make on steemit to eentice teenagers who are all posting to instagram and facebook for free

LOL!.....very well said my friend.....please tell me how to post on chainbb using my phone, i can't a posting page .

Very important article for me. Being well versed in all the 3 technologies i will be checking them out especially the mongoDB. There is a use case for all this and after analysis on the data provided will try to create some relevant apps.

I am really excited about this. I would like to use this for a few things i have thought of lately. Another amazing development out of you @furion . Thank You

MySql injection on steemit?

The database is read only (you can only perform SELECT queries).
The data is also from the public blockchain, so feel free to sql inject whatever you like.

Waw thanks!! It helpful so much