Pglinter
As Dbre
I want to check for wrong db designs, created by dev or frameworks.
For example, create a primary key on one column, then add an index on this column, and also add an unicity constraint on it.
An other example : create a 50 columns table, create a pk with 49 first column, then add foreign key from this into an other table and create this linked table into an other schema, to be sure refresh will be complicated....
so that I could
In addition, teach them why it is wrong...
I already use such a tool, using some cloud run jobs... But it should be more easy if pglinter was include to the Aiven list of usable extensions.
1
vote