When you need to gather statistics and reporting data from a large number of transactions (easily >1'000'000 rows) you need to transfer that data over to a reporting-friendly format to keep request times down. One popular database design for this is called a Star Schema. This is a simple re-usable StarSchema setup for CakePHP.Read More
This is a few lines of code and explanations explaining how to get HTTP Auth to check against your normal users table.Intended audience:
• You want to provide a protected RSS feed.
• You want to provide a protected API.