PostgreSQL stands out as a leading enterprise-grade, open-source relational database system in today’s market. And in this tutorial, you’ll discover how this impressive database came to be, as we trace its evolution over time.
What is PostgreSQL?
Databases are primarily used for large volumes of data storage, retrieval and frequent data update. Among various relational databases available in the market, PostgreSQL is one of the most advanced open-source database servers.
The journey of developing PostgreSQL started way back in 1977-1985 when its ancestor INGRES was developed by the University of California. After that during 1986-1994 a team led by
Michael Stonebraker developed an object-oriented database server called Postgres. Later during 1994-1995 two graduate students of Berkeley, Jolly Chen and Andrew Yu added SQL capabilities to Postgres and named this project Postgres95. Later in 1996, the name of this project was changed from Postgres95 to PostgreSQL. And that’s how PostgreSQL came into existence.
Key Features of PostgreSQL
The key features of PostgreSQL are –
- It is a relational database management system.
- It is a free and open source
- It supports almost all available operating systems.
The Technical Features include-
- PostgreSQL is ACID (Atomicity, Consistency, Isolation, Durability) compliant
- It supports Multi-Version Concurrency Control (MVCC). PostgreSQL is the first database that supports MVCC
- It supports user-defined data types
- It also supports audio, video, images and graphical data storage.
- This relational database is vastly supported by all the programming languages
And Many more
That’s a quick tutorial on what is PostgreSQL. Please subscribe as I am uploading high-quality, information-rich PostgreSQL tutorials on my channel.
Thanks and have a great day!