Technology Radar
Published : Mar 29, 2022
NOT ON THE CURRENT EDITION
This blip is not on the current edition of the Radar. If it was on one of the last few editions, it is likely that it is still relevant. If the blip is older, it might no longer be relevant and our assessment might be different today. Unfortunately, we simply don't have the bandwidth to continuously review blips from previous editions of the Radar.
Understand more
Mar 2022
Assess
尽管代码静态检查已经是软件工程中的古老实践了，但它在数据领域中的应用仍十分缓慢。SQLFluff是一个python实现的跨SQL方言的linter，它提供了简单的命令行界面（CLI），可以很容易地整合进CI/CD流水线。如果默认配置就适合你，那么SQLFluff在安装后无需任何额外设定就可工作，它会强制执行一套鲜明风格的标准来格式化代码，当然，你也可以通过添加一个dotfile设定自己的代码规范。这个命令行工具还能自动修复诸如空格或者关键词大小写等违反代码规范设定的格式错误。SQLFluff虽然还很年轻，但是SQL代码静态检查圈内获得更多关注是一件让人兴奋的事。
