Claudio Ribeiro shows how you can use explain and indexes to spot and remedy possible performance issues with your database before they strike.
Here's a compendium of practical MySQL optimization tricks - from bottlenecks to configuration and indexes. Leave your ORM behind and get your hands dirty!
Christopher presents Eloquent's polymorphic relationships in a human-friendly way - come learn what they're all about and master this awesome ORM!
Scott explains how we can have a secure, encrypted, and hack-proof database, but still use normal SELECT and search queries on it. Interesting stuff!
Developing WordPress themes and plugins on a local server can be problematic if it doesn't match your live system. Craig discusses synchronization options.
In this "next level Laravel" post, Younes explains an interesting approach to designing relationships with Eloquent: polymorphic relations.
Younes presents Eloquent Observers - a method of subscribing to changed on models and having those models notify all subscribers of changes. Check it out!
Younes extends OctoberCMS by building a soft-delete plugin, allowing you to delete posts by marking them as trashed, while still keeping them in the DB!
Wern Ancheta shows you how to build a Pokemon spawn location recorder app with CouchDB and the Slim Framework, wrapping it up in good security practices!
Andrew explains how to perform database-related tests in a Symfony app much faster - with a disposable in-memory SQLite database, avoiding any bulky mocks
Bruno demonstrates the use of Phinx, a framework-agnostic database migration package helping you write database-independent and versionable database changes
Wern creates a movie recommendation app with PredictionIO - a free machine learning engine
Bruno goes through the entire process of contributing to an open source project - from contact with the author to sending PRs. Come see how it works!
MySQL 5.7 introduced some awkward changes for older codebases and tends to break apps. Here's how to temporarily (or permanently) lower the strictness level
Parham re-introduces PDO ahead of the PHP 7 launch, preparing you for a transition from the soon-to-be removed insecure and deprecated mysql extension!