Expanded

The PostgreSQL Document Database

By Rob Conery
PostgreSQL is a powerful relational engine - but did you know you can make it just as flexible and exciting as MongoDB, CouchDB, or RethinkDB? With the new jsonb data type, PostgreSQL has the ability to be a full-fledged document data store.
Get started
Course info
Rating
(67)
Level
Advanced
Updated
Sep 18, 2015
Duration
3h 53m
Table of contents
Introduction
Introduction 6m PostgreSQL vs Others 9m Thinking in Documents 5m
JSON and JSONB Basics
JSON and JSONB 9m Selectors 3m The Sample Database 3m JSON Creation Functions 9m Building Documents from Data 3m Data Validation 7m JSON Processing Functions 6m The Existence Operator 3m The Containment Operator 2m Fuzzy Matches 3m Indexing 9m JSONB and PLV8 8m
A Document API
The Document Table 5m Create Document Table Function 3m Save Document Function 12m Update Search Function 10m Bulk Save 8m Find by ID Function 3m Find by Criteria Function 2m Filter Function 3m Search Function 5m
A Node Client
Querying Postgres 5m Save Document 4m Bulk Save 4m Find by ID 4m Find by Criteria 3m Filter 4m
A .NET Client
Getting Set up with Xamarin 3m Querying Postgres with Npgsql 7m Save Document 4m Find by Id 3m Bulk Save 3m Find 4m Filter and Search 5m
Querying
Review of the Sample Data 5m Sample Data Import 1m Average Album Price 10m Sales Facts 8m Album Sales 3m Co-occurrence 9m Co-occurrence Function 3m Co-occurrence Rollup 5m
Description
Course info
Rating
(67)
Level
Advanced
Updated
Sep 18, 2015
Duration
3h 53m
Your 10-day individual free trial includes:

Expanded library

This course and over 7,000+ additional courses from our full course library.

Hands-on library

Practice and apply knowledge faster in real-world scenarios with projects and interactive courses.
*Available on Premium only
Start a Premium 10-day free trial
Description

PostgreSQL is a powerful relational engine - but did you know you can make it just as flexible and exciting as MongoDB, CouchDB, or RethinkDB? With the new jsonb data type, PostgreSQL has the ability to be a full-fledged document data store.

About the author
Rob Conery
About the author

Rob Conery co-founded Tekpub and created This Developer's Life. He is an author, speaker, and sometimes a little bit opinionated.

More from the author
Play by Play: C# Q&A with Scott Allen and Jon Skeet
Intermediate
1h 15m
Mar 16, 2016
Electron Playbook
Intermediate
1h 38m
Mar 2, 2016
On Polyglot Programming
Intermediate
1h 7m
Jan 22, 2016
More courses by Rob Conery

You're the smartest person in the room

PROVE IT

Your team won't just close the skills gap

THEY'LL HURDLE IT

Course info
Rating
(67)
Level
Advanced
Updated
Sep 18, 2015
Duration
3h 53m
Pluralsight IQ
Know exactly where everyone on your team stands with assessments and analytics.
Try our full library including this course free for your whole team for 14-days.