Главная
Study mode:
on
1
Introduction
2
Tension between data management and schema design
3
Schema liberation
4
MongoDB documentation
5
Example
6
Which is more friendly
7
Could Postgres be flexible
8
Ingredients
9
What is PLV8
10
Normalized tables
11
Convert to JSON
12
Select star from reports
13
Convert star to JSON
14
Generate table
15
Postgres
16
Database
17
liberation
18
PLV8 liberation
19
boilerplate
20
Postgres terminology
21
boilerplate code
22
Postgres catalog
23
Report query
24
JSON data types
25
JSON table
26
JSON functions
27
PLV8 trusted
28
JSON input
29
Cursors
30
JavaScript injection
31
What about in production
32
Crash
33
Data Warehouse
34
Reports Table
35
Crash UUID
36
Size comparison
37
Processing JSON
38
JSON vs normalized table
39
Bulk Bag Schema Design
40
Postgres features
41
Thank you
Description:
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

Schema Liberation with JSON and PLV8

JSConf
Add to list