Niklas
Niklas
Just saw you also mentioned materialized views. The reservation I have for them is that we'd need to refresh the entire view every time permissions, roles, role assignments etc. change....
Eliminating a join like this would be great. We'd then have something akin to GitLab's `project_authorizations` table. You could even merge all the user tables like so: ```sql create table...
Few more thoughts: * We should add validation to prevent system-level permissions from being added to roles. Since roles are bound to projects, letting users assign the `SYSTEM_CONFIGURATION` permission or...
During the last maintainer's meeting, @stevespringett mentioned the option of us "ingesting" Alpine, which would give us more flexibility when it comes to changing the underlying model. We could do...
> I'm assuming there is the previously mentioned check constraint that one of `ldapuser_id`, `manageduser_id`, or `oidcuser_id` must be set? Yep. Naive way to do it: ```sql check ( (ldapuser_id...
FYI @jhoward-lm @ashearin. Needs more fleshing out obviously but raised it for now so we have it documented. Any opinions, input, or requests as to how this should look and...
> in the proposed `project_version`, should the `name` column be `version`? It felt odd at first to name a column in project_*version*, version. But not too opinionated on this so...
> It's also not unheard of to straight up use a UUID as the primary key either Oh yeah for sure. We've [started adopting](https://github.com/DependencyTrack/hyades-apiserver/blob/e28cb176390e55cfef4d6a7ced3067630e2a2b2b/src/main/java/org/dependencytrack/model/ComponentOccurrence.java#L60-L63) [UUIDv7](https://uuid7.com/) for new entities, and there...
Having the table name be plural would certainly help disambiguate this particular case. I have no strong opinions on singular vs plural for tables names either, but I do think...
I don't have much extra context here. The main issue is that simply switching to non-pointer slices makes the XML serialization *extremely* noisy, and potentially invalid according to the spec....