PostgreSQL is one of the most advanced open-source databases, making it popular DB with Data Analysts and Data Engineers. To get the Postgres, Go to https://www.postgresql.org/download/. Select the suitable installer and download it and follow the installation instructions
DBeaver is a complimentary database tool that supports any database having a JDBC driver. Software developers, SQL writers, database administrators, and data analysts leverage its excellent functionality for interacting with databases. This DBeaver tutorial for PostgreSQL, from connecting and working with data achieve a particular objective
Why DBeaver?
DB is popular with many developers and data gurus because it provides an intuitive user interface to connect to multitude of databases, including MySQL, MariaDB, PostgreSQL, SQLite, and many others and allowing them to perform essential operations on the data.
**DBeaver Installation and Connecting to PostgreSQL
**To install DBeaver, the visit the download page using the following URL:
https://dbeaver.io/download/
Select the version of DBeaver for your OS and download the installer. Then, open the installer and follow the instructions to complete the DBeaver installation.
Once installed, the next phase is connection to SQL. To connect to a database in DBeaver, open the utility and click Database in the top menu. Then, click the New Database Connection option or the Plug icon located within ribbon of icons at the top right portion of the user interface
Then select your DB (which in this case is PostgreSQL) and then hit the next down to go the connection section.
The final stage before we have our DB ready is creating connection, which is very critical. Here is a snippet of how the connection section look like:
The I would explain using example when using localhost as host and the DB name is Jumia.
Once the above details have been keyed in, it is important to test connection first before hitting the “finish” button to ensure that the connection is successful. Here is the output if the connection is successful.
For non-local users, here is snippet of how yours will look (basically the same, just variation in the host used.)
For those using cloud services such as aiven, pretty the same but looks like this:
Upon successful connection, we can perform normal operation on DBeaver just as we would in PostgreSQL. Like shown below:
Fun Fact: The data is also available in PostgreSQL in your computer and you can access it using same DB name/tables like one below:
Top comments (0)