PostgreSQL is an object-relational database system that is powerful and open source. This software has 15 years of active development and architecture that has been shown to have a good reputation for reliability (reliability), the integrity of the data (data integrity), and also the accuracy (correctness).
PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and do not miss the Windows operating system. PostgreSQL has the ability to fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in more than one language). In addition, PostgreSQL also includes most of the SQL data types: 2008, including INTEGER, NUMERIC, boolean, CHAR, VARCHAR, DATA, INTERVAL, and TIMESTAMP. PostgreSQL supports storage of binary large objects, such as images, audio, or video, and has native programming interfaces for C / C + +, Java,. NET, Perl, Python, Ruby, Tcl, ODBC, and others.
As an enterprise class database, PostgreSQL presents a satisfactory range of features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online / hot backups, query planner / optimizer is good, and write ahead logging for fault tolerance. Object-relational database system also supports international character sets, multibyte character encodings, Unicode, and have good skills in sorting, case-sensitivity, and formatting.
PostgreSQL is highly scalable both in the quantity of data that can be handled and the number of concurrent users that can be accommodated by it. As an example of toughness, there are active PostgreSQL systems are able to handle and manage the use of 4 terabytes of data. Very large, is not it?
PostgreSQL has the ability that can not be underestimated because it has a very comprehensive features and is standard compliant. The database system is also flexible and can be easily customized (highly customizable), where PostgreSQL can be used with various programming languages such as Java, Perl, Python, Ruby, Tcl, C / C + +, and PL / pgSQL (similar to PL / SQL Oracle ).
And the best, PostgreSQL source code available under open source licenses liberal license, PostgreSQL License. This license gives you the freedom to use, modify and distribute PostgreSQL in the form that you like, whether open source or closed source.
PostgreSQL runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and do not miss the Windows operating system. PostgreSQL has the ability to fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in more than one language). In addition, PostgreSQL also includes most of the SQL data types: 2008, including INTEGER, NUMERIC, boolean, CHAR, VARCHAR, DATA, INTERVAL, and TIMESTAMP. PostgreSQL supports storage of binary large objects, such as images, audio, or video, and has native programming interfaces for C / C + +, Java,. NET, Perl, Python, Ruby, Tcl, ODBC, and others.
As an enterprise class database, PostgreSQL presents a satisfactory range of features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online / hot backups, query planner / optimizer is good, and write ahead logging for fault tolerance. Object-relational database system also supports international character sets, multibyte character encodings, Unicode, and have good skills in sorting, case-sensitivity, and formatting.
PostgreSQL is highly scalable both in the quantity of data that can be handled and the number of concurrent users that can be accommodated by it. As an example of toughness, there are active PostgreSQL systems are able to handle and manage the use of 4 terabytes of data. Very large, is not it?
PostgreSQL has the ability that can not be underestimated because it has a very comprehensive features and is standard compliant. The database system is also flexible and can be easily customized (highly customizable), where PostgreSQL can be used with various programming languages such as Java, Perl, Python, Ruby, Tcl, C / C + +, and PL / pgSQL (similar to PL / SQL Oracle ).
And the best, PostgreSQL source code available under open source licenses liberal license, PostgreSQL License. This license gives you the freedom to use, modify and distribute PostgreSQL in the form that you like, whether open source or closed source.
Free Download PostgreSQL 9.1.1
\
{ 0 komentar... Views All / Send Comment! }
Post a Comment