Speeding things up with materialized views and MySQL

First let’s see what Wikipedia says about materialized views:

A materialized view takes a different approach [from the regular sql view] in which the query result is cached as a concrete table that may be updated…

Very hacky way to get client’s country code based on IP

You’d think that by now there should be an easier way to accomplish something like this.
(i.e. Send a client IP to some service, and get their country or other location information).

Important database session limitation

If you are using a database to keep your sessions, there is one rather significant limitation which you should be aware of.

It does depend on the specifics of your DB, but I am going to guess that in most cases it is something that could…

Show git branch in your bash prompt

Quite a convenient little snippet. Thought I would share it with all my dear readers and git lovers.

(Thanks to the original author, whom I cannot remember right now. I’ll gladly post the link to the original source if someone reminds me)

Helpful jQuery modals

This post is actually mostly about jQuery (with some cake sprinkles), but why not…

Let’s examine a typical situation:

We have a Product model, which belongsTo a Category model.

Quickly grant Auth access to multiple controllers

Common way to allow Auth access to all actions in a controller is to do something like this:

[cc lang=”php”]
//In some controller

A simple shell to hash your passwords

If you are moving data into a CakePHP environment and the passwords in the existing DB aren’t hashed, you can use the simple shell provided below to hash them according to the cake’s standard.
In case the passwords are already hashed using a different method, this…

Solving the country/state problem with CakePHP and jQuery

I’d say that it is a pretty common issue (and maybe not quite “a problem”), where you would have a page with a billing form, which in turn, has a “Country” select as well as a “State” select.
Obviously not all countries have…