How to Install SQL Workbench for PostgreSQL


Save time and effort by managing different database systems with a single tool. Find out how to set up SQL Workbench to connect to a PostgreSQL database with four (4) easy steps. Use SQL Workbench to migrate data between your databases without the…

Read More

How to Create MySQL Database in Workbench


Workbench is a cross-platform, open-source, visual tool for database management. It provides a user-friendly GUI in which you can create and maintain databases. Learn how to create a MySQL database and table in Workbench, as well as how to add data…

Read More

Install and Get Started with MySQL Workbench on Ubuntu 18.04


Workbench is a visual tool for managing MySQL databases . Its graphical interface allows administrators and database architects to model data, build and run SQL queries, and maintain a database. Get a better understanding on how Workbench works, how…

Read More

How to Create a Table in MySQL


MySQL is a well-known, free and open-source database application. One of the most crucial processes in MySQL is creating tables and databases. Follow this tutorial to learn how to create a table in MySQL and insert data.

Read More

How to Check Your PostgreSQL Version


Use this guide to check your PostgreSQL version with a few straightforward commands. You can retrieve the PostgresSQL version directly from your command line or use an effective SQL statement within the PostgreSQL shell.

Read More

How to Allow Remote Connections to MySQL


Keep your database servers separate from your public-facing web servers to improve security, performance, and flexibility. MySQL servers are initially set up to accept local connections. Use this tutorial to change these settings in the MySQL…

Read More

How to Install PostgreSQL on Ubuntu 18.04


PostgreSQL is an open-source, relational database management system. There are two simple ways of installing PostgreSQL on Ubuntu 18.04. You can set up the database system from the local repository. However, it doesn't guarantee to provide the…

Read More

PostgreSQL Vs MySQL: A Detailed Comparison


Explore the differences between the two most widely used database management systems. PostgreSQL and MySQL are both excellent database solutions, and well suited for most workloads. However, small differences can result in less than optimal…

Read More

How to Connect to a PostgreSQL Database From Command Line in Linux


PostgreSQL is an open source relational database management system.In this tutorial learn how to connect to PostgreSQL from the command line using psql or pgAdmin. The GUI based pgAdmin provides a secure, user-friendly way to log in, administer, and…

Read More

How to Install MySQL 8.0 in Ubuntu 18.04


MySQL is an open-source relational database server tool for Linux operating systems. It is widely used in modern web-based technology, and it forms part of the popular “LAMP” stack of software.  The LAMP stack includes the Linux operating system,…

Read More