Brief History of PostgreSQL database



Brief History of PostgreSQL database

Brief History of PostgreSQL database

This lecture covers brief history of PostgreSQL Database:
****************
It all started in the year 1986 in University of California, Berkeley as a POSTGRES project.
POSTGRESS project was lead by Michael Stonebraker, Turing award winner.
Turing award is considered as the Nobel Prize of Computing.

This POSTGRES project was sponsored by:
Defense advanced Research Projects Agency (DARPA)
the Army Research Office (ARO),
the National Science Foundation (NSF), and ESL

First version was released in 1989.
Second version was released in 1990
Third version was released in 1991

In 1992, Illustra information technologies picked up the POSTGRES code and commercialized it.
In 1993, POSTGRES picked up lots of popularity. Almost, external user community is doubled.
This popularity was actually demanding lots of Support attention from POSTGRES core Team.

To focus more on research, not on support stuff, Berkely POSTGRES project officially ended with Version 4.2

That’s when Postgres95, was released. Some of the highlights of this release are:

1) This is the open source descendant of the Original POSTGRES Berkeley code
2) Andrew and Jolly added SQL Language intereprer to Postgres95.
3) Postgres95 code was completely in ANSI C
4) The Query Language PostQUEL was repleaced with SQL
5) Postgres95 was released as Postgres95 1.0.x

In 1996, Postgres95 is renamed as PostgreSQL and released as v6.0
PostgreSQL = POSTGRES + SQL.
Versioning reflected Berkeley POSTGRES project.

After this PostgreSQL never looked back!

Version 7 is released in 2000
Version 8 is released in 2005
Version 9 is released in 2010
Version 10 in 2017
Version 11 in 2018
Version 12 in 2019
Version 13 in 2020
Version 14, which is currently in Beta2 released this year 2021.

That’s it….so simple, right!!!! 35 years of PostgreSQL Excellence 🙂

That’s all for this lecture. Please do subscribe to my channel if not already done!