Httpremix - httpremix.com - JonahEllison.com
General Information:
Latest News:
21,640 Translated Country Names (Unicode CSV) 30 Jul 2011 | 04:16 am
Here's a UTF-8 CSV file of translated country names in 114 languages to open in Excel or import to a database: translated_country_names.zip (177KB) read more
WARNING: Use Drupal 6 Taxonomy "Synonyms" and "Related Terms" With Care! 10 Jun 2011 | 05:29 pm
Spent all day battling this. Drupal 6.x core (up to 6.22 as of today) has a critical bug that causes data loss when using taxonomy synonyms and related terms: http://drupal.org/node/251255. (This is a...
Why I'm Not Afraid of Outsourcing 29 Dec 2010 | 05:32 pm
The first website i made was for $5 :) the client got impressed and paid me extra $3 —Indian Drupal Developer (groups.drupal.org) For the past decade, the media has struck fear into workers by remi...
JonahEllison.com v6.0 — Not So Personal Anymore 20 Sep 2010 | 06:46 am
This is my sixth "personal" website I've built in the past ten years. My first site used plain HTML files, then server-side includes (SSI), next ASP.NET/C#, and now finally, Drupal! After much though...
Why I Ditched Lighttpd For Nginx 19 Sep 2010 | 03:52 pm
Everyone makes mistakes. Two years ago in early 2008 I chose lighttpd 1.5 as my preferred lightweight webserver and Apache alternative (for those of you who don't follow HTTP server software, Apache ...
MySQL Subquery Optimization and using UPDATE with INNER JOINs 4 Apr 2009 | 05:01 pm
Two advanced MySQL tips today: Never use a subquery inside a WHERE field IN(...) list How-to: Update values in a table from a calculation that uses the table's own values, in a single query read mo...
Page Caching for Logged-in Users: Loading Dynamic Content with Ajax (Authcache) 14 Mar 2009 | 06:00 pm
How fast do your dynamic PHP/MySQL pages load? Answer: not fast enough. A truly optimized website should serve pages instantaneously to its visitors. There should be no lag time, even 200 milliseconds...
Automating Server Backups Using "rsync/ssh/cron" on a Windows or Linux Machine 8 Oct 2008 | 07:00 pm
Everyone knows backups are important, not just for restoring from a system failure, but also for fixing user/admin/developer mistakes. Here's an efficient way to automatically backup files on your Lin...
CSS: How to Style Perfect HTML Lists (<ul><li>, <ol><li>...) 13 Jun 2008 | 11:28 am
Here is an example of a default HTML list with no CSS styling: This is what I consider an ugly HTML list. Almost every website incorporates lists. We love to make lists because it chunks data into s...
MySQL Tips & Tricks: Using ORDER BY FIELD and GROUP_CONCAT() 12 Jun 2008 | 07:00 pm
I love databases because I always feel there is a way for retrieving my data in any shape or form I desire. Trying to find the correct syntax can sometimes be frustrating, however. Here are two tricks...
