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 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). 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

Comments

Comments are closed.

Rated 4

Erik Bogaerts at 13:11 on 22 Feb 2019

Great overview on JSONB and similar data types. Well delivered.

Really interesting overview to storing different data types. Immediately started thinking what we could (should) be doing different, so it did its job!

Rated 5

Donald Tyler at 18:46 on 22 Feb 2019

The talk was very interesting. I really liked the comparison of the various storage methods and the discussions of the pros and cons of each. It was way more helpful than the fanatical presentations about one particular product that claims it's a silver bullet.

I learned a broad range about different data types in the different "databases", and how to query them.

Rated 3

William Adjei at 08:39 on 23 Feb 2019

A good presentation although for me specifically I didn't pick up any new learnings

Rated 2

Jason Stanley at 10:46 on 23 Feb 2019

The speaker spoke well. I wasn't a particular fan of the content this time round. I felt the talk spent too much time on how to store data rather than why you would store data with each method. I felt a better talk would have covered one or many use cases, the options available and why you may lean towards one more than another.