With OSX 10.11 El Capitan, here is how to get the AMP stack up and running. This tutorial will go through the process on getting Apache, MySQL, PHP (or otherwise known as the ‘AMP’ stack) and phpMyAdmin running on the El Capitan OS.
This tutorial sets up the AMP stack in more of a traditional way using the loaded Apache and PHP and downloading MySQL and phpMyAdmin. For Read More →

This MySQL tutorial explains how to create an AFTER INSERT Trigger in MySQL with syntax and examples.

An AFTER INSERT Trigger means that MySQL will fire this trigger after the INSERT operation is executed.

The syntax to create an AFTER INSERT Trigger in MySQL is:
CREATE TRIGGER trigger_name
ON table_name FOR EACH ROW


Read More →

SQLite performs inserts 8-14 times faster then InnoDB / MyISAM
SQLite performs updates 4-8 times faster then InnoDB and as fast as MyISAM
SQLite performs selects 2 times faster than InnoDB and 3 times slower than MyISAM
SQLite requires 2.6 times less disk space than InnoDB and 1.7 times more than MyISAM
Allowing null values or using synchronous=NORMAL makes Read More →

from : http://danielpetty.com/android-lamp-linux/
I recently purchased a Samsung Galaxy Tab (GT-6200) and quickly decided I needed to be able to do some web development and site testing when offline. I was happy to find that the process of getting a LAMP stack up and running can be relatively straightforward. In this post I’ll cover getting Debian Read More →