Advanced
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.
Course info
Rating
Level
Advanced

Updated
Sep 18, 2015

Duration
3h 53m

Table of contents
Introduction
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
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
Description
Course info
Rating
Level
Advanced

Updated
Sep 18, 2015

Duration
3h 53m

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