Select Substring Using RegEx in PostgreSQL

I thought of another handy scenario for using regular expressions in Postgres. This time not within the conditions, but in the returned results. Lets say for instance you have a column with URL, (maybe blog comments or something) and you would like to get a list of all the domain …



Reading a Book

Never thought I would say this since I'm long out of college, but I am in fact reading a book. (Hence why I've been quiet here on the blog the last few days) I purchased the The Smashing Book. So far it has been very educational. It is broken up …



Gedit PHP Completion and Collaboration

If you're a gEdit fan like I am you will be excited to see these plugins by Jesse van den Kieboom. First off a php completion plugin. This is something I've been hoping to find for quite some time. You can find it over at GitHub. The second thing is …



I'm Now On Twitter!

It took me long enough, but I'm now on Twitter! I actually had an account set up several months ago but never logged in. I decided it was time. My username is practicalweb. While I may not post every event in life, I will try to keep it up to …



jQuery Impromptu 3.0 is Here

Finally, Impromptu 3.0 has made it! It features two changes really. One big and one small. The small addition was an option for classes. So you can now add extra classes to an individual prompt to customize the styles without needing an entirely new theme. Here's the syntax: $.prompt …



Using Cakephp Components in Shells and Tasks

Not sure if cake has a prettier, more efficient way of grabbing components inside of Shells and Tasks with cakephp's cli, but here is a way which worked for me. Inside your Task (or Shell) just use the following in a similar manner for your component: class FooTask extends Shell …



New, Simplified Look

I've been looking into simplifying my site a little and yet improving some search engine optimization, and as you may have noticed I've made a couple tweaks. First I removed the busy space background, and went a little more solid(not really for seo, but was tired of seeing such …



How To Set JAVA_HOME in Ubuntu

This post is more for my memory than anything. I always forget and need to dig around to figure out how (or more importantly "where") to set JAVA_HOME in Ubuntu. It's pretty simple. Find the location of your jvm. ex: /usr/lib/jvm/java-6-sun/ Add a line to your environment …



Installing Memcached on Ubuntu for PHP

I've been playing around with caching and php, and thought I'd give a little insight on installing memcached on Ubuntu, and enable php-memcached. First start out by opening up your Synaptic Package Manager, search for "php memcached". Select and install "memcached" and "php5-memcache" Now everything should be installed. Restart Apache …



Using Impromptu for Spell Check: YUI, Dojo, NicEdit Editors

A common feature missing in many javascript editors is spell check. And if you are able to successfully use spell check it is also nice to have it cleanly integrated as a button on the wysiwyg toolbar. Guess What! Using jQuery Impromptu, jquery-spellchecker, and a small plugin I whipped together …