Case sensitive find on CakePHP

This blogpost is not about how you can adjust your find statements to make them case sensitive on CakePHP. Instead if you want your find to be case sensitive just make sure your database takes care of this by using the utf8-bin collation.

That’s right, only changing the collation makes sure your SELECT queries become case sensitive!

 

CakePHP Plugin for New Relic

New Relic is an application monitoring solution for PHP (and other languages) which gives you more information about the performance of your application. It works well with all major frameworks (including CakePHP). Little problem for me is that CakePHP has it’s own error handling – which catches any error before it can be fetched by the New Relic PHP agent.

Because our server and availability monitoring is already done by New Relic, I decided to build a custom error handler in CakePHP which uses the PHP API of the New Relic PHP Agent. So all monitoring can be done through New Relic.

You can find the plugin with the error handler here: https://github.com/turnred/newrelic-cakephp (Work In Progress)