PGCon2012 - Final Release
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 |
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