I recently needed to do a regex search and replace on a large MySQL file. I often use my code editor for search & replace but I tried Komodo Edit, Sublime Text 2, and Gedit and they struggled greatly to open the file and none of them could search it. I know there's sed, grep + awk, etc. but I decided to give Python a try since I've been working at learning it.

A client asked me to import a bunch of data from his old CMS into PyroCMS. His old system had insecure passwords and a bunch of data that was tied to the user via the user id. I wrote a Migration to pull the data out of his old tables, register a secure PyroCMS user, and record the user's uploads and other data. Here's how and why...

Let's say we are writing a module named "vacations" that will display information about tourist destinations. Sometimes it's desirable to display your urls like: site.com/bahamas instead of site.com/vacations/bahamas. So here's how you can do that in more than one module...

This is a simple and quick way to generate a changelog for your project using your git commit messages

This post is an introduction for web developers who may have never used version control before. Learn how to control your websites' source code and even deploy the site without using ftp.

v1.0 of the Newsletter module was released on February 7, 2011 and adds an exciting new functionality to the PyroCMS platform.

To help make the development of PyroCMS modules easier I decided to put together a simple module that could be used for a template.

I recently needed to move a number of files from one server to another. I didn't feel like downloading them from the old server and then uploading them again so I threw together a super simple php script to do the job.

I needed a reliable way to generate screenshots of websites for a client's project I'm working on. I wasn't too wild about using a third party like thumbalizr or webshots if I could do it myself. I decided to detail my ordeal here in the hopes it will help somebody else...

I recently updated my aquarium computer from Ubuntu 9.04 to 10.04. I have a separate home partition for my data and wanted to make sure it survived untouched. I didn't see any step by step instructions so I decided to write a tutorial in the hopes that it will help someone else.

I needed a new computer and this time I decided to go with something a little less dull than the motherboard in a tin box... I knew that the guys at pugetsystems.com had put together a computer similar to this and it had ran without problems for a couple years. They had used the Eclipse System 6 (6 gallon) aquarium and I went with that too since an ATX motherboard fits perfectly along the back wall.