 |
| ||||
It has more than 15 years of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness.
It runs on all major operating systems, including Windows, Linux and other UNIX systmes like AIX, HP-UX, BSD, SGI IRIX, Mac OS X, Solaris and Tru64.
It is fully ACID compliant, has full support for foreign keys, views, triggers, joins and stored procedures (in multiple languages).
It includes most SQL:2008 data types, including INTEGER, NUMERIC, CHAR, VARCHAR, DATE, INTERVAL, BOOLEAN and TIMESTAMP.
PostgreSQL also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Ruby, Java, .Net, Perl, Python, Tcl, ODBC, among others, and exceptional documentation.
PostgreSQL runs stored procedures in more than a dozen programming languages, including Java, Ruby, Perl, Python, C/C++, Tcl, and its own PL/pgSQL, which is similar to Oracle's PL/SQL.
The SQL implementation in PostgreSQL strongly conforms to the ANSI-SQL:2008 standard.
And while PostgreSQL has a fully relational system catalog which itself supports multiple schemas per database, its catalog is also accessible through the Information Schema as defined in the SQL standard.
It has full support for subqueries (including subselects in the FROM clause), read-committed and serializable transaction isolation levels.
Being an enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), tablespaces, point in time recovery, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.
It natively supports international character sets, Unicode, multibyte character encodings, and it is locale-aware for sorting, case-sensitivity, and formatting.
PostgreSQL is very scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.
There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.
Included in the standard function library are built-in functions that range from basic math and string operations to cryptography and Oracle compatibility.
Triggers and stored procedures can be written in C and loaded into the database as a library, allowing great flexibility in extending its capabilities. Similarly, PostgreSQL includes a framework that allows developers to define and create their own custom data types along with supporting functions and operators that define their behavior.
As a result, a host of advanced data types have been created that range from geometric and spatial primitives to network addresses to even ISBN/ISSN (International Standard Book Number/International Standard Serial Number) data types, all of which can be optionally added to the system.
As there are many procedure languages supported by PostgreSQL, there are also many library interfaces as well, allowing various languages both compiled and interpreted to interface with PostgreSQL: Java (JDBC), ODBC, Perl, Python, Ruby, C, C++, Lisp, Scheme, Qt, PHP, etc.
The PostgreSQL License is very similar to BSD or MIT's free licenses.
This page contains links only to the source code of PostgreSQL. For binary relases go here for the Windows version, here for the Linux version and here for the Mac version.
Here are some key features of "PostgreSQL":
Technical Features:
· Maximum Database Size - Unlimited
· 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 to 1600 depending on column types
· Maximum Indexes per Table - Unlimited
What's New in This Release: [ read full changelog ]
· PostgreSQL minor versions with security fixes.
Via: PostgreSQL 9.1.5 / 9.0.9 / 8.4.13 / 9.2 Beta 1
0 Comment:
Post a Comment