The new JSON datatype in Postgres 9.2 is interesting enough on its own, however when combined with PLV8 Javascript it becomes very exciting. Never before has there been a datatype and a PL designed to work with together. Combining these two transforms PostgreSQL from a standard relational database into a …
This video walks through the basics of creating your first database using pgAdmin, the comprehensive database design and management console for Postgres databases. Created for first time users of Postgres, you’ll also be introduced to the fundamental features in pgAdmin and be ready to start creating databases, entering data, and …
This video shows a quick example of creating a working CRUD application on top of PostgreSQL using JBoss SEAM (Java Server Faces, EJBs, and Hibernate). In 5 minutes, you use the SEAM framework to build a basic application including reverse engineering the database schema to create boiler plate code for …
Guyren Howe has considerable experience with both MySQL and PostgreSQL. He discusses the myriad technical and other advantages to using PostgreSQL instead of MySQL for, well, pretty much anything. Bonus content: download the slides from this talk. http://sdruby.com/podcast/55
