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.
The NoSQL Store Everyone Ignores - PostgreSQL
Overview
Syllabus
Intro
Who is Stephan
Who are you
No sequel databases
Classification
Why Schemaless
Why you should never use MongoDB
PostgreSQL schemaless data types
Create an array column
Multidimensional arrays
Selecting data
Arrays
Unnecessary rows
Indexing
Updating arrays
Updating a single item
Partial update
Array functions
Hstore
Hstore on Linux
Insert date
Accessing elements
Searching for a key
Akey function
Index function
Update function
minus function
a keys function
why is Hstore interesting
JSON
Metadata
Inserting
Array
Query
Unique indexes
Updating JSON
JSON functions
Row to JSON
Sub queries
Data types
JSONB
Gene Index
JSON Keys
JSON vs JSON
XML over FTP
Wellformed XML
Expert exists
Query to XML
XML functions
Partitioning tables
Child tables
Create a table
Foreign data wrappers
PostgreSQL ecosystem
Try it out
Questions
Taught by
PHP UK Conference
