{"repo":"okbob/plpgsql_check","free":true,"listed":false,"github":"https://github.com/okbob/plpgsql_check","clone":"git clone https://github.com/okbob/plpgsql_check.git","description":"plpgsql_check is a linter tool (does source code static analyze) for the PostgreSQL language plpgsql (the native language for PostgreSQL store procedures).","language":"C","stars":775,"topics":["plpgsql","postgresql","extension","c","postgresql-extension","function-plpgsql","stored-procedures","linter","profiler","pldbgapi"],"license":null,"category":"databases-storage","readme_excerpt":"plpgsql check ============= This extension is a full linter for plpgsql for PostgreSQL. It leverages only the internal PostgreSQL parser/evaluator so you see exactly the errors would occur at runtime. Furthermore, it parses the SQL inside your routines and finds errors not usually found during the \"CREATE PROCEDURE/FUNCTION\" command. You can control the levels of many warnings and hints. Finally, you can add PRAGMA type markers to turn off/on many aspects allowing you to hide messages you already know about, or to remind you to come back for deeper cleaning later. I founded this project, because I wanted to publish the code I wrote for the two years, when I tried to write enhanced checking for PostgreSQL upstream. It was not fully successful - integration into upstream requires some larger plpgsql refactoring. But the code is fully functional and can be used in production (and it is used in production). So, I created this extension to be available for all plpgsql developers. If you want to join our group to help the further development of this extension, register yourself at that postgresql extension hacking google group. Features checks fields of referenced database objects and types inside embedded SQL validates you are using the correct types for function parameters identifies unused variables and function arguments, unmodified OUT arguments partial detection of dead code (code after an RETURN command) detection of missing RETURN command in function (common after exception","default_branch":null,"files":null,"tree":[],"storefront":"/r/okbob","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/okbob/plpgsql_check/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}