PGCon2012 - Slide release #12

PGCon 2012
The PostgreSQL Conference

Speakers
John Rogelstad
Schedule
Day Talks - 1 - Thursday - 2012-05-17
Room MRT 212
Start time 09:30
Duration 01:00
Info
ID 415
Event type Lecture
Track Applications
Language used for presentation English
Feedback

Using PostgreSQL in modern enterprise web applications

Using HTML5, JavaScript, NodeJS with PostgreSQL

PostgreSQL's object relational heritage makes it an outstanding choice for developing web applications that have a rich object model domain. See how PostgreSQL's object relational features allow for building database models to support a NodeJS data service feeding a 100% JavaScript web client.

PostgreSQL's object relational heritage makes it an outstanding choice for developing web applications that have a rich object model domain. See how PostgreSQL's object relational features allow for building database models to support a NodeJS data service feeding a 100% JavaScript web client.

Topics include:

  • The benefits of a rich domain model in enterprise software
    • Comparing different architecture approaches: scripted model, table model and domain model
  • The dissonance between relational databases and the object model
    • Why NoSQL database's seem attractive
    • Why relational is still the best choice for enterprise applications
    • What is an "object relational" database?
  • Using Postgres' object-relational features to reduce the friction
    • Compound Types
    • Querying an object hierarchy
    • Object relational views
  • Exploring an example
    • Define a rich domain in a JavaScript MVC web client
    • Build a data source using NodeJS using PostgreSQL JavaScript drivers
    • Defining models in Postgres
    • Extending models in Postgres
  • Yes, it's got a Hemi
    • Use Google's plV8js language in PostresSQL to run JavaScript directly in the database
    • Parse and process JSON payloads