Posts

Showing posts from May, 2021

What is PostgreSQL?

The purpose of this post is to define exactly what PostgreSQL is and to set up future articles that will go into further detail. Is it PostgreSQL or Postgres? PostgreSQL is officially written as “PostgreSQL”. The standard pronunciation is "post-GRES-cue-ell" . Some choose to pronounce this as “postgres sequel”. Also, sometimes “Postgres” is used interchangeably with “PostgreSQL”. Confused? Let's delve into the history to clarify things. History of PostgreSQL The name “PostgreSQL” is derived from Ingres, a relational database developed by Michael Stonebraker. In 1986, Stonebraker initiated an upgrade to Ingres called POSTGRES (Post + Ingres) that added new features including object programming. In 1994, POSTGRES become an open-source project with an MIT license. In 1995, Andrew Yu and Jolly Chen replaced the POSTGRES internal query language named  QUEL with the nascent SQL language. After a brief name change to Postgre95, the project was rebranded as Postgre