Archive for MySQL

My CakePHP Developer’s Tools

Posted in CakePHP, CakePHP 1.2 with tags , , , , , , , , , , , , , , , , , , , , on April 30, 2009 by myleskadusale

Eclipse Editor for Java can also be used also for developing using other languages like PHP, Python, XML, HTML, Javascript, C, C++, etc … by extending its functionality by using plugins for PHP/CakePHP you can use PHP Eclipse.

After installing eclipse and PHP Eclipse plugin you have to setup

Eclipse for developing in PHP/CakePHP. You have to set some settings in Eclipse go to Window -> Preference then select PHPeclipse

under it set some environment variables.

You could also try NetBeans for PHP

For your debugging needs you can use FireBug to debug and monitor CSS, HTML, and JavaScript live in any web page and for debugging PHP use FirePHP for your model and controller and Krumo for debugging your views

By the way if you are going to use Firebug and FirePHP you have to use Firefox to view the variables. To know how to setup Firebug and FirePHP Click here or here

If your using MySQL for your database you can use SQLyog to access your database.

To make PHP Eclipse support syntax highlighting for .ctp files refer here

Another great tool for developing CakePHP webapps is DebugKit 1.1, it displays Session variables, displays beautifully the SQL Logs and also displays explain result for the queries, and more.

For the tutorial on how to setup DebugKit Click Here

Dealing Large Tables in MySQL

Posted in MySQL with tags , , , , , on February 25, 2009 by myleskadusale

Today I found a site that gives good tips in dealing large tables in MySQL.

Why MySQL could be slow with large tables