PostgreSQL: Difference between revisions
No edit summary |
mNo edit summary |
||
| (4 intermediate revisions by the same user not shown) | |||
| Line 2: | Line 2: | ||
Open source multi-platform [[SQL]] database with fairly strong transaction control that is more scalable than most other open source equivalents. It has support for unlimited database size, although in practice that may require multiple computers to host it, but distributed databases may be held of systems with different operating systems. It has native programming interfaces for [[C]]/[[C++]], [[Java]], [[Perl]], [[Python]], [[Ruby]], [[Tcl]] and [[ODBC]]. | Open source multi-platform [[SQL]] database with fairly strong transaction control that is more scalable than most other open source equivalents. It has support for unlimited database size, although in practice that may require multiple computers to host it, but distributed databases may be held of systems with different operating systems. It has native programming interfaces for [[C]]/[[C++]], [[Java]], [[Perl]], [[Python]], [[Ruby]], [[Tcl]] and [[ODBC]]. | ||
==Features== | |||
*Multi-Version Concurrency Control (MVCC) | *Multi-Version Concurrency Control (MVCC) | ||
*Point in time recovery | *Point in time recovery | ||
*Tablespaces | *Tablespaces | ||
*Asynchronous replication | *Asynchronous replication | ||
* Nested transactions (savepoints) | *Nested transactions (savepoints) | ||
* Online/hot backups | *Online/hot backups | ||
* Sophisticated query planner/optimizer | *Sophisticated query planner/optimizer | ||
* Write ahead logging for fault tolerance. | *Write ahead logging for fault tolerance. | ||
* Support for international character sets including | *Support for international character sets including multibyte character encodings and [[Unicode]]. | ||
* Locale-aware for sorting, case-sensitivity, and formatting. | *Locale-aware for sorting, case-sensitivity, and formatting. | ||
* Stores large binary objects (Audio, executables and video, etc.) | *Stores large binary objects (Audio, executables and video, etc.) | ||
* Almost complete SQL92 and SQL99 implementation. | *Almost complete SQL92 and SQL99 implementation. | ||
* Fully | *Fully ACID compliant | ||
* Maximum Table Size: 32 TB | *Maximum Table Size: 32 TB | ||
* Maximum Row Size: 1.6 TB | *Maximum Row Size: 1.6 TB | ||
* Maximum Field Size: 1 GB | *Maximum Field Size: 1 GB | ||
* Maximum Rows per Table: Unlimited | *Maximum Rows per Table: Unlimited | ||
* Maximum Columns per Table: 250 - 1600 depending on column types | *Maximum Columns per Table: 250 - 1600 depending on column types | ||
* Maximum Indexes per Table: Unlimited. | *Maximum Indexes per Table: Unlimited. | ||
;Libraries with PostgreSQL bindings | |||
* [[LibcURL]] - Internet URL (WWW, FTP, etc) access | * [[LibcURL]] - Internet URL (WWW, FTP, etc) access | ||
==Versions== | ==Versions== | ||
* | * 9.0.6 (2011-12-23) - OS/2 port available | ||
* | * 9.3.24 (2018-08-09) | ||
* | * 9.4.19 (2018-08-09) | ||
* 9.5.14 (2018-08-09) | |||
* 9.6.10 (2018-08-09) | |||
* 10.5 (2018-08-09) | |||
* 11 (2018-10-18) | |||
=== | ===Text editors with PostgreSQL support=== | ||
* [[jEdit]] - Java based editor - PostgreSQL syntax highlighting built in | * [[jEdit]] - Java based editor - PostgreSQL syntax highlighting built-in | ||
==License== | |||
* Open source software released under the [[PostgreSQL License]] | |||
==Links== | ==Links== | ||
* [http://www.postgresql.org/ PostgreSQL homepage] | * [http://www.postgresql.org/ PostgreSQL homepage] | ||
* [http://os2ports.smedley.id.au/index.php?page=postgresql Paul Smedley's PostgreSQL | * [http://os2ports.smedley.id.au/index.php?page=postgresql Paul Smedley's PostgreSQL port] | ||
* [http://www.enterprisedb.com | * [http://www.enterprisedb.com Enterprise dB] - Company that offers commercial PostgreSQL support | ||
[[Category: | [[Category:RDBMS]][[Category:SQL]][[Category:Software written in C]][[Category:Open Source Software]] | ||
Latest revision as of 04:03, 11 February 2023
Open source multi-platform SQL database with fairly strong transaction control that is more scalable than most other open source equivalents. It has support for unlimited database size, although in practice that may require multiple computers to host it, but distributed databases may be held of systems with different operating systems. It has native programming interfaces for C/C++, Java, Perl, Python, Ruby, Tcl and ODBC.
Features
- Multi-Version Concurrency Control (MVCC)
- Point in time recovery
- Tablespaces
- Asynchronous replication
- Nested transactions (savepoints)
- Online/hot backups
- Sophisticated query planner/optimizer
- Write ahead logging for fault tolerance.
- Support for international character sets including multibyte character encodings and Unicode.
- Locale-aware for sorting, case-sensitivity, and formatting.
- Stores large binary objects (Audio, executables and video, etc.)
- Almost complete SQL92 and SQL99 implementation.
- Fully ACID compliant
- Maximum Table Size: 32 TB
- Maximum Row Size: 1.6 TB
- Maximum Field Size: 1 GB
- Maximum Rows per Table: Unlimited
- Maximum Columns per Table: 250 - 1600 depending on column types
- Maximum Indexes per Table: Unlimited.
- Libraries with PostgreSQL bindings
- LibcURL - Internet URL (WWW, FTP, etc) access
Versions
- 9.0.6 (2011-12-23) - OS/2 port available
- 9.3.24 (2018-08-09)
- 9.4.19 (2018-08-09)
- 9.5.14 (2018-08-09)
- 9.6.10 (2018-08-09)
- 10.5 (2018-08-09)
- 11 (2018-10-18)
Text editors with PostgreSQL support
- jEdit - Java based editor - PostgreSQL syntax highlighting built-in
License
- Open source software released under the PostgreSQL License
Links
- PostgreSQL homepage
- Paul Smedley's PostgreSQL port
- Enterprise dB - Company that offers commercial PostgreSQL support