PostgreSQL is a database management system for object-relational data (ORDBMS) based on POSTGRES project of the University of Berkeley. The project director is Professor Michael Stonebraker, and was sponsored by Defense Advanced Research Projects Agency (DARPA), the Army Research Office (ARO), the National Science Foundation (NSF), and ESL, Inc.
PostgreSQL is a free referral (OpenSource) project, and uses language SQL92/SQL99 and other features that we will discuss later.
Pioneered many of the concepts existing in the current object-relational system, including, later in other business management systems. PostgreSQL is an object-relational system, that includes features of object orientation, such as inheritance, data types, functions, constraints, triggers, rules and transactional integrity. Despite this, PostGreSQL is not a databases management system purely Object-Oriented.
PostGreSQL (also called Postgres95) Postgres project was derived, as already mentioned. Behind him, the project has more than a decade of development, is today the most advanced free system by far, supporting most of SQL transactions, concurrency control, taking a choice of several “language bindings” as eg C, C++, Java, Python, PHP and many more.
Implementation of Postgresql DBMS began in 1986, and there was a working version until 1987. Version 1.0 was released in June 1989 to a few users, after which version 2.0 was released in June 1990 due to criticism of the system of rules, which forced the reimplementation. Version 3.0 appeared in 1991 and included a number of improvements such as greater efficiency in executing requests. All other versions released since then, focusing on the portability of the system. The project was terminated in the version 4.2, due to the boom that was taking, which caused the failure of maintenance by developers.
In 1994, Andrew Yu and Jolly Chen added a SQL interpreter this handler. Postgres95, as it was called was released online as a free project (OpenSource). It was written entirely in C, and the first version was 25% smaller than Postgres, and between 30 and 50% faster. Besides correcting some bugs, it improved the internal engine, added a new program monitor, and was compiled using the GNU Make utility and the gcc compiler without patch it (as had been required in previous versions).
In 1996, the developers decided to rename DBMS, and called it PostGreSQL (version 6.0) to reflect the relationship between Postgres and recent versions of SQL. Created new improvements and changes, which affected more than 20-40% efficiency, and the incorporation of the SQL92 standard.
To request a quote click here and send us a message asking what you need.