{"guid":"a2f61e35-bf54-4cf9-9362-e4d04fa94915","title":"Neues in Open-Source-SQL-Datenbanken","subtitle":null,"slug":"froscon2019-2433-neues_in_open-source-sql-datenbanken","link":"https://programm.froscon.de/2019/events/2433.html","description":"Der SQL-Dialekt der gängigen open source Datenbanken entwickelt sich aktuell schneller denn je. Ein Überblick über die neusten Features.\n\nSQL ist ein lebender Standard mit Hunderten optionalen Funktionen. Traditionell wurden diese optionalen Funktionen von Open-Source-SQL-Datenbanken nur sehr lückenhaft unterstützt. In den letzten Jahren ist jedoch Schwung in die Sache gekommen.\n\nDieser Vortrag stellt die SQL-Funktionen vor, die in den letzten Versionen von MariaDB, MySQL, PostgreSQL und SQLite eingeführt wurden und damit einer breiten Anwenderbasis zur Verfügung stehen.","original_language":"deu","persons":["Markus Winand"],"view_count":624,"promoted":false,"date":"2019-08-10T00:00:00.000+02:00","release_date":"2019-08-10T02:00:00.000+02:00","updated_at":"2026-04-10T16:00:09.762+02:00","tags":["froscon2019","2433","Databases"],"length":3725,"duration":3725,"thumb_url":"https://static.media.ccc.de/media/events/froscon/2019/2433-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/froscon/2019/2433-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/froscon/2019/2433-hd.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/froscon/2019/2433-hd.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/froscon2019-2433-neues_in_open-source-sql-datenbanken","url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_title":"FrOSCon 2019","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019","related":[{"event_id":7265,"event_guid":"480a501f-cb98-4af1-bbab-273c383e2080","weight":2},{"event_id":7273,"event_guid":"e26eade4-6c94-4ec4-8aab-cc265a4680cc","weight":2},{"event_id":7279,"event_guid":"967fa2a1-265f-47c1-90b2-ec8dba08b328","weight":17},{"event_id":7281,"event_guid":"bb5b04bd-9599-4d93-bd12-c779f381cf5e","weight":33},{"event_id":7287,"event_guid":"0ff8cbfa-b751-4107-beec-33a2678939d8","weight":19},{"event_id":7295,"event_guid":"1804f134-5ee8-46ff-8ea0-279350304c2a","weight":28},{"event_id":7296,"event_guid":"b8424140-1639-44f7-a19a-67af58ad61e9","weight":24},{"event_id":7308,"event_guid":"725bf5fc-26a0-468b-a1ee-c5e5e8154fd2","weight":19},{"event_id":7329,"event_guid":"9186fc88-b1f8-45fc-8dcb-a375e029680d","weight":17},{"event_id":7332,"event_guid":"50ad5991-1b2f-4a92-ba87-dec6456f085a","weight":37},{"event_id":7341,"event_guid":"7100ad0c-e4f3-4784-b707-46759cd3cb6a","weight":34},{"event_id":7348,"event_guid":"d826f086-8ce2-4925-9dfa-b02db91c73ca","weight":19}],"recordings":[{"size":227,"length":3725,"mime_type":"video/mp4","language":"deu","filename":"froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-10T19:34:36.768+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/h264-hd/froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_hd.mp4","url":"https://api.media.ccc.de/public/recordings/36705","event_url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":56,"length":3725,"mime_type":"audio/mpeg","language":"deu","filename":"froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-10T19:38:35.830+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/mp3/froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/36714","event_url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":37,"length":3725,"mime_type":"audio/opus","language":"deu","filename":"froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2019-08-10T19:39:34.195+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/opus/froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_opus.opus","url":"https://api.media.ccc.de/public/recordings/36716","event_url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":99,"length":3725,"mime_type":"video/mp4","language":"deu","filename":"froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-10T19:48:34.654+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/h264-sd/froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_sd.mp4","url":"https://api.media.ccc.de/public/recordings/36721","event_url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":140,"length":3725,"mime_type":"video/webm","language":"deu","filename":"froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2019-08-10T19:57:31.726+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/webm-sd/froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/36726","event_url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"},{"size":329,"length":3725,"mime_type":"video/webm","language":"deu","filename":"froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2019-08-10T20:26:10.265+02:00","recording_url":"https://cdn.media.ccc.de/events/froscon/2019/webm-hd/froscon2019-2433-deu-Neues_in_Open-Source-SQL-Datenbanken_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/36743","event_url":"https://api.media.ccc.de/public/events/a2f61e35-bf54-4cf9-9362-e4d04fa94915","conference_url":"https://api.media.ccc.de/public/conferences/froscon2019"}]}