PostgreSQL describes itself as the "world's most advanced open-source database". It provides a comparatively standard and feature-rich SQL implementation based on a very stable backend server. Its open architecture enables the addition of third-party modules and a wide range of procedural languages besides PostgreSQL's native PL/PgSQL.
PostgreSQL is an open-source project and is not backed by any one particular company, although developer funding is provided from a number of firms, including Red Hat. Much code is also contributed by individuals and companies who improve PostgreSQL for their own use.
For a long time PostgreSQL was the "dark horse" of the RDBMS world and although powerful was not necessarily fast nor easy to administer. Recent releases have brought PostgreSQL up to speed and have also streamlined many operations, making life much easier for DBAs. With version 8.0's Windows release PostgreSQL has become available to an even wider user base.
Arcticles and other useful content pages
- 2013-06-11Oleg Bartunov: FTS tips: TEXT @@ TSQUERY confusion2013-06-11Hans-Juergen Schoenig: PostgreSQL block sizes: Getting started …2013-06-11Chris Travers: Design of Efficito's PostgreSQL-centric automation environment2013-06-10Szymon Guz: PostgreSQL Functional Indexes2013-06-10Dan Langille (@dlangille): Using compression with PostgreSQL’s pg_dump2013-06-09Guillaume LELARGE: sqlite foreign data wrapper2013-06-08Francisco Figueiredo Jr: Npgsql Code First Entity Framework 4.3.1 Sample2013-06-08