The NoSQL Store Everyone Ignores - PostgreSQL
Explore the powerful NoSQL capabilities of PostgreSQL in this 53-minute conference talk from PHP UK Conference. Discover how recent versions of PostgreSQL support schema-free data, enabling flexible data storage and retrieval. Learn about new features such as array columns, hstore, JSON, and XML support, and how to leverage them in PHP applications. Dive into practical examples of creating, querying, and updating schemaless data structures. Understand the advantages of PostgreSQL's approach compared to other NoSQL databases. Gain insights into advanced topics like indexing, partitioning tables, and foreign data wrappers. By the end of this talk, acquire the knowledge to effectively utilize PostgreSQL's NoSQL features in your projects, potentially eliminating the need for separate NoSQL databases in your technology stack.