PostgreSQL

I did a presentation and blog on MySQL in the junior phase of a engineering program and came across another database called PostgreSQL. Now that I'm in the senior phase, I've had the opportunity to learn more about PostgreSQL and some the things it can offer. Lets take a look at some of the key points that I have learned from my research.

What is PostgreSQL?
PostgreSQL is an Open-source, relational database management system (RDBMS) that was first released in 1986. It is known for reliability, flexibility, and standards compliance. It was tarted at University of California at Berkeley by Michael Stonebraker. PostgreSQL comes from Post-Ingres was developed after the Ingres project. Ingres project was one of the first relational database management systems developed in the 1970s. PostgreSQL was first called Post-Ingres and was renamed to PostgreSQL(Post-GRE-SQL).It started as a project in 1986 with the goal of creating a database system with the minimal features needed to support multiple data types.

Why the Elephant?
PostgreSQL’s mascot is an elephant named Slonik which means little elephant in Russian. PostgreSQL is very good at keeping data safe and accurate. Like elephants never forget. It ensures your data stays reliable and intact. Elephants are known for being strong and stable, just like Postgres. Elephants are also intelligent and social which mirrors PostgreSQL’s smart design and vibrant open-source community.

Features

• Free & Open-Source: No license fees and community-driven.
• ACID Compliant: Ensures reliable and consistent transactions.
• Extensible: You can add custom types, functions, and operators.
• SQL Standard Support: follows standard SQL rules, making it compatible with other databases.
• Security Features: user access control, encrypted connections (SSL), and fine-grained data access (Row-Level Security)
• Performance Tools: boosts performance with faster searches, quicker queries, and the ability to handle multiple tasks at once.

Installation and Commands
Installing PostgreSQL
on unbuntu:

sudo apt update
sudo apt install postgresql postgresql-contrib

start the PostgreSQL shell with:

psql

Create a database:

CREATE DATABASE letsgeaux;

Create a table:

CREATE TABLE users (
  id SERIAL PRIMARY KEY,
  name TEXT NOT NULL,
  email TEXT UNIQUE NOT NULL
);

Insert data:

Insert data:INSERT INTO users (name, email)
VALUES ('Whitley', '[email protected]');

Query data:

SELECT * FROM users;

Delete data:

DELETE FROM users WHERE id = 1;

Update data:

UPDATE users SET name = 'Whitley' WHERE id = 1;

Conclusion
PostgreSQL is a reliable, powerful, and flexible open-source database used by developers and companies worldwide. PostgreSQL keeps evolving and improving with its extensibility and strong community. Its advanced features, along with its ability to handle complex queries and large datasets, make it suitable for small or large projects.

Sources
https://www.bing.com/images/search?view=detailV2&ccid=ngvrPV8o&id=2393678AB1CECE331807E521A52AE33A9A1F29E7&thid=OIP.ngvrPV8oeZYqtVND9inJjwHaEK&mediaurl=https%3A%2F%2Fwebapp.io%2Fblog%2Fcontent%2Fimages%2F2019%2F11%2Fpostgres.png&cdnurl=https%3A%2F%2Fth.bing.com%2Fth%2Fid%2FR.9e0beb3d5f2879962ab55343f629c98f%3Frik%3D5ykfmjrjKqUh5Q%26pid%3DImgRaw%26r%3D0&exph=1080&expw=1920&q=postgresql+&simid=608021126569221321&FORM=IRPRST&ck=E2FF1DD7456D8F4FCA8BE51A8A3FB944&selectedIndex=2&itb=0&cw=1382&ch=626&ajaxhist=0&ajaxserp=0

https://en.wikipedia.org/wiki/PostgreSQL
https://www.postgresql.org/
https://sl.bing.net/dX9KCCXicBE
https://www.geeksforgeeks.org/difference-between-mysql-and-postgresql/
https://assets-global.website-files.com/6064b31ff49a2d31e0493af1/64550e9b8aa89a0c6cc96bb9_Postgres%20vs%20MySQL%20comparison%20table.jpg
https://www.postgresql.org/about/
https://en.wikipedia.org/wiki/PostgreSQL
https://www.w3schools.com/postgresql/index.php