“Give ear, O my people, to my teaching; incline your ears to the words of my mouth!
I will open my mouth in a parable; I will utter dark sayings from of old, things that we have heard and known, that our fathers have told us.
We will not hide them from their children, but tell to the coming generation the glorious deeds of the LORD, and His might, and the wonders that He has done.”
Main Source: PostgreSQL Documentation.
??? WHAT ???
PostgresSQL is built upon The Berkeley POSTGRES project,
POSTGRES was a package created to act as a storage manager. The project’s purpose was to implement database research.
POSTGRES has implemented many different research & production applications such as a: (1) financial data analysis system, (2) an asteroid tracking database, (3) educational tools at universities, (4) jet engine performance monitoring package, (5) geographic information systems, (6) medical information database, (7) commercialized by Informix / IBM, & (8) the Sequoia 2000 scientific computing project.
??? WHO ???
Professor Michael Stonebraker led the POSTGRES project.
POSTGRES was sponsored by the Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.
In 1994, Andrew Yu & Jolly Chen took POSTGRES & added an SQL interpreter.
??? WHEN ???
POSTGRES started in 1986.
The first “demo” of POSTGRES became operational in 1987 & was shown in 1988 at that year’s ACM-SIGMOD Conference.
Version 1 was released in June of 1989.
Version 2 was released in June of 1990
Version 3 was released in 1991. This version “added support for multiple storage managers, an improved query executor, and a rewritten rule system.”
The POSTGRES project officially ended with Version 4.2.
The decision to close the project was made primarily because the size of the external user community grew large enough to take substantial time away from database research.
Postgres95
As mentioned, Andrew Yu & Jolly Chen added a SQL language interpreter to version 4.2.
Postgres95 was the new name, as this new code was released as an open-source descendant of the shutdown POSTGRES project.
Subsequently, SQL replaced the query language PostQUEL in Postgres95.
While many new features were added in Postgres95, it became clear lasting changes would need to be made to bring Postgres95 into the future.
PostgreSQL was the new name chosen “to reflect the relationship between the original POSTGRES and the more recent versions with SQL capability.”
The versions started at 6.0, which build upon the version numbering system implemented in the original POSTGRE project.
Postgres is the widely utilized nickname for PostgreSQL.
“Give ear, O my people, to my teaching; incline your ears to the words of my mouth!
I will open my mouth in a parable; I will utter dark sayings from of old, things that we have heard and known, that our fathers have told us.
We will not hide them from their children, but tell to the coming generation the glorious deeds of the LORD, and His might, and the wonders that He has done.”
Leave a Reply