{"guid":"16a1a1ce-98ce-5d69-9af1-49ca4f154640","title":"$QL from Hell","subtitle":null,"slug":"gpn18-110--ql-from-hell","link":"https://c3voc.de","description":"Fundstücke aus \"organisch gewachsenen\" Datenbanken und was wir daraus lernen können.\n\nArbeitsbedingt beschäftige ich mich regelmäßig mit diversen ERP-Lösungen von \"führenden Anbietern\" und insbesondere deren Datenbanken dahinter, z.B. zur erweiterten Datenauswertung oder Anbindung diverser Services. Dafür müssen die Datenbanken in der Regel reverse engineered werden (welcher Hersteller liefert schon eine Doku seiner DB mit...) und dabei finden sich immer wieder kleine bis seeehr große Schnitzer.\nDa Humor der beste Lehrer ist, bietet dieser Talk ein \"Best of\" grundlegender Designfails, kreativer Datentypennutzung und sehr speziellen Funktionen \"for the lulz\"!\nGrundlegende Datenbankkenntnisse bei Besucherinnen sind zwar von Vorteil aber definitiv nicht Vorraussetzung.","original_language":"deu","persons":["smtw"],"tags":["gpn18","110"],"view_count":1923,"promoted":false,"date":"2018-05-11T00:00:00.000+02:00","release_date":"2018-05-11T02:00:00.000+02:00","updated_at":"2026-03-27T08:45:06.059+01:00","length":1849,"duration":1849,"thumb_url":"https://static.media.ccc.de/media/events/gpn/gpn18/110-hd.jpg","poster_url":"https://static.media.ccc.de/media/events/gpn/gpn18/110-hd_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/gpn/gpn18/16a1a1ce-98ce-5d69-9af1-49ca4f154640-timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/gpn/gpn18/16a1a1ce-98ce-5d69-9af1-49ca4f154640-thumbnails.vtt","frontend_link":"https://media.ccc.de/v/gpn18-110--ql-from-hell","url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_title":"Gulaschprogrammiernacht 18","conference_url":"https://api.media.ccc.de/public/conferences/gpn18","related":[{"event_id":5325,"event_guid":"dda720ca-f11b-5ef5-beeb-5e33d2ed3e53","weight":144},{"event_id":5326,"event_guid":"ca1800bf-221d-5084-86ea-cbf946d18e04","weight":42},{"event_id":5329,"event_guid":"33c0a435-974b-5a65-9798-81ee2bfb925b","weight":47},{"event_id":5331,"event_guid":"6057325d-54d0-59d1-929e-880ee1320044","weight":17},{"event_id":5332,"event_guid":"ea7536ab-518e-5ec3-a897-7de5b1cc90cf","weight":53},{"event_id":5337,"event_guid":"50c2af4c-4826-50ee-bde7-cbed07d3bf2e","weight":126},{"event_id":5342,"event_guid":"a54ad163-540f-5d45-9359-16a5d76da4ae","weight":32},{"event_id":5343,"event_guid":"41f8b9a3-6245-5cf4-9c36-abfa5ffbd666","weight":45},{"event_id":5345,"event_guid":"d72cca24-92a0-50d6-8a89-52fcfaca062a","weight":17},{"event_id":5346,"event_guid":"0f7427d2-f0c5-5747-8966-79f0b2b679b5","weight":42},{"event_id":5347,"event_guid":"37586acb-300a-55f2-be87-9e3fda19ca9c","weight":31},{"event_id":5350,"event_guid":"47b7888b-3379-53e2-b2c8-6b004ae00550","weight":47},{"event_id":5354,"event_guid":"bc2263a7-7870-55d5-9458-63c8d51c2036","weight":72},{"event_id":5355,"event_guid":"8afc16c2-d76a-53f6-85e4-90494665835d","weight":96},{"event_id":5356,"event_guid":"6b10f088-835c-580f-875b-f6e5c4cce985","weight":21},{"event_id":5358,"event_guid":"25047665-60e0-5bbb-bd15-d5937103dc24","weight":81},{"event_id":5359,"event_guid":"42019c8e-4b3d-51a3-833c-0f83c0f543d5","weight":71},{"event_id":5366,"event_guid":"95457cf6-6e5c-530c-8ce8-8bf9662cb90a","weight":70},{"event_id":5370,"event_guid":"ea068ddc-aef6-5367-ba79-cd90ddbf8353","weight":97},{"event_id":5377,"event_guid":"412d3bab-a67c-589a-9c70-8bb128ab560e","weight":17},{"event_id":5378,"event_guid":"379ee1b1-ef9a-5572-8e9d-4c9d365278b4","weight":25},{"event_id":5379,"event_guid":"a3bda554-eb73-5a33-a14c-6303f83cc451","weight":54},{"event_id":5380,"event_guid":"acc35999-4707-5ef9-a8af-f3b197f09704","weight":88},{"event_id":5381,"event_guid":"2b148a03-ea3f-5aa8-8a6d-9cb7624f303e","weight":60},{"event_id":5383,"event_guid":"615d3190-d8b8-577b-ace4-abe25fff37c2","weight":17},{"event_id":5384,"event_guid":"0f649ccf-4188-5ec0-bf0f-0f761c69a709","weight":23},{"event_id":5388,"event_guid":"98391d79-4f04-5043-966b-25e33ce1bc37","weight":28},{"event_id":5389,"event_guid":"7de8a55e-c46b-504d-babe-4a25730417cd","weight":38},{"event_id":5390,"event_guid":"5821f506-1609-55b5-a58d-2ae972df0f78","weight":45},{"event_id":5391,"event_guid":"93474b10-fc14-5cd4-b316-77ffc49ff668","weight":23},{"event_id":5392,"event_guid":"24126bf1-66d4-53a6-b470-49e65ca4bdee","weight":22},{"event_id":5393,"event_guid":"faea7134-21b2-5264-9e02-a8706b63e7fc","weight":112},{"event_id":5394,"event_guid":"2c46ce35-9267-5c2a-9c45-0a7acd4406a4","weight":29},{"event_id":5397,"event_guid":"3ae378ab-25dd-5336-aaba-510a967785d7","weight":34},{"event_id":5398,"event_guid":"641f2cd4-5a49-5663-8105-0b4e2c13a724","weight":46},{"event_id":5401,"event_guid":"a8a4d912-70e6-5c64-b3dc-c55e4ecf292f","weight":30},{"event_id":5403,"event_guid":"1c78884b-36cd-5600-8ee6-df144c004259","weight":18},{"event_id":5407,"event_guid":"682090d6-32cf-52cd-9c58-c49a9c732200","weight":29}],"recordings":[{"size":252,"length":1849,"mime_type":"video/mp4","language":"deu","filename":"gpn18-110-deu-QL_from_Hell_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2018-05-11T18:10:52.838+02:00","recording_url":"https://cdn.media.ccc.de/events/gpn/gpn18/h264-hd/gpn18-110-deu-QL_from_Hell_hd.mp4","url":"https://api.media.ccc.de/public/recordings/24919","event_url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_url":"https://api.media.ccc.de/public/conferences/gpn18"},{"size":69,"length":1849,"mime_type":"video/mp4","language":"deu","filename":"gpn18-110-deu-QL_from_Hell_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2018-05-11T18:28:08.391+02:00","recording_url":"https://cdn.media.ccc.de/events/gpn/gpn18/h264-sd/gpn18-110-deu-QL_from_Hell_sd.mp4","url":"https://api.media.ccc.de/public/recordings/24930","event_url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_url":"https://api.media.ccc.de/public/conferences/gpn18"},{"size":28,"length":1839,"mime_type":"audio/mpeg","language":"deu","filename":"gpn18-110-deu-QL_from_Hell_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2018-05-11T18:29:04.359+02:00","recording_url":"https://cdn.media.ccc.de/events/gpn/gpn18/mp3/gpn18-110-deu-QL_from_Hell_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/24931","event_url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_url":"https://api.media.ccc.de/public/conferences/gpn18"},{"size":107,"length":1849,"mime_type":"video/webm","language":"deu","filename":"gpn18-110-deu-QL_from_Hell_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2018-05-11T18:29:36.873+02:00","recording_url":"https://cdn.media.ccc.de/events/gpn/gpn18/webm-sd/gpn18-110-deu-QL_from_Hell_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/24932","event_url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_url":"https://api.media.ccc.de/public/conferences/gpn18"},{"size":318,"length":1849,"mime_type":"video/webm","language":"deu","filename":"gpn18-110-deu-QL_from_Hell_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2018-05-11T18:36:17.806+02:00","recording_url":"https://cdn.media.ccc.de/events/gpn/gpn18/webm-hd/gpn18-110-deu-QL_from_Hell_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/24943","event_url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_url":"https://api.media.ccc.de/public/conferences/gpn18"},{"size":18,"length":1839,"mime_type":"audio/opus","language":"deu","filename":"gpn18-110-deu-QL_from_Hell_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2018-05-11T18:37:07.219+02:00","recording_url":"https://cdn.media.ccc.de/events/gpn/gpn18/opus/gpn18-110-deu-QL_from_Hell_opus.opus","url":"https://api.media.ccc.de/public/recordings/24944","event_url":"https://api.media.ccc.de/public/events/16a1a1ce-98ce-5d69-9af1-49ca4f154640","conference_url":"https://api.media.ccc.de/public/conferences/gpn18"}]}