Log Every Failed Login Attempt in WordPress (Custom Table + Rotation + Auto-Ban)
A forensic-grade failed-login logger: custom database table, rotated weekly, with IP, username, user agent, country, and timestamp for every failed…
SQL Snippets(4)
SQL snippets and guidance for database development. Covers key topics like choosing between single and multiple LINQ to SQL data contexts for your data layer architecture, and simulating Oracle-style rownum functionality in MySQL queries.
Clean Up Autoloaded wp_options Bloat (Drop TTFB in One Afternoon)
Every WordPress page load reads the entire autoloaded portion of wp_options into memory. On a 3-year-old site that can be…
LINQ to SQL: Single Data Context vs Multiple (Legacy Guide + EF Core Notes)
The 2010 debate on whether to use one giant LINQ to SQL DataContext or split by schema/feature. Preserved here with…
ROWNUM Simulation in MySQL (Legacy Tricks + ROW_NUMBER() Since MySQL 8)
The original pre-MySQL 8 tricks for simulating Oracle's ROWNUM pseudo-column using user-defined variables, plus the modern ROW_NUMBER() window function that…