OpenSlides / openslides-media-service

Media service for OpenSlides 3+
MIT License
0 stars 14 forks source link

Add separate `media` schema for media service tables #39

Closed gsiv closed 2 years ago

gsiv commented 2 years ago

The media service for OpenSlides 4 currently creates two tables, both of them in the public schema. This is problematic because the tables may clash with tables owned by other services in the same namespace.

For OpenSlides 3, the problem had been solved with https://github.com/OpenSlides/openslides-media-service/pull/21. The media service's single table is configurable which allows us to keep it apart from the backend's tables in its own media schema.

To avoid long-term problems with OpenSlides 4, the new media service's tables must also be kept out of public. The schema could be made configurable but it would suffice to hard-code the media schema, i.e., media.mediafile_data and media.resource_data.

Also see the equivalent change for the voting service: https://github.com/OpenSlides/openslides-vote-service/issues/61