RECENT POSTS
- Introduction to FreeBSD Security Best Practices
- Working with Package Management in FreeBSD
- Understanding FreeBSD Security Advisories and Updates
- Troubleshooting Common System Administration Issues in FreeBSD
- Tips for Hardening FreeBSD to achieve System Protection
- Setting Up DHCP Server in FreeBSD
- Secure User and Group Management in FreeBSD Systems
- Secure Remote Access with SSH in FreeBSD
- Optimizing System Performance in FreeBSD
- Network Packet Capture with tcpdump in FreeBSD
- All posts ...
Do you have GDPR compliance issues ?
Check out Legiscope a GDPR compliance software, that will save you weeks of work, automating your documentation, the training of your teams and all processes you need to keep your organisation compliant with privacy regulations
Plpgsql_check
Jul 20, 2023
PostgreSQL extension to check PL/pgSQL code
plpgsql_check is next generation of plpgsql_lint. It allows to check source code by explicit call plpgsql_check_function. PostgreSQL 9.4, 9.5, 9.6, 10, 11 are supported Develop 12 is supported too. The SQL statements inside PL/pgSQL functions are checked by validator for semantic errors. These errors can be found by plpgsql_check_function.
Features
- check fields of referenced database objects and types inside embedded SQL
- using correct types of function parameters
- unused variables and function argumens, unmodified OUT argumens
- partially detection of dead code due RETURN command
- detection of missing RETURN command in function
- try to identify unwanted hidden casts, that can be performance issue like unused indexes
- possibility to collect relations and functions used by function
- possibility to check EXECUTE stmt agaist SQL injection vulnerability
Checkout these related ports:
- Zodb3 - Z - Object Database for python
- Zodb - Python object-oriented database
- Zabbix22-libzbxpgsql - Zabbix agent module for comprehensive monitoring of PostgreSQL servers
- Xtrabackup8 - Open-source backup tool for InnoDB and XtraDB
- Xtrabackup - OpenSource version of InnoDB backup with support of Percona extensions
- Xrootd - Framework for fast, low latency, scalable data access
- Xls2txt - Utilities to convert spreadsheet files to text and csv formats
- Xapian-core12 - Probabilistic text search database engine
- Xapian-core10 - Probabilistic text search database engine
- Xapian-core - Probabilistic text search database engine
- Xapian-bindings12 - Bindings allowing Xapian to be used from various programming languages
- Xapian-bindings - Bindings allowing Xapian to be used from various programming languages
- Wfb2sql - CIA World Fact Book to SQL Conversion Utility
- Webdis - HTTP interface for Redis
- Vsqlite - Well designed and portable SQLite3 Wrapper for C++