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

Consider adding a packages_aggregates table #3299

Open
finestructure opened this issue Aug 16, 2024 · 1 comment
Open

Consider adding a packages_aggregates table #3299

finestructure opened this issue Aug 16, 2024 · 1 comment

Comments

@finestructure
Copy link
Member

finestructure commented Aug 16, 2024

We're technically updating the package record but what we're really doing is aggregating up build data. So it's not the package per se that's changing.

A cleaner solution would perhaps be to move this aggregate field platform_compatibility to a separate table since we're using packages as a convenient place to stick it.

Maybe packages_aggregates. It could hold platform_compatibility and score_details. I'll add an issue to track.

Originally posted by @finestructure in #3298 (comment)

@daveverwer
Copy link
Member

As an alternative we could add last_analyzed_at and last_ingested_at fields to make these dates explicit. One of the things I'd like to add to the portal (once it exists) is to surface these two dates to package authors and it feels better to have them be explicit rather than relying on updated_at.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants