Difference between revisions of "PostgreSQL"

From Free Software Directory
Jump to: navigation, search
 
(23 intermediate revisions by 5 users not shown)
Line 2: Line 2:
 
|Name=PostgreSQL
 
|Name=PostgreSQL
 
|Short description=A robust SQL Object-Relational Database
 
|Short description=A robust SQL Object-Relational Database
|Full description=PostgreSQL is a powerful database system with a strong reputation for reliability, data integrity, and correctness. It supports the SQL standard and is fully ACID compliant. It offers many advanced features, including complex queries, foreign keys, triggers, views, transactional integrity and multiversion concurrency control. PostgreSQL is free software and runs on all major operating systems. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, and ODBC.
+
|Full description='''PostgreSQL is a powerful database system with a strong reputation for reliability, data integrity, and correctness.'''
 +
 
 +
It supports the SQL standard and is fully ACID compliant. It offers many advanced features, including complex queries, foreign keys, triggers, views, transactional integrity and multiversion concurrency control.
 +
 
 +
It features native programming interfaces for C/C++, Java, .NET, Perl, Python, Ruby, Tcl, and ODBC.
 +
|Homepage URL=https://www.postgresql.org/
 +
|Version download=http://ftp.postgresql.org/pub/source/v9.5.4/
 
|User level=intermediate
 
|User level=intermediate
|Status=Live
+
|Is High Priority Project=No
|Component programs=
+
|VCS checkout command=git clone git://git.postgresql.org/git/postgresql.git
|Homepage URL=http://www.postgresql.org
 
|VCS checkout command=
 
 
|Computer languages=SQL
 
|Computer languages=SQL
|Documentation note=Printed user reference manual available from http://www.network-theory.co.uk/postgresql/
+
|Documentation note=[http://www.postgresql.org/docs/manuals/ Manuals]
|Paid support=
+
|Decommissioned/Obsolete=No
|IRC help=
+
|Accepts cryptocurrency donations=No
|IRC general=
+
|IRC general=irc://chat.freenode.net/postgresql
|IRC development=
+
|Related projects=pgAdmin, MySQL, SQLite, Octave-db
|Related projects=Ah3,GNU_SQL,MySQL,SQLite,Sweater,Octave-db
+
|Keywords=database, sql, rdbms, postgres, db, object-relational database
|Keywords=database,SQL,RDBMS,postgres,db,object-relational database
+
|Version identifier=9.5.4
|Is GNU=n
+
|Version date=2016/08/11
|Last review by=Zak McGregor
+
|Version status=stable
|Last review date=2008-07-09
+
|Test entry=No
|Submitted by=Database conversion
+
|Last review by=Bendikker
 +
|Last review date=2018/04/13
 +
|Submitted by=Bendikker
 
|Submitted date=2011-04-01
 
|Submitted date=2011-04-01
|Version identifier=8.2.5
+
|Is GNU=No
|Version date=2007-09-21
 
|Version status=stable
 
|Version download=http://www.postgresql.org/ftp/source/v8.2.5/
 
 
|License verified date=2007-11-28
 
|License verified date=2007-11-28
|Version comment=
+
}}
 +
{{Project license
 +
|License=Other
 +
|License copyright=Portions Copyright (c) 1996-2014, PostgreSQL Global Development Group
 +
Portions Copyright (c) 1994, The Regents of the University of California
 +
|License verified by=genium
 +
|License verified date=2014-11-22
 +
|License note=PostgreSQL is released under the PostgreSQL License.
 +
https://www.postgresql.org/about/licence/
 +
 
 +
PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.
 +
 
 +
PostgreSQL Database Management System
 +
(formerly known as Postgres, then as Postgres95)
 +
 
 +
Portions Copyright © 1996-2023, The PostgreSQL Global Development Group
 +
 
 +
Portions Copyright © 1994, The Regents of the University of California
 +
 
 +
Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.
 +
 
 +
IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 +
 
 +
THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.
 +
 
 +
Will PostgreSQL ever be released under a different license?
 +
The PostgreSQL Global Development Group remains committed to making PostgreSQL available as free and open source software in perpetuity. There are no plans to change the PostgreSQL License or release PostgreSQL under a different license.
 +
 
 +
If you would like to read more about this topic, then please take a look at the mailing list archives at one of the many discussions on this subject.
 +
}}
 +
{{Software category
 +
|Database=server
 +
|Interface=command-line, console, x-window-system
 +
|Internet-application=server
 +
|Use=internet-application, web-authoring
 +
|Web-authoring=server
 +
|Works-with=database
 +
}}
 +
{{EntryGNU
 +
|Is GNU=No
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Required to build
 +
|Prerequisite description=[[make]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Required to build
 +
|Prerequisite description=[[GCC]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Required to build
 +
|Prerequisite description=[[Readline]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Required to build
 +
|Prerequisite description=[[zlib]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Weak prerequisite
 +
|Prerequisite description=[[Perl]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Weak prerequisite
 +
|Prerequisite description=[[Python]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Weak prerequisite
 +
|Prerequisite description=[[Tcl]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Weak prerequisite
 +
|Prerequisite description=[[Gettext]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Weak prerequisite
 +
|Prerequisite description=[[Flex]]
 +
}}
 +
{{Software prerequisite
 +
|Prerequisite kind=Weak prerequisite
 +
|Prerequisite description=[[Bison]]
 +
}}
 +
{{Resource
 +
|Resource audience=Ruby (Ref) (R)
 +
|Resource URL=https://rubygems.org/gems/postgresql
 +
}}
 +
{{Resource
 +
|Resource audience=Python (Ref) (R)
 +
|Resource URL=https://pypi.org/project/pgsql
 +
}}
 +
{{Resource
 +
|Resource audience=Ruby (Ref) (R)
 +
|Resource URL=https://rubygems.org/gems/pgsql
 
}}
 
}}
 
{{Resource
 
{{Resource
|Resource audience=Developer
+
|Resource audience=Debian (Ref) (R)
|Resource kind=VCS Repository Webview
+
|Resource URL=https://tracker.debian.org/pkg/postgresql
|Resource URL=http://developer.postgresql.org/cvsweb.cgi/pgsql-server/
 
 
}}
 
}}
 
{{Resource
 
{{Resource
Line 58: Line 151:
 
|Resource URL=http://www.postgresql.org/community/lists/#developer
 
|Resource URL=http://www.postgresql.org/community/lists/#developer
 
}}
 
}}
{{Software category
+
{{Resource
|Database=server
+
|Resource audience=Developer
|Interface=command-line,console,x-window-system
+
|Resource kind=VCS Repository Webview
|Internet-application=server
+
|Resource URL=http://git.postgresql.org/gitweb/?p=postgresql.git
|Use=internet-application,web-authoring
+
}}
|Web-authoring=server
+
{{Resource
|Works-with=database
+
|Resource audience=User
 +
|Resource kind=Download
 +
|Resource URL=http://www.postgresql.org/download/
 +
}}
 +
{{Resource
 +
|Resource audience=Wiki
 +
|Resource kind=Homepage
 +
|Resource URL=https://wiki.postgresql.org
 
}}
 
}}
{{Project license
+
{{Resource
|License=X11
+
|Resource audience=IRC channels on irc.freenode.net
|License verified by=Deborah Nicholson
+
|Resource kind=Homepage
|License verified date=2007-11-28
+
|Resource URL=http://www.postgresql.org/community/irc/
 
}}
 
}}
{{Project license
+
{{EntryDetails
|License=BSD
+
|Is High Priority Project=No
|License verified by=Deborah Nicholson
+
|Decommissioned or Obsolete=No
|License verified date=2007-11-28
+
|Accepts cryptocurrency donations=No
 +
|Test entry=No
 
}}
 
}}
 +
{{Featured}}

Latest revision as of 19:06, 14 February 2023


[edit]

PostgreSQL

https://www.postgresql.org/
A robust SQL Object-Relational Database

PostgreSQL is a powerful database system with a strong reputation for reliability, data integrity, and correctness.

It supports the SQL standard and is fully ACID compliant. It offers many advanced features, including complex queries, foreign keys, triggers, views, transactional integrity and multiversion concurrency control.

It features native programming interfaces for C/C++, Java, .NET, Perl, Python, Ruby, Tcl, and ODBC.





Licensing

License

Verified by

Verified on

Notes

License

Other

Verified by

genium

Verified on

22 November 2014

Notes

PostgreSQL is released under the PostgreSQL License.

https://www.postgresql.org/about/licence/

PostgreSQL is released under the PostgreSQL License, a liberal Open Source license, similar to the BSD or MIT licenses.

PostgreSQL Database Management System (formerly known as Postgres, then as Postgres95)

Portions Copyright © 1996-2023, The PostgreSQL Global Development Group

Portions Copyright © 1994, The Regents of the University of California

Permission to use, copy, modify, and distribute this software and its documentation for any purpose, without fee, and without a written agreement is hereby granted, provided that the above copyright notice and this paragraph and the following two paragraphs appear in all copies.

IN NO EVENT SHALL THE UNIVERSITY OF CALIFORNIA BE LIABLE TO ANY PARTY FOR DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES, INCLUDING LOST PROFITS, ARISING OUT OF THE USE OF THIS SOFTWARE AND ITS DOCUMENTATION, EVEN IF THE UNIVERSITY OF CALIFORNIA HAS BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

THE UNIVERSITY OF CALIFORNIA SPECIFICALLY DISCLAIMS ANY WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. THE SOFTWARE PROVIDED HEREUNDER IS ON AN "AS IS" BASIS, AND THE UNIVERSITY OF CALIFORNIA HAS NO OBLIGATIONS TO PROVIDE MAINTENANCE, SUPPORT, UPDATES, ENHANCEMENTS, OR MODIFICATIONS.

Will PostgreSQL ever be released under a different license? The PostgreSQL Global Development Group remains committed to making PostgreSQL available as free and open source software in perpetuity. There are no plans to change the PostgreSQL License or release PostgreSQL under a different license.

If you would like to read more about this topic, then please take a look at the mailing list archives at one of the many discussions on this subject.




Leaders and contributors

Resources and communication

AudienceResource typeURI
Ruby (Ref) (R)https://rubygems.org/gems/pgsql
DeveloperE-mailmailto:pgsql-hackers@postgresql.org
Debian (Ref) (R)https://tracker.debian.org/pkg/postgresql
UserDownloadhttp://www.postgresql.org/download/
HelpE-mailmailto:pgsql-announce@postgresql.org
Python (Ref) (R)https://pypi.org/project/pgsql
Ruby (Ref) (R)https://rubygems.org/gems/postgresql
DeveloperVCS Repository Webviewhttp://git.postgresql.org/gitweb/?p=postgresql.git
SupportE-mailmailto:pgsql-general@postgresql.org
Bug TrackingE-mailmailto:pgsql-bugs@postgresql.org
WikiHomepagehttps://wiki.postgresql.org
IRC channels on irc.freenode.netHomepagehttp://www.postgresql.org/community/irc/
DeveloperMailing List Info/Archivehttp://www.postgresql.org/community/lists/#developer


Software prerequisites

KindDescription
Required to buildmake
Weak prerequisiteTcl
Weak prerequisitePython
Required to buildzlib
Required to buildReadline
Weak prerequisitePerl
Weak prerequisiteBison
Weak prerequisiteFlex
Weak prerequisiteGettext
Required to buildGCC




Entry































"Ruby (Ref) (R)" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.


"Python (Ref) (R)" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.


"Ruby (Ref) (R)" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.


"Debian (Ref) (R)" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.














"User" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.


"Wiki" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.


"IRC channels on irc.freenode.net" is not in the list (General, Help, Bug Tracking, Support, Developer) of allowed values for the "Resource audience" property.



Property "Submitted by" (as page type) with input value "{{{Submitted by}}}" contains invalid characters or is incomplete and therefore can cause unexpected results during a query or annotation process. "{{{Submitted date}}}" contains an extrinsic dash or other characters that are invalid for a date interpretation.








Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License, Version 1.3 or any later version published by the Free Software Foundation; with no Invariant Sections, no Front-Cover Texts, and no Back-Cover Texts. A copy of the license is included in the page “GNU Free Documentation License”.

The copyright and license notices on this page only apply to the text on this page. Any software or copyright-licenses or other similar notices described in this text has its own copyright notice and license, which can usually be found in the distribution or license text itself.