Created
September 7, 2012 14:42
-
-
Save chanmix51/3666762 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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