PostgreSQL is a powerful, open source object-relational database system. It 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.
We like PostgreSQL for its standard compliance. Its SQL implementation strongly conforms to the ANSI-SQL:2008 standard. It also offers advanced searching capabilities, so it is a perfect choice if one does not want to use a full-blown search engine.
When it comes to the decision of which relational database system to use in a product, its licensing structure is often an important factor. Unlike other RDBMS solutions, PostgreSQL is available under a liberal open source license. This license gives you the freedom to use, modify and distribute PostgreSQL in any form you like, open or closed source, thus can reduce your development costs.
Check out the following projects where we used PostgreSQL as the storage backend.