{"guid":"ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","title":"Mandantensichere Geodatenverwaltung mit \"PostgreSQL Row Level Security\"","subtitle":null,"slug":"fossgis2022-14157-mandantensichere-geodatenverwaltung-mit-postgresql-row-level-security-","link":"https://pretalx.com/fossgis2022/talk/CXKRZJ/","description":"Die gleichzeitige Verwaltung mehrerer Mandanten (z. B. Kunden, Projekte oder Gemeinden) in einer einzelnen Instanz einer Software-Anwendung spielt in der heutigen IT-Welt eine immer größere Rolle. Dabei laufen mehrere Instanzen einer Anwendung in einer gemeinsam genutzten Umgebung, in der  jeder Mandant physisch integriert, aber logisch getrennt ist.\n\nMit dem Vortrag werden unterschiedliche Varianten mandantenfähiger Architekturen und deren Vor- und Nachteile aufgezeigt. Insbesondere wird dabei auf Skalierbarkeit, Wartungsaufwand, Flexibilität und Sicherheit eingegangen.\nAn einem konkreten Beispiel wird Schritt für Schritt die Migration einer dateibasierten Geodateninfrastruktur (Mandanten innerhalb einer hierarchischen Verzeichnisstruktur) in eine normalisierte relationale Multi-Tenant Datenbank (Mandanten innerhalb eines einzelnen Datenbankschemas) näher beleuchtet. Zur Anwendung kommt hierbei PostgreSQL/PostGIS, das seit Version 9.5 Sicherheitsrichtlinien für Zeilen (Row Level Security) zur Verfügung stellt. Zum Schluss werden Anwendungsfälle aus der Praxis vorgestellt und die daraus gemachten Erfahrungen diskutiert.","original_language":"deu","persons":["Franz Gusenbauer"],"tags":["fossgis2022","14157","2022","Daten, Datenbanken und Datenprozessierung","Geo","OpenStreeetMap","FOSS","Online"],"view_count":195,"promoted":false,"date":"2022-03-09T14:30:00.000+01:00","release_date":"2022-03-10T00:00:00.000+01:00","updated_at":"2026-02-06T17:15:12.863+01:00","length":1768,"duration":1768,"thumb_url":"https://static.media.ccc.de/media/events/fossgis/2022/14157-ad1bd4c1-c65b-514b-aba5-d02e0b0ae725.jpg","poster_url":"https://static.media.ccc.de/media/events/fossgis/2022/14157-ad1bd4c1-c65b-514b-aba5-d02e0b0ae725_preview.jpg","timeline_url":"https://static.media.ccc.de/media/events/fossgis/2022/14157-ad1bd4c1-c65b-514b-aba5-d02e0b0ae725.timeline.jpg","thumbnails_url":"https://static.media.ccc.de/media/events/fossgis/2022/14157-ad1bd4c1-c65b-514b-aba5-d02e0b0ae725.thumbnails.vtt","frontend_link":"https://media.ccc.de/v/fossgis2022-14157-mandantensichere-geodatenverwaltung-mit-postgresql-row-level-security-","url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_title":"FOSSGIS 2022","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022","related":[],"recordings":[{"size":150,"length":1768,"mime_type":"video/webm","language":"deu","filename":"fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_webm-hd.webm","state":"new","folder":"webm-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-03-10T09:30:08.423+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/webm-hd/fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_webm-hd.webm","url":"https://api.media.ccc.de/public/recordings/57973","event_url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":69,"length":1768,"mime_type":"video/webm","language":"deu","filename":"fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_webm-sd.webm","state":"new","folder":"webm-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-03-10T08:59:36.535+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/webm-sd/fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_webm-sd.webm","url":"https://api.media.ccc.de/public/recordings/57972","event_url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":19,"length":1761,"mime_type":"audio/opus","language":"deu","filename":"fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_opus.opus","state":"new","folder":"opus","high_quality":false,"width":0,"height":0,"updated_at":"2022-03-10T08:49:03.511+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/opus/fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_opus.opus","url":"https://api.media.ccc.de/public/recordings/57968","event_url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":26,"length":1761,"mime_type":"audio/mpeg","language":"deu","filename":"fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_mp3.mp3","state":"new","folder":"mp3","high_quality":false,"width":0,"height":0,"updated_at":"2022-03-10T08:48:03.909+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/mp3/fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_mp3.mp3","url":"https://api.media.ccc.de/public/recordings/57967","event_url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":51,"length":1768,"mime_type":"video/mp4","language":"deu","filename":"fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_sd.mp4","state":"new","folder":"h264-sd","high_quality":false,"width":720,"height":576,"updated_at":"2022-03-10T08:36:35.199+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/h264-sd/fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_sd.mp4","url":"https://api.media.ccc.de/public/recordings/57964","event_url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"},{"size":134,"length":1768,"mime_type":"video/mp4","language":"deu","filename":"fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_hd.mp4","state":"new","folder":"h264-hd","high_quality":true,"width":1920,"height":1080,"updated_at":"2022-03-10T08:13:39.520+01:00","recording_url":"https://cdn.media.ccc.de/events/fossgis/2022/h264-hd/fossgis2022-14157-deu-Mandantensichere_Geodatenverwaltung_mit_PostgreSQL_Row_Level_Security_hd.mp4","url":"https://api.media.ccc.de/public/recordings/57960","event_url":"https://api.media.ccc.de/public/events/ad1bd4c1-c65b-514b-aba5-d02e0b0ae725","conference_url":"https://api.media.ccc.de/public/conferences/fossgis2022"}]}