Fork me on GitHub


While light are still focused on the NoSQL movement, Postgresql evolves and today, it proposes some unique features.

In the first part of this session, We will see why the constraint system is a keystone of your database architecture. We will get trough schemas, types and operators (including key-value stores, xml, geometric types and more). See how Postgres can deal with arrays and objects, how to relate rows to each other in a result set using window functions and Common Table Expressions.

Database abstraction tools do not make developers to easily get advantage of these features. We will see in a second part how Pomm sets the power of the Postgresql database at your fingertips in your PHP, Silex and Symfony2 projects.

A database is not only about storing data but is about giving the developers a way to retrieve them in a intelligent manner to make better applications.