Picture of Andrew McMillan

PostgreSQL

by Andrew McMillan - Wednesday, 24 November 2004, 4:56 PM
 
PostgreSQL is a full-featured open-source database with many enterprise features, including:
  • Support for database transactions
  • Strong support for SQL-92 standard
  • Native external interfaces for ODBC, JDBC, C, C++, PHP, Perl, TCL, Python and Ruby
  • Referential integrity
  • Internal functions can be written in C, C++, Java, Perl, TCL, Python, Ruby, PHP and PL/PgSQL
  • Insert/Update/Delete Triggers
  • Inheritance
  • Unicode
  • Extensible data types
  • Indexes on functions
PostgreSQL scales well into large multi-user environments, where the application has significantly intermixed reading and writing activity.

See http://www.postgresql.org/ for more information.

» Glossary of common terms