Gabriel Harper's Blog

I use a lot of different software in my job, but there are five software tools in particular that I can do nearly all of my Web development with. The best part is they are allcompletely free applications. You can download and install everything you need to be up and coding in under 30 minutes.

(more…)

This is a completely portable PHP script that fetches similar threads from a vBulletin forum. It does not require global.php or any other vBulletin scripts to run. The script uses full score matching, and supports search engine friendly URLs made by vBSEO and other custom formats.

(more…)

I was recently using phpMyAdmin to export some records from an URL shortener I’m working on. As usual I verified that “Complete inserts” and “Extended inserts” were enabled for the SQL dump. Why? Using both of these options reduces your SQL filesize and explicitly declares each column name.

(more…)

Data modeling is the practice of representing data structures and their relationships through conceptual modeling. The benefits of implementing this process during the design phase of your database project include improved data integrity, a more efficient development cycle, a clearer vision of the entities that are being represented in your database, and a powerful visual aid for collaboration and database design.

(more…)