blue orange purple green

latest news

01.09.2006

This is where you can put your latest news or other elements.

read more ...

01.09.2006

This is where you can put your latest news or other elements.

read more ...

additional links

More....

txtSQL (pronounced 'text-sequel') is a class containing a variety of functions designed to mimic a database system, using only regular text files. CupCake CMS is an Open Source Content Management System built using CakePHP. CakePHP is a rapid development framework for PHP which uses commonly known design patterns like Active Record, Association Data Mapping, Front Controller and MVC.

Using CakePHP without a database

I wanted to use a flat file database. In particular txtSQL. Cakephp does not natively support a flatfile database yet. It does support SQLlite, but only for PHP 5 of course. I am stuck for now with PHP 4. txtSQL runs great on PHP 4, so deploying a site is easy, just copy the txtSQL text file database to the website and you are up and running.

This site is running txtSQL

To do the proof of concept I utilized the CupcakeCMS as the test case. Cupcake is a great little CMS for quickly deploying simple sites. Combined with txtSQL, I can simply copy the folders and run anywhere without having to setup a MySQL database.

This site is simply a fresh install of the cupcakeCMS package. Then I deleted the model files for cupcake CMS and added my own model files. I then made a txtSQL database that matched the original MySQL database tables.

Future

I really need help to convert the custom models into a standard cakePHP datasouorce. I think it should be not difficult if someone who understands datasource could help!