Posted inDatabase
Defeating SQL Injection in MySQL Production using ProxySQL Firewall
A guide to configuring ProxySQL Firewall for MySQL Production. Learn how to use Query Rules to block SQL Injection and set up secure query whitelisting.
Posted inMySQL
MySQL Connections in Python with PyMySQL and mysql-connector-python: Connection Pooling, Prepared Statements, and Safe Transactions to Prevent SQL Injection
A practical guide to connecting MySQL in Python using PyMySQL and mysql-connector-python: setting up Connection Pooling to reuse connections, using Prepared Statements to prevent SQL Injection, and handling Transactions safely with a context manager — complete code examples from quick start to production.
Posted inMySQL
Connecting MySQL in Node.js with mysql2: Connection Pooling, Prepared Statements, and Transactions
A guide to connecting MySQL in Node.js with the mysql2 library the right way, avoiding the common mistakes junior developers make. Learn how to use Connection Pooling for performance optimization, Prepared Statements to block SQL Injection, and Transactions to ensure data integrity when operating across multiple tables simultaneously.
Posted inSecurity
Mastering Burp Suite Community: The Ultimate ‘Weapon’ for Hunting SQL Injection, XSS, and IDOR for Developers
A guide on using Burp Suite Community Edition to find SQL Injection, XSS, and IDOR vulnerabilities. This article includes real-world examples to help developers enhance their web application security skills.