Over the years I’ve experimented with several autocomplete scripts, some were really nice to implement, others were really weak sauce. Recently, I had to once again implement an autocompete field in an input form, and decided it was time to take another look at my favorite library, jQuery, to get this done.

A recent experience with postgreSQL forced me to get to know some of the syntax and associated architecture associated with a postegreSQL (w/ PHP) environment. I’m documenting a few tips which would have been helpful, Google is great, no question, but postgreSQL is not the most documented… so here’s my newb tips.