PostgreSQL

PostgreSQL Description

PostgreSQL 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.PostgreSQL is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). The software includes most SQL92 and SQL99 data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. PostgreSQL will also support storage of binary large objects, including videos, sounds, or pictures. PostgreSQL has native programming interfaces for C/C++, Java, .NET, Perl, Python, Ruby, Tcl, ODBC, among others, and exceptional documentation.An enterprise class database, PostgreSQL boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot backups, a sophisticated query planner/optimizer, and write ahead logging for fault tolerance.PostgreSQL supports international character sets, multibyte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. PostgreSQL is highly scalable both in the sheer quantity of data it can manage and and in the number of concurrent users it can accommodate. Requirements: · pgAdmin (included in installer) What's New in This Release: [ read full changelog ] Major enhancements in PostgreSQL 9.3 include: · Add materialized views · Make simple views auto-updatable · Add many features for the JSON data type, including operators and functions to extract elements from JSON values · Implement SQL-standard LATERAL option for FROM-clause subqueries and function calls · Allow foreign data wrappers to support writes (inserts/updates/deletes) on foreign tables · Add a Postgres foreign data wrapper to allow access to other Postgres servers · Add support for event triggers · Add optional ability to checksum data pages and report corruption · Prevent non-key-field row updates from blocking foreign key checks · Greatly reduce System V shared memory requirements �.You can free download PostgreSQL from Softpedia now.