![]() The World's Most Advanced Open Source Relational Database[1] | |
Developer(s) | PostgreSQL Global Development Group[2] |
---|---|
Initial release | 8 July 1996[3] |
Stable release | 16.4[4] ![]() |
Preview release | 17 beta 3[4] ![]() |
Repository | |
Written in | C |
Type | RDBMS |
License | PostgreSQL License (free and open-source, permissive)[5][6][7] |
Website | www![]() |
Publisher | PostgreSQL Global Development Group Regents of the University of California |
---|---|
Debian FSG compatible | Yes[8][9] |
FSF approved | Yes[10] |
OSI approved | Yes[7] |
GPL compatible | Yes |
Copyleft | No |
Linking from code with a different licence | Yes |
Website | postgresql |
PostgreSQL (/ˈpoʊstɡrɛs ˌkjuː ˈɛl/, POHST-gres kyoo el),[11][12] also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures.[13] It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.
The PostgreSQL Global Development Group focuses only on developing a database engine and closely related components. This core is, technically, what comprises PostgreSQL itself, but there is an extensive developer community and ecosystem that provides other important feature sets that might, traditionally, be provided by a proprietary software vendor. These include special-purpose database engine features, like those needed to support a geospatial[14] or temporal[15] database or features which emulate other database products.[16][17][18][19] Also available from third parties are a wide variety of user and machine interface features, such as graphical user interfaces[20][21][22] or load balancing and high availability toolsets.[23] The large third-party PostgreSQL support network of people, companies, products, and projects, even though not part of The PostgreSQL Development Group, are essential to the PostgreSQL database engine's adoption and use and make up the PostgreSQL ecosystem writ large.[24]
PostgreSQL was originally named POSTGRES, referring to its origins as a successor to the Ingres database developed at the University of California, Berkeley.[25][26] In 1996, the project was renamed PostgreSQL
to reflect its support for SQL. After a review in 2007, the development team decided to keep the name PostgreSQL and the alias Postgres.[27]
PostgreSQL: The World's Most Advanced Open Source Relational Database
contributors
was invoked but never defined (see the help page).birthday
was invoked but never defined (see the help page).about/licence
was invoked but never defined (see the help page).approved by OSI
was invoked but never defined (see the help page).OSI
was invoked but never defined (see the help page).Audio sample
was invoked but never defined (see the help page).intro-whatis
was invoked but never defined (see the help page).PostGIS extends the capabilities of the PostgreSQL relational database by adding support for storing, indexing, and querying geospatial data.
Postgres can be extended to become a Temporal Database. Such databases track the history of database content over time, automatically retaining said history and allowing it to be altered and queried.
Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS.
PostgreSQL extension to schedules and manages jobs in a job queue similar to Oracle DBMS_JOB package.
WiltonDB [is] packaged for Windows. It strives to be usable as a drop-in replacement to Microsoft SQL Server.
Babelfish for PostgreSQL ... provides the capability for PostgreSQL to understand queries from applications written for Microsoft SQL Server.
This page is a partial list of interactive SQL clients (GUI or otherwise) ... that you can type SQL in to and get results from them.
Tools to help with designing a schema, via creating Entity-Relationship diagrams and similar. Most are GUI.
This page is a list of miscellaneous utilities that work with Postgres (ex: data loaders, comparators etc.).
There are many approaches available to scale PostgreSQL beyond running on a single server. ... There is no one-size fits all...
We will try to work with you to permit uses [of the PostgreSQL name] that support the PostgreSQL project and our Community.
design
was invoked but never defined (see the help page).about/history
was invoked but never defined (see the help page).Project name
was invoked but never defined (see the help page).© MMXXIII Rich X Search. We shall prevail. All rights reserved. Rich X Search