iamtgc

Exploring Stored Procedures in MySQL and PostgreSQL

December 19th, 2008 by tgc

The PostgreSQL PL/pgSQL procedural language is well documented here and the MySQL Reference Manual is available here. The MySQL documentation is, in my opinion, lacking, however the MySQL Stored Procedure Forum helps a great deal in making up for the lack of documentation.
Read the rest of this entry »

Posted in MySQL, Postgres | No Comments »


  

Running a FastCGI Application Server with a Lighttpd Front End

December 18th, 2008 by tgc

Running a FastCGI Application Server separately from the Web Server has been an increasingly popular topic. The FastCGI Wikipedia Article states some of the reasons for it -

“This separation allows server and application processes to be restarted independently — an important consideration for busy web sites. It also facilitates per-application security policies — important for ISPs and web hosting companies.”

The lighttpd web server includes the binary spawn-fcgi, which as the name suggests, allows you to spawn FastCGI processes. This can be done independently of the web server processes.
Read the rest of this entry »

Posted in Lighttpd, PHP | No Comments »

How to Fix or Remove Uncooperative Widgets in WordPress

December 3rd, 2008 by tgc

Recently, I was working with php-code-widget to include some custom PHP code in a WordPress widget.

Unfortunately, and much to my surprise, the custom code did not work flawlessly the first time and I was left staring at errors like:

“Fatal error: Call to undefined function test(); in wp-content/plugins/php-code-widget /execphp.php(37): eval()’d code on line 1″.
Read the rest of this entry »

Posted in MySQL, Wordpress | No Comments »

« Previous Entries Next Entries »