Day 1 - Setup PostgreSQL with SQLectron

This is a series of blogs that will help you to get familiar with Postgre SQL Database and manipulate data. Learn how to set up PostgreSQL and SQLectron for CRUD operations. Follow step-by-step installation instructions and database connection details.

Tool Installation

This blog guides you to install Postgre SQL DB and establish a connection with SQLectron to perform CRUD operations.

Download Links

• https://enterprisedb.com/downloads/postgres-postgresql-downloads
• https://github.com/sqlectron/sqlectron-gui/releases/tag/v1.38.0

Installation of PostgreSQL

• After Downloading the setup, let us run it and choose the installation directory.
  
• Then let’s select the components to download like cmd line tool etc.
  
• Then select the data directory for the DB, even post uninstallation we can fetch our data from this folder.
  
• This is where we setup the DB password for incoming connections. Let’s set up a moderately complex password.
  
• We will leave the port at 5432 and locale to use the system default locale.
  
  
• Finally, we will review the installation information and once everything is perfect let’s complete the setup by clicking Next. It might take up to 30 minutes depending on your system.
  
  

Connecting the Database to SQLectron

• Once we install the SQLectron, find and click the Add button.
• Let us add the following details to establish a connection and click on Test:
• • Name: Any name for reference
  • Database Type: PostgreSQL
  • Server Address: localhost
  • Port: 5432
  • User: postgres
  • Password: Setup during installation
  • Initial Database/Keyspace: postgres
    
• Click on Save once the test connection is successful.
• Click Connect once we are back on the home screen.
  
• Once connected, we will be taken to this screen, where we can execute our commands and perform CRUD operations.
  

The next article of the series

• Day 2 - Let’s import and Browse a Sample Database