Tutorial | DBeaver SQL Client - #1 How to Install and Connect with SteemSQL

DBeaver Universal SQL Client is a multi-platform tool for SQL coders, database admins and analysts. Its a very useful tool to work with SQL Data Base and SQL query.

Since we have the SteemSQL Date Base running a lot of steemians started to do analysis with these data.

My objective with this tutorial is provide information and how to use one free and open-source application that makes this process much easier.

Dbeaver tool can be a powerful ally on this analysis.

In this Tutorial you will learn how to install DBeaver and connect with the SteemSQL data base . Let's begin:

First we need to download it, Go to: https://dbeaver.jkiss.org/download/

Dbeaver is available in two types, 'Community Edition' and 'Enterprise Edition'. The open-source one is the 'Community Edition':

Choose Community Edition 4.3.1 and your version. Here I'm using Windows(64-bit) Installer + JRE

Open the .exe file you downloaded

Click 'Next'. Click 'I agree'

Check the box 'Associate .SQL files'

Click Next. Click Install

Open DBeaver:

Now you have your DBeaver open, he will ask for a connection:
(if he don't ask for a new connection press'CTRL + N')

Select Dbeaver > Data Base Connection > Click 'NEXT'

To connect with SteemSQL : Choose MS SQL Driver > Microsoft Driver. Click 'NEXT'.

SteemSQL Settings:

Host: sql.steemsql.com | User Name: steemit | Password: steemit . Click 'NEXT'

Click 'NEXT'

Click 'FINISH'

Now you have a connection in your 'Data Base Navigator'

Click 'MS SQL Server - sql.steemsql.com'

As this is your first time connecting MS SQL Server with DBeaver he will ask to download drivers:
Click 'Download'

That's it:

You are connected with SteemSQL Data Base

Now you can easy navigate thru the data base, check tables, schema, data types and much more:

The main information of Steem Block Chain is stored at 'dbo' file
To access that, Select DBSteem on your 'Data Base Navigator'

Double Click on 'dbo'

Select views:

Now you can see all tables that stores data of Steem block chain and get info of it. Enjoy!

End of Tutorial

Stay tuned for the next DBeaver Tutorial !
added: Part #2: https://utopian.io/utopian-io/@lpessin/tutorial-or-dbeaver-sql-client-2-how-to-search-filter-and-sql-query

That's all for today. I hope you all enjoyed.

Thank You

---

Posted on Utopian.io - Rewarding Open Source Contributors

---