Storing Non-Scalar Data

Derick Rethans (30.Sep.2017 at 10:45, 50 min)
Talk at PHP North West 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!
= eight minus five

Comments

Rating: 3 of 5

30.Sep.2017 at 12:00 by Ben Mallinson (6 comments) via Web2 LIVE

A nice baseline talk on the different technologies you can use to store and manipulate non scalar data. I feel including more advantages and disadvantages of the technologies and scenarios to use them in would add interest personally.

Rating: 3 of 5

30.Sep.2017 at 13:37 by Kat Zien (8 comments) via Web2 LIVE

It was a nice run through all the different technologies to store non-scalar data and a nice refresher about all the different solutions out there. Nothing "revolutionary" for me personally.

Kudos to Derick for staying cool and composed despite the mic problems!

Rating: 4 of 5

30.Sep.2017 at 14:20 by Jeroen v.d. Gulik (85 comments) via Joind.in iPhone app

Good comparison of all the different databases. Would have liked a bit more (opinionated) examples of when to use which database to show some of the strengths

Rating: 3 of 5

30.Sep.2017 at 15:36 by Nathan Dunn (4 comments) via Web2 LIVE

Great look at some ways of storing non-scalar data. I enjoyed the talk and thought there was some great details, including how to query JSON columns in MySQL and Postgres. I would've structured the talk a little bit differently, and would have possibly gone through each database technology separately, rather than looking at all of the technologies for each topic at once.

Rating: 3 of 5

30.Sep.2017 at 18:20 by Jack Wagstaffe (2 comments) via Web2 LIVE

Good overview of different ways of storing non-scalar data. More of a focus on the advantages and disadvantages of the different databases instead of examples of the syntax for doing similar things would have improved the talk.

Rating: 4 of 5

30.Sep.2017 at 18:28 by Antonis Pavlakis (105 comments) via Web2 LIVE

It was great to see a talk looking at how different products implement this type of storage.

Rating: 3 of 5

30.Sep.2017 at 22:58 by Adam Campbell-Smith (7 comments) via Web2 LIVE

I liked the structure of the talk comparing each of ways of interacting with each storage type. I think it could have benefitted from so examples that highlight the strengths and weaknesses of each.

Rating: 4 of 5

01.Oct.2017 at 11:07 by Simon R Jones (46 comments) via Web2 LIVE

Enjoyable overview of different databases and how well they deal with non-scalar data. Feel a lot more informed about the different options out there now, and the movements MySQL is making into this territory.

Rating: 4 of 5

01.Oct.2017 at 13:27 by Katy Ereira (65 comments) via Web2 LIVE

Explored lots of different types of data storage for non-scalar data. Very informative, but as people have said, it would be nice to hear more opinions on which is best when and why.

Rating: 4 of 5

01.Oct.2017 at 21:11 by Ben Plummer (44 comments) via Web2 LIVE

A nice overview of the different databases that can be used to store non-scalar data with useful advantages and disadvantages of each. It would have been good to have heard why one solution would be preferred to another in different scenarios though.

Rating: 5 of 5

01.Oct.2017 at 21:21 by Stefan Kecskes (16 comments)

Informative recapitulation of what are the differences between db engines.

Rating: 4 of 5

01.Oct.2017 at 21:49 by Tom Walder (5 comments) via Web2 LIVE

Good overview of basic CRUD operations in a range of relational and non-relational DBs and Search Engines. I'd like to know more about the underlying storage and index mechanisms in each type.

Rating: 4 of 5

02.Oct.2017 at 09:58 by Stephan Hochdörfer (176 comments) via Web2 LIVE

Good talk, very well structured. To improve the talk I would reduce the number of datastores that were compared, maybe dropping MySQL and CouchDB as they are too similar to the other solutions mentioned and make it clearer when to use which solution.

Rating: 4 of 5

02.Oct.2017 at 20:08 by Dave Liddament (35 comments) via Web2 LIVE

I've not ventured too far into the world of noSQL data stores, so it was interesting to get an overview of them and to get an idea of where they might be useful.

The only thing I would suggest changing is the abstract. I think the amount of material, the pace of the talk and depth was right for the length of talk. I don't see how any more could have successfully been added. However judging by some of the feedback you received, people seem to expect more. Perhaps add something like "high level overview of various noSQL solutions" or words to that effect. Just to make sure attendees' expectations are aligned with what's possible in a 45min talk.

Rating: 4 of 5

02.Oct.2017 at 20:20 by Martin Price (7 comments) via Web2 LIVE

Good as a high level and objective look at the different technologies out there and how they can handle storing/querying complex data. I did find myself wanting to know more of the in depth pros/cons of the technologies' approaches, but I understand that that wasn't the point of the talk, so that's fair enough.

Rating: 3 of 5

03.Oct.2017 at 12:17 by Ronald D. (31 comments) via Web2 LIVE

Decent overview of the different solutions.

Rating: 4 of 5

04.Oct.2017 at 06:45 by Onit Siew (1 comments) via Web2 LIVE

good overview about different common techs for storing non-scalar data.

Rating: 3 of 5

05.Oct.2017 at 13:29 by AlwinD (10 comments) via Web2 LIVE

Great examples, but a little bit to much detail.

Rating: 3 of 5

08.Oct.2017 at 16:51 by Erik Smit (10 comments) via Web2 LIVE

A nice basic talk about non scalar data. Because of all the database comparisons it went from a structured talk to a somewhat spaghetti look and feel. A little bit too much of everything caused this flaw. Otherwise it would have been a good basic talk.

© Joind.in 2017