PostgreSQL is made of an object-relational database management system. PostgreSQL is a free and opensource relational database. PostgreSQL database supports all features of the SQL database with more extended features.
ElephantSQL provides multiple authentications like 'SAML Authentication', 'GitHub' and 'Google'. Use any of the login technique of your desire to create an account.
Now select Data Center at your nearest location.
After creating tables in our PostgreSQL database, 'Table queries' dropdown will get populated with the table upon selecting them editor window will get populated with the table query as shown the picture. Now we are ready to consume our PostgreSQL database.
ElephantSQL is a hosting cloud service for the PostgreSQL database. ElephantSQL will manage administrative tasks of PostgreSQL such as installation, upgrades to the latest stable version, and backup handling. For more information ElephantSQL check docs("https://www.elephantsql.com/docs/index.html").
ElephantSQL Create User Account:
To consume the ElephantSQL cloud service let's create a user account for authentication.
ElephantSQL Authentication Path:
https://customer.elephantsql.com/login
ElephantSQL provides multiple authentications like 'SAML Authentication', 'GitHub' and 'Google'. Use any of the login technique of your desire to create an account.
Accept Agreements:
After successful login, ElephantSQL shows 'Terms of Services', 'Privacy Policy' accept agreement checkboxes.
Create A New Instance:
After accepting 'Terms and conditions', ElephantSQL will allow us to create a new instance.- Provide the 'Name' of the instance
- Select your 'Plan' of the usage of ElephantSQL. Here I'm selecting only the free plan provided to us by ElephantSQL i.e 'Tiny Turtle(free)'. If you are interested you can buy a paid one.
Now select Data Center at your nearest location.
Click the confirmation button to create a new instance that provides PostgreSQL.
Details Of PostgreSQL:
Here from the list of your instance click on the name of the instance to watch the details of your PostgreSQL database and its configurations and additional admin tools(mostly only available for paid plans)
- Server - Name of our PostgreSQL database server name
- Region - Region is the hosted location of our PostgreSQL database server.
- User & Default database - this value will be the name of our database(Paid plans will allow us to create custom database names) and also the name of the user that can access this database.
- Password - To authenticate the user to consume the database.
- URL - Connection string of our database that can be used in our client applications to communicate with the database.
- Current database size - Usage of our database
- Max database size - The size of the total space of the database depends on our paid plan selected(for Tiny Turtle free plan of size 20MB).
Create A Table In PostgreSQL:
ElephantSQL admin tool provides a browser tab where we can execute all our database queries in the editor here.
Let's create a table by running the following PostgreSQL script
CREATE TABLE Employee ( Id serial PRIMARY KEY, Name varchar( 100 ) NOT NULL, Salary numeric(18,2) NOT NULL, Age integer );
After creating tables in our PostgreSQL database, 'Table queries' dropdown will get populated with the table upon selecting them editor window will get populated with the table query as shown the picture. Now we are ready to consume our PostgreSQL database.
ElephantSQL admin toll provides lot options like 'LoG', 'Matrics', 'Integrations', etc for the paid plans.
Support Me!
Buy Me A Coffee
PayPal Me
Wrapping Up:
Hopefully, I think this article delivered some useful information on creating a PostgreSQL database using the ElephantSQL cloud service. I love to have your feedback, suggestions, and better techniques in the comment section below.
Comments
Post a Comment