In this article, we will discuss the overview of PopSQL editor and will discuss how to use PopSQL editor and how we can connect with a database. Let’s discuss it one by one.
Pre-requisite – Installing MySQL
PopSQL is a versatile SQL management tool that lets you work and collaborate on multiple database management tasks simultaneously. Visualization of data is very important as it gives a clear picture of your client’s/customers’ data. Here comes PopSQL which is a very fun tool to write SQL, visualize data, and share results. In this tutorial, we will see how we connect a MySQL server with PopSQL. This can be also used as an alternative to MySQL workbench. Let’s begin.
Steps to create and connect your MySQL database instance with PopSQL :
Open MySQL 8.0 Command Line Client. Your version may be different but no issues.
Now, enter the root password that u had set during the MySQL installation.
Now, create a database for example ‘geeksforgeeks’. This database will be created under your localhost instance:
After creating the database, open PopSQL, create an account, and then follow the diagram:
Click on the ‘New Connection’ and set up your database accordingly. The great thing about it is that it will work with most types of databases, including Microsoft SQL, MySQL, Redshift, Cassandra, MemSQL, BigQuery, etc. For this tutorial, I will be setting up MySQL. So carefully fill all the following required fields i.e hostname, port, database, username, and password.
After connecting, now you can start typing your queries. Click on the Run button to run your queries.
This application makes it simple for clients and developers to team up and work on different SQL activities simultaneously. You’ll have the option to deal with different types of databases at the same time, which probably won’t be accessible in other SQL management tools.
There are lots of features in PopSQL and you can explore them on their official documentation.