Storing Non-Scalar Data

Derick Rethans (18.Mar.2017 at 13:00, 50 min)
Talk at Midwest PHP 2017 (English - UK)

Rating: 4 of 5

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.

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in site.

Please login to the new site to claim your talk

Want to comment on this talk? Log in or create a new account or comment anonymously

Write a comment

 
Please note: you are not logged in and will be posting anonymously!
= five minus three

Comments

Rating: 4 of 5

18.Mar.2017 at 15:10 by Jeremiah Sandahl (23 comments) via Web2 LIVE

Very information-rich presentation. I think you did as well as possible while trying to cover so many different database options. I think it may have helped to have more examples in one or two of the database types and just cursory coverage of the others. Delivery style was adequate, though a more expressive tone would have helped me stay engaged in the material more.

Rating: 5 of 5

18.Mar.2017 at 17:00 by Korvin Szanto (7 comments) via Web2 LIVE

This was a great talk! I wasn't aware of json format support in the different relational databases and I was glad to learn about the different ways nosql databases handle things.

Rating: 4 of 5

18.Mar.2017 at 19:51 by Noah Bratzel (24 comments) via Web2 LIVE

I was impressed by how thoroughly this topic was covered. A lot of good info.

Rating: 4 of 5

18.Mar.2017 at 22:10 by Aaron Quamme (3 comments) via Web2 LIVE

Great overview! The talk covered a lot of ground quickly and provided great insight into how different databases handle non-scalar data. As someone relatively new to backend development, I came away from the talk feeling that I could make informed decisions about handling non-scalar data.

Rating: 4 of 5

20.Mar.2017 at 09:55 by David Lim (12 comments) via Web2 LIVE

I found the noSQL solutions more interesting than how relational database are implementing non-scalar data storage. You've gotten me interested in researching Elasticsearch more.

© Joind.in 2017