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.
Read more