Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Improve way of storing user lists #40

Open
loicknuchel opened this issue Aug 24, 2019 · 0 comments
Open

Improve way of storing user lists #40

loicknuchel opened this issue Aug 24, 2019 · 0 comments
Labels
Tech improvment Improve codebase but not features or UX
Milestone

Comments

@loicknuchel
Copy link
Member

loicknuchel commented Aug 24, 2019

Groups, events, talks and proposals have a list of users linked (orgas, talks or speakers). The current way of doing this is quite ugly: we concatenate all ids with a ',' and save them to a string column.

We should investigate ways of keeping the foreign key on them, maybe using the postgres array type, or maybe using a join table. But this probably require a lot of query rewrites :(

@loicknuchel loicknuchel added the Tech improvment Improve codebase but not features or UX label Aug 25, 2019
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
Tech improvment Improve codebase but not features or UX
Projects
None yet
Development

No branches or pull requests

1 participant