Database Articles

3 articles found

Browse by topic: PHP · Infrastructure · Database · AI & LLMs · TypeScript · Quality Assurance

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

A practical walkthrough for engineers maintaining pre-2010 MySQL schemas: six concrete failure scenarios MyISAM allows, and the transactions, constraints, and locking MySQL 8.4 and InnoDB use to close them.

18 August 2025·10 min read

Database

MySQL Performance Tuning for Complex PHP Applications

A practical guide to MySQL configuration tuning, indexing, query rewriting, partitioning, and caching for PHP systems running complex, high-volume queries

20 December 2024·12 min read