Explore the intricacies of storing complex data in a single field during this PHP UK Conference talk. Delve into various noSQL solutions like Redis' lists, sets, and hashes, as well as MongoDB's records. Examine how relational databases support complex data storage through specific data types such as PostGreSQL's JSONB or hstore. Compare different approaches to storage, indexing, and interactions with these data types across various database engines. Learn about document stores, complex documents in relational databases, and specific implementations in PostgreSQL, Redis, and MongoDB. Discover querying techniques, indexing strategies, atomic operations, and update operators. Gain insights into schema validation and draw valuable conclusions about non-scalar data storage in modern database systems.
Overview
Syllabus
Intro
Non-Scalar Data
What Is This Presentation Not About
Document Stores
Documents: Complex
Relational Databases
PostgreSQL: HSTORE
Redis: Query
MongoDB: Aggregation
PostgreSQL Query HSTORE
PostgreSQL Query JSONB
Redis: Indexes
PostgreSQL: GIN Index
Redis: Atomic Operations
MongoDB: Update Operators
Schema Validation
Conclusions
Taught by
PHP UK Conference
