Maybe this is more a 'note to self' than anything else. No matter how much you think you won't need a database when you drop it, just make a backup before you do anyway.

Today for example, there is a server which has 2 environments on it: dev.example.com and staging.example.com. The client said they had pending changes on staging. We knew the client was only working on one environment.

So I thought it was safe to copy the staging environment over to dev, and I did!

I recently installed Zend Server CE on my MacBook Pro to check out the performance of the "partial page" caching Zend offers in their platform.

I was pleasantly surprised how simple it was to get up and running. Zend Platform CE installs its own version of Apache, PHP. If you're installing it on Windows or Mac, it will also install MySQL.

Everything is configured and controlled in your zend path. By default on the Mac it is /usr/local/zend.

Navicat is a cross platform (linux/mac/windows) MySQL/PostgreSQL client with a built-in SSH tunnel. This means if you have SSH access, you can use the same 'localhost' credentials as your web app, regardless of what IP you're accessing the site from. http://www.navicat.com/download/download.html

[img_assist|nid=10|title=|desc=|link=none|align=right|width=100|height=71]This article will show you how to order a server-side list of fruit from a database using drag and drop behavior and then save them back to the database in order.

I recently worked on a project which required an unordered list to be re-ordered and then saved. I wasn't about to make users enter numbers next to each item so I looked toward JQuery's UI library.

Objective: We will display a list of fruit. The user can then drag the fruit and click a button to save the new order in the database.