HTML5 Presentation Tool

In my final semester of University I was part of a team who developed a prototype tool for creating interactive presentations targeted for Tablet devices. The client, Portable Studios, asked us to take advantage of the latest touch technology, and we built the project using the Sencha Touch Framework. The prototype uses a MySQL Database, and uses PHP to interface with this database, by using the CakePHP Framework.

I was mainly involved in the PHP and database development for the project.

Click on the link below to watch the video presentation of our project.



Many thanks to Rob Shilo for helping us make the video.

Project Team:
Alex Koumoundouros
Truong Thien Nguyen
Josephat Kadira
Alexander Conn
Jing Zhang

Problem Caching Queries with ColdFusion

ColdFusion will only cache queries if the SQL used within them stays exactly the same. This also means that the query's

• Name,
• Datasource,
• Database type,
• Username & password

must also remain the same. I ran into the mistake of adding the datetime variable Now() for a datetime field, and the query would not cache. Once I realised what the issue was, to get around it I simply used the date + hours portion of Now(), and replaced it in the query.

Below is an example of a query which can be cached for 1 hour.

When using cached queries, you should always ensure that the 'Maximum number of cached queries' in ColdFusion admin (Server Settings > Caching) is set to a higher number (I found my ColdFusion 9 was set to only cache 1 query). The value should be set depending on the amount of RAM in your server and the performance of your database.