2017 Storing Non-Scalar Data
Channel: Free and Open Source Software Conference (FrOSCon) e.V.
Date: 2017-08-20

https://media.ccc.de/v/froscon2017-1942-storing_non-scalar_data



In this presentation we will look at storing complex data in a single field.
Many noSQL solutions are created around this (such as Redis' lists, sets and
hashes; MongoDB's and CouchDB's records), and many relational database now also
support storing complex data in a single field through specific data types
(such as PostGreSQL's JSONB or hstore, MySQL's JSON).

Each of the different database engines support different things, and handle
these data types in different ways. In this session we compare the different
approaches to storage, indexing and interactions with these data types in
different databases.



Derick Rethans