Skip to content

PostgreSQL sink: normalise repo permissions into a repo_users join table #1559

@dcoric

Description

@dcoric

Follow-up to #1497 / #1532. Tracked by the TODO(#1497-followup) in src/db/postgres/repo.ts.

Repo permissions (canPush / canAuthorise) are stored as a JSONB column for v1 parity with the mongo/fs backends. A normalised repo_users(repo_id, user, role) table would be more queryable and indexable.

Depends on #1558 — existing JSONB data must be migrated into the new table.

Metadata

Metadata

Assignees

Labels

No labels
No labels

Type

No type
No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions