PostgreSQL, now hailed as the most advanced open-source database available, has an intriguing history that traces back to the late 1980s. Its evolution from the Berkeley POSTGRES Project to the robust PostgreSQL we know today is a testament to the dedication of its creators and the thriving open-source community.
The Berkeley POSTGRES Project, spearheaded by Professor Michael Stonebraker and sponsored by DARPA, ARO, NSF, and ESL, Inc., commenced in 1986. The initial concepts and data model were presented in the late '80s, and by 1987, the first operational "demoware" system wowed audiences at the ACM-SIGMOD Conference. Version 1 was released to external users in June 1989, and subsequent versions addressed issues and added new features.
Postgres95 marked a significant milestone in the project's history. In 1994, Andrew Yu and Jolly Chen introduced an SQL language interpreter to the system, giving birth to Postgres95. This open-source descendant of the original POSTGRES code retained the Berkeley heritage but boasted improved performance and maintainability. The introduction of SQL as the query language replaced PostQUEL, making it more familiar to developers. A new front-end library, libpgtcl, enabled interaction with Tcl-based clients, expanding its usability.
In 1996, recognizing the need for a name that could withstand the test of time, the project adopted a new identity: PostgreSQL. The version numbering was reset to 6.0, aligning with the sequence established by the Berkeley POSTGRES project. This transition marked a turning point, shifting the focus from problem identification and understanding to feature augmentation and expansion. Throughout its history, PostgreSQL has continued to grow and flourish under the collaborative efforts of its dedicated community.
As PostgreSQL continues to evolve, the story of its origin serves as a reminder of the innovative spirit and collaboration that drives the open-source community. With an ever-expanding set of features and capabilities, PostgreSQL remains a formidable force in the world of databases, cementing its place as a testament to the power of open-source development.
Top comments (0)