| Index: > A B C D E F G H I J K L M N O P Q R S T U V W X Y Z |
|
|||||
| First Prev [ 1 2 3 4 ] Next Last |
It offers an alternative to other open-source database systems (such as MySQL and Firebird), as well as to proprietary systems such as Oracle, Sybase, IBM's DB2 and Microsoft SQL Server.
PostgreSQL's unusual-looking name gives some readers pause in trying to pronounce it, especially those who pronounce "SQL" as "sequel". PostgreSQL's developers pronounce it "post-gress-Q-L". (Audio sample, 5.6k MP3).
PostgreSQL has had a lengthy evolution, starting with the Ingres project at UC Berkeley. The project lead, Michael Stonebraker had left Berkeley to commercialize Ingres in 1982, but eventually returned to academia. After returning to Berkeley in 19851985 is a common year starting on Tuesday. Events January events January 1 Creation of the Internet's Domain Name System. January 17 British Telecom annouces they are going to abolish the famous red telephone boxes. January 23 A debate in the House of Lor, Stonebraker started a post-Ingres project to address the problems with contemporary database systems that had become increasing clear during the early 1980s. The code bases of Postgres and Ingres started (and remain) completely separated.
The resulting project, named Postgres, aimed at introducing the minimum number of features needed to add complete support for types. These features included the ability to define types, but also the ability to fully describe relationships – up until this time widely used but maintained entirely by the user. In Postgres the database "understood" relationships, and could retrieve information in related tables in a natural way using rules.
Starting in 1986 the team released a number of papers describing the basis of the system, and by 1988 the project had a prototype version up and running. The team released version 1 to a small number of users in June 19891989 is a common year starting on Sunday (click on link for calendar). Events January January 7 Akihito becomes Emperor of Japan following the death of Hirohito. The Heisei period begins January 8 the Kegworth Air Disaster A British Midland Boeing 737 cra, followed by Version 2 with a re-written rules system in June 1990. 1991's Version 3 re-wrote the rules system again, but also added support for multiple storage managers and for an improved query engine. By 1993 a huge number of users existed and began to overwhelm the project with requests for support and features. After releasing a Version 4 -- primarily as a cleanup -- the project ended.
Although the Postgres project had officially ended, the BSD license (under which Berkeley had released Postgres) enabled Open Source developers to obtain copies and to develop the system further. In 1994 two UC BerkeleyThe University of California, Berkeley (also known as Cal Berkeley UCB or UC Berkeley is a public, coeducational university situated in the foothills of Berkeley, California to the east of San Francisco Bay, overlooking the Golden Gate and its bridge. graduate students, Andrew Yu and Jolly Chen, added a SQLStructured Query Language SQL is the most popular computer language used to create, modify and query databases. Technically, SQL is a declarative computer language for use with "quasi- relational databases". Theorists note that many of the original SQL fe language interpreter to replace the earlier Ingres-based QUELQUEL is a relational database access language, similar in most ways to SQL, but somewhat better arranged and easier to use. It was created as a part of the groundbreaking Ingres effort at University of California, Berkeley, and was used for a short time i system, creating Postgres95. The code was subsequently released to the web to find its own way in the world. 1996 saw a re-naming of the project: in order to reflect the database's new SQL query language, Postgres95 became PostgreSQL.
The first PostgreSQL release formed version 6.0. Subsequently a group of database developers and volunteers from around the world, coordinated via the InternetThis article is about the Internet the extensive, worldwide computer network available to the public. An internet is a more general term for a set of interconnected computer networks that are connected by internetworking''. WWW information network structu, have maintained the software. Since version 6.0, many subsequent releases have appeared, and many improvements have occurred in the system; in August 2004 version 7.4 became the current release, with version 8.0 in beta testing.
Although the license allowed for the commercialization of Postgres, the Postgres code did not develop commercially with the same rapidity as Ingres -- somewhat surprisingly considering the advantages Postgres offered. The main offshoot originated when Paula Hawthorn (an original Ingres team member who moved from Ingres) and Michael Stonebraker formed Illustra Information Technologies to commercialize Postgres.