Schema Liberation with JSON and PLV8

Explore schema liberation using JSON and PLV8 in this JSConfUS 2013 talk by Selena Deckelmann. Learn how to transform normalized schemas into flexible JSON structures within PostgreSQL. Discover the power of native JSON support and the PLV8 JavaScript engine as a database extension. Gain insights into implementing a document store inside Postgres, including a real-world example from Mozilla's crash-stats.mozilla.com. Understand the tension between data management and schema design, and see how Postgres can offer flexibility similar to MongoDB. Dive into practical examples of converting normalized tables to JSON, using PLV8 liberation techniques, and leveraging Postgres catalog information. Examine JSON data types, functions, and security considerations like JavaScript injection prevention. Compare JSON and normalized table approaches in production environments, exploring the CrashData Warehouse use case. Uncover the benefits of a Bulk Bag Schema Design and essential Postgres features for working with JSON data.

Syllabus

Introduction
Tension between data management and schema design
Schema liberation
MongoDB documentation
Example
Which is more friendly
Could Postgres be flexible
Ingredients
What is PLV8
Normalized tables
Convert to JSON
Select star from reports
Convert star to JSON
Generate table
Postgres
Database
liberation
PLV8 liberation
boilerplate
Postgres terminology
boilerplate code
Postgres catalog
Report query
JSON data types
JSON table
JSON functions
PLV8 trusted
JSON input
Cursors
JavaScript injection
What about in production
Crash
Data Warehouse
Reports Table
Crash UUID
Size comparison
Processing JSON
JSON vs normalized table
Bulk Bag Schema Design
Postgres features
Thank you