Category Code

Entries 12 Total Description

Snippets, functions and even some classes I’d like to share.

StarSchema (OLAP) setup for reporting in CakePHP

Jun 4, ’09 7:38 PM

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.

Comments (0)

HTTP basic authentication in CakePHP with users from database

Jan 18, ’09 7:46 PM

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.

Comments (0)