{"guid":"a6656bc8-379c-443d-a27f-c84946d4b7f9","title":"Storing Non-Scalar Data","subtitle":null,"slug":"froscon2017-1942-storing_non-scalar_data","link":"https://c3voc.de","description":"In this presentation we will look at storing complex data in a single field.\nMany noSQL solutions are created around this (such as Redis' lists, sets and\nhashes; MongoDB's and CouchDB's records), and many relational database now also\nsupport storing complex data in a single field through specific data types\n(such as PostGreSQL's JSONB or hstore, MySQL's JSON).\n\nEach of the different database engines support different things, and handle\nthese data types in different ways. In this session we compare the different\napproaches to storage, indexing and interactions with these data types in\ndifferent databases.","original_language":"eng","persons":["Derick Rethans"],"tags":["froscon17","1942"],"view_count":37,"promoted":false,"date":"2017-08-20T00:00:00.000+02:00","release_date":"2017-08-20T02:00:00.000+02:00","updated_at":"2025-05-03T21:00:06.585+02:00","length":3149,"duration":3149,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2017/1942-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2017/1942-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2017/a6656bc8-379c-443d-a27f-c84946d4b7f9-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2017/a6656bc8-379c-443d-a27f-c84946d4b7f9-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2017-1942-storing_non-scalar_data","url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_title":"FrOSCon 2017","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017","related":[{"event_id":4391,"event_guid":"c2d5346f-bd26-43c3-8c19-bbcdf52cd6e3","weight":5},{"event_id":4393,"event_guid":"726f6dc1-ff55-4bd7-bffa-56ae1a4596fc","weight":2},{"event_id":4396,"event_guid":"b5188ef7-b244-48fc-826e-7603cd1d7837","weight":3},{"event_id":4398,"event_guid":"ffcb588b-d30e-467a-9140-39bc79bfc568","weight":2},{"event_id":4404,"event_guid":"0eee3d95-0087-46be-ad92-b2ce90fbcf2a","weight":3},{"event_id":4405,"event_guid":"fab923fb-623d-4803-bfc6-37e9ddc623b1","weight":2},{"event_id":4416,"event_guid":"34018489-1047-46ad-9512-877129118708","weight":3},{"event_id":4422,"event_guid":"6e73c21d-0a11-45e7-bee9-073c0fa02118","weight":3},{"event_id":4423,"event_guid":"0f47094d-5824-48dd-b8b1-90eb4acbc35c","weight":3},{"event_id":4429,"event_guid":"3f680e84-b37d-40d7-8f54-529dfd5df504","weight":3},{"event_id":4439,"event_guid":"d4d91ace-af97-4954-9d9b-7978ee2a2465","weight":2},{"event_id":4440,"event_guid":"2ce31c5d-ecbb-4da6-9c4d-a596d1b93b1c","weight":4},{"event_id":4447,"event_guid":"48c05b36-a467-42db-ae4f-6ba4a86ce6ea","weight":4},{"event_id":4450,"event_guid":"cb892f65-89b4-4c50-8ff6-e38725c67438","weight":3},{"event_id":4451,"event_guid":"3601ef6a-6f6e-4476-8ea4-49506e63096a","weight":2},{"event_id":4455,"event_guid":"fcf36749-0953-4524-825c-e89b52fd756e","weight":3},{"event_id":4459,"event_guid":"723dbee1-a73a-469c-bbb0-6bc90b21ebae","weight":3},{"event_id":4461,"event_guid":"489dc194-4c5d-45ee-a062-dd6098255ae0","weight":3},{"event_id":4464,"event_guid":"574c0eef-838b-4e36-a987-210ccf6c16cd","weight":3},{"event_id":4467,"event_guid":"b73be6a0-292a-4a98-b9bf-f38755279f6e","weight":3},{"event_id":4472,"event_guid":"35abdd14-4469-4295-b3d1-0eba9f4015d2","weight":4},{"event_id":4475,"event_guid":"7fe1d23c-263d-4507-a56b-fa77f7700dda","weight":3}],"recordings":[{"size":109,"length":3149,"mime_type":"video/mp4","language":"eng","filename":"froscon17-1942-eng-Storing_Non-Scalar_Data_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2017-08-20T13:36:22.660+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/h264-hd/froscon17-1942-eng-Storing_Non-Scalar_Data_hd.mp4","url":"https://api.media.ccc.de/public/recordings/18723","event_url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":37,"length":3142,"mime_type":"audio/opus","language":"eng","filename":"froscon17-1942-eng-Storing_Non-Scalar_Data.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2017-08-20T15:15:56.894+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/opus/froscon17-1942-eng-Storing_Non-Scalar_Data.opus","url":"https://api.media.ccc.de/public/recordings/18738","event_url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":47,"length":3142,"mime_type":"audio/mpeg","language":"eng","filename":"froscon17-1942-eng-Storing_Non-Scalar_Data.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2017-08-20T15:16:10.424+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/mp3/froscon17-1942-eng-Storing_Non-Scalar_Data.mp3","url":"https://api.media.ccc.de/public/recordings/18739","event_url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":128,"length":3149,"mime_type":"video/webm","language":"eng","filename":"froscon17-1942-eng-Storing_Non-Scalar_Data_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2017-08-20T15:26:58.360+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/webm-hd/froscon17-1942-eng-Storing_Non-Scalar_Data_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/18767","event_url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":65,"length":3149,"mime_type":"video/mp4","language":"eng","filename":"froscon17-1942-eng-Storing_Non-Scalar_Data_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2017-08-20T15:47:05.022+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/h264-sd/froscon17-1942-eng-Storing_Non-Scalar_Data_sd.mp4","url":"https://api.media.ccc.de/public/recordings/18787","event_url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"},{"size":63,"length":3149,"mime_type":"video/webm","language":"eng","filename":"froscon17-1942-eng-Storing_Non-Scalar_Data_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2017-08-20T15:47:43.009+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2017/webm-sd/froscon17-1942-eng-Storing_Non-Scalar_Data_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/18788","event_url":"https://api.media.ccc.de/public/events/a6656bc8-379c-443d-a27f-c84946d4b7f9","conference_url":"https://api.media.ccc.de/public/conferences/froscon2017"}]}