Skip to content

Instantly share code, notes, and snippets.

@chanmix51
Created September 7, 2012 14:42
Show Gist options
  • Save chanmix51/3666762 to your computer and use it in GitHub Desktop.
Save chanmix51/3666762 to your computer and use it in GitHub Desktop.
During this session we will explore Postgresql's unique features like writeable CTEs, window functions, Json, XML and key-value support and much more. We will see how with Pomm's elastic objects it makes web developers able to have a model layer decoupled from the underlying data structure with a minimal complexity data preparation code.
Postgresql 9.2 is probably the most known version of Postgres since it exists. This can be partly explained by the fuss about web oriented features like Json and HStore data types and javascript v8 support for stored functions. But it is not the only reason. Its rich types sets allow programers to think data as objects in their SQL queries.
Today's ORMs link static classes to tables, preventing the developers from creating their own business oriented data sets. They must then prepare the data to format them the right way in the model layer before applying business rules.
Pomm is a model manager. It maps PHP elastic classes to data sets provided either by tables, views or… SQL queries.
This way, web developers can benefit from Postgres's unique features like writeable and recursive CTEs, window functions, namespaces and so many more.
Postgresql 9.2 is available and JSon type with the HStore key-value store added to the features described above make it the perfect hit with PHP to create rich and fast as light web applications.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment