Postgres is the worlds most advanced and mature open source database. It has a very old (20 yrs) history with it’s origins in University of California (Berkeley) and a very strong and dedicated community of global developers all working in a concerted effort towards establishing PostgreSQL as a premier open source database. Postgres has all the key features of a robust commercial grade relational database, is production ready, and brings in the best of Open Source software. It is licensed under the popular and friendly BSD licence which makes it free for all users.
SRA is the leading global provider of end to end PostgreSQL services. It has been a leading contributor to the Postgre SQL development as well as to the community and the co-founder of PostgreSQL is also engaged with SRA.
Key features of Postgre SQL:
ANSI-SQL 99-Standard compliant
Interfaces for TCL, Perl, C, C++, PHP,ODBC, JDBC, Embedded SQL in C, Python, Ruby
Procedural languages PL/pg SQL, PL/Perl, PL/Python, PL/Tcl and others
Fully ACID compliant, serializable transactions
Unicode and locale support
Cross-database compatibility functions
Loadable extensions offering full text search, XML and GIS
SSL support and Kerberos authentication
Hot stand by, replication
Inheritance, sequences outer joins, sub selects, referential integrity, views
Advantages:
Good support: SRA provides comprehensive support and maintenance on PostgreSQL. In addition Postgres has a large and vibrant community of professionals who are available to assist and help. SRA also promotes and works closely with the Postgres community.
Cross Platform: PostgreSQL is available for a broad range of Unix flavors as well as Linux and also runs smoothly on Windows platform
Suitable for high volume environments: Postgres utilizes multiple row data storage strategies called MVCC (multi version concurrency control) which enables it to become very responsive in high volume environments
Stable & Reliable: PostgreSQL is a very reliable and robust database with rare occurrence of crashes
Extensible: Postgres is the leading Open Source database available under the flexible and open BSD license. The software can be freely customized, modified and extended.