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

skinnier plugins and themes tables #126

Closed
chuckadams opened this issue Dec 28, 2024 · 0 comments · Fixed by #155
Closed

skinnier plugins and themes tables #126

chuckadams opened this issue Dec 28, 2024 · 0 comments · Fixed by #155
Labels
backlog Not scheduled on any project or milestone

Comments

@chuckadams
Copy link
Contributor

When these were created, I went for the simplest thing to build DB queries on, thus exposing every field in the metadata as its own column, even though it was redundant with the JSON contained in the metadata column. While 42 columns for the plugins table is not that bad, it's still cognitive overhead we don't need to impose whenever we do modify the model or add alternate sources that may have different metadata. Postgres can index a jsonb column pretty aggressively if needed, and if we need more, there's always ElasticSearch and similar.

@chuckadams chuckadams added the backlog Not scheduled on any project or milestone label Dec 28, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
backlog Not scheduled on any project or milestone
Projects
None yet
1 participant