cloudnative-pg / cloudnative-pg/postgres-extensions-containers
[New Extension]: pglinter
- Dominant language
- Go
- Stars
- 56
- Forks
- 38
- Avg merge
- 4d 1h
- Merged PRs (30d)
- 15
Description
### Is there an existing issue for this extension request?
- [x] I have searched for an existing issue, and could not find a duplicate request.
### Extension Name
pglinter
### Project Repository URL
https://github.com/pmpetit/pglinter
### Extension Website URL (Optional)
[pglinter](https://pglinter.readthedocs.io/en/stable/)
### Short Description
Linter for database design.
for example, create a table with:
- one pk on a column "id"
- then, create an index on it
- then add unicity constraint on it.
This will create some duplicated indexes.
other example:
- create a table order in a schema "orders"
- create an other order_details in an other schema "public" with a fk on orders.order
it is not strictly forbidden by pg, but recognize it will be quite tricky to maintain (refresh,dumps....)
pglinter is here to create a sarif report about those wrong design.
### Main LICENSE Link
https://github.com/pmpetit/pglinter/blob/main/LICENSE
### License Compliance
- [x] The extension's license (linked above) complies with the list of allowed licenses.
### Known Dependent Extensions
n/a
### Component Owner and Maintenance Commitment
- [x] I/My organization commit to becoming the Component Owner and maintaining the extension image in the future.
### Additional Notes (Optional)
_No response_
### GitHub Handles of Component Owners
pmpetit
### Code of Conduct
- [x] I agree to follow this project's Code of Conduct
Contributor guide
Assessment
This issue has not been assessed yet.