Database Articles

3 articles found

Advanced PHP Database Patterns: Beyond ORMs for High-Performance Applications

Discover advanced database patterns for PHP including retry mechanisms, bulk updates, statement caching, query classes, generators for memory efficiency, and PHPStan rules for test correctness. Learn when to use PDO directly over ORMs.

8 October 2025·18 min read

Database

Upgrading Legacy MySQL: From MyISAM to Modern MySQL 8.4

Technical guide to upgrading legacy MySQL databases from MyISAM with implied foreign keys to modern MySQL 8.4 with InnoDB, proper constraints, and modern features for enhanced security, performance, and data integrity.

18 August 2025·10 min read

Database

MySQL Performance Tuning for Complex PHP Applications

Database optimization strategies specifically tailored for bespoke PHP systems with complex queries

20 December 2024·12 min read