Skip to main content

CakePHP and composite primary keys

Today, I was doing some comprehensive research about CakePHP framework, as a part of our web application framework research. I installed it and developed a sample application following the official documentation. Some interesting facts were found. And, here, I am listing down few of the advantages and disadvantages of this framework in relation to our existing systems.

CakePHP has many good characteristics such as easy configuration, easy installation, light weight etc. And also, it's a excellent RAD tool, and it will save development time in a great margin. The database tasks can be done without writing one single sql query. And, CakePHP can be used with or without apache rewrite module, there is a clean url mechanism inside the framework instead of url rewriting.

Naming convention is very important in CakePHP. Database tables should have the same name as the relevant model classes. For example, by naming the model "Orange", CakePHP can automatically infer that this model will be used in the "OrangeController", and will be tied to a database table called "Oranges".

Composite primary keys can't be used for data base tables. Even if composite primary keys are kept in the tables, those are not used by the framework. Framework uses only one field as the primary key. If you want to use composite primary keys, you should hand write all the queries related to that task.

Alternatively, If we want to add a existing table that have two fields which compose the primary key, then what we have to do is we should add a new 'id' field as the primary key, and that field will be used by framework, we can make the other two fields (previous composite primary keys) as unique keys.

After all, the fact that the composite primary keys can't be used with CakePHP is clearly mentioned in the official documentation as well.


johna said…
Of course, cakePHP is an excellent framework. Most importantly it provides a facility called 'cake bake', you can automatically create your views, controllers and models with it.
Your observation regarding composite primary keys is correct. Database should be carefully designed avoiding composite primary keys if you are using the cakePHP framework. I've done that in many cakePHP applications.

Popular posts from this blog

Common Characteristics of Enterprise Applications

Last week, I was conducting a tech talk about “Architectural Patterns of Enterprise Applications” with our team. The discussion was mainly based on Marin Fowler's famous book “Patterns of Enterprise Application Architecture”. So, I thought, it's good to write something about that in my Blog. Given below are few common characteristics of Enterprise Applications. If any software product has the following characteristics, we can identify it as an Enterprise Application. These ware originally documented by “Martin Fowler”, in his book “Patterns of Enterprise Application Architecture”. Persistent Data - Enterprise applications usually involve persistent data. The data is persistent because it needs to be around between multiple runs of the program—indeed, it usually needs to persist for several years. Also during this time there will be many changes in the programs that use it. Lot of Data - There's usually a lot of data, a moderate system will have over 1 GB of data organ

How to avoid those little issues one can get when creating new projects with Zend Framwork...

CSS styles my not apply to the templates : Some times this happens when you haven't created a virtual host for the application. After the virtual host is created styles will apply properly, or just use some url helper like "baseUrl" when linking the style sheets to the templates. Error messages when using the commands like "zf enable layout", "zf create db-table ....", "zf create model ...", "zf configure db-adapter", and "zf create action ...." etc... You may get error like "Action 'enable' is not a valid action", "Action 'configure' is not a valid action"......... etc... Reason for this may be, the Zend library is not in the include path. If so add the library path to the include path. Or check whether there are old libraries in any directories of include paths that conflicts with the new one. Check whether there is a one as a PEAR package. And check whether the "zf" c

How to create a waveform animation with HTML and JavaScript

Recently, for a pet project, I wanted to create an animation of a waveform based on the varying decibel level of the microphone input. I was thinking about a really simple way to accomplish this with SVG and JavaScript. Given below is the first sample code I did on the Codepen. You can change this code to use with any framework of your choice. For this sample code, I am using a random number as the microphone input. You can replace it with any other time based input. Code Pen : For this example, you need an HTML code snippet like the one given below. It’s just an SVG with a Polyline element inside.  <div style="text-align:center">   <svg height="150" width="400" id='svg'>     <polyline id="polyline-id" fill="none" stroke="#005c66" stroke-width="1" />   </svg> </div> And then the plain Javascript code to animate the polyline. You can