Setup SQL Workbench¶
Let us understand how to setup and use SQL Workbench.
Why SQL Workbench
Let us see the details why we might have to use SQL Workbench.
Using Database CLIs such as psql for postgres, mysql etc can be cumbersome for those who are not comfortable with command line interfaces.
Database IDEs such as SQL Workbench will provide required features to run queries against databases with out worrying to much about underlying data dictionaries.
SQL Workbench provide required features to review databases and objects with out writing queries or running database specific commands.
Also Database IDEs provide capabilities to preserve the scripts we develop.
In short Database IDEs such as SQL Workbench improves productivity.
Alternative IDEs
There are several IDEs in the market.
TOAD
SQL Developer for Oracle
MySQL Workbench and many others
Install SQL Workbench
Here are the instructions to setup SQL Workbench.
Download SQL Workbench (typically zip file)
Unzip and launch
Once installed we need to perform below steps which will be covered in detail as part of next topic.
Download JDBC driver for the database we would like to connect.
Get the database connectivity information and connect to the database.