News for hackers. Stuff that matters.
Re:Sqlfluff the SQL Linter for Humans by nycjay on Wednesday October 06, 2021 @10:05AM (#28773343)
Sorry - didn't get a chance to go through the documentation much yet... A problem we are looking to catch early in the development process is for things we don't want folks to do, even if they are technically correct. For example, dropping a column or altering the datatype/nullability in such a way that the table goes into reorg pending. I know we can write our own regex to look for that specific syntax, but I've not yet found a tool with those kinds of rules either build out already, or easy to add/maintain.
Re:Sqlfluff the SQL Linter for Humans by amshank on Wednesday October 06, 2021 @11:49AM (#28774579)
It's pretty new functionality in sqlfluff, but it now supports user defined plugins for org-specific rules if you want to forbid something more obscure. Documentation is sketchy, but you can see the proof of concept here: https://github.com/sqlfluff/sqlfluff/tree/main/plugins/sqlfl...
Re:Sqlfluff the SQL Linter for Humans by mixmastamyk on Wednesday October 06, 2021 @08:06PM (#28780075)
Nice, need to forbid things like grants and setting owners that are being handled by a centralized routine.
Re:Sqlfluff the SQL Linter for Humans by nycjay on Thursday October 07, 2021 @05:30PM (#28792336)
Thanks, I'll take a closer look there...