September 29, 2005
MySQL FULLTEXT Indexing and Searching
MySQL has supported FULLTEXT indexes since version 3.23.23. VARCHAR and TEXT Columns that have been indexed with FULLTEXT can be used with special SQL statements that perform the full text search in MySQL.To get started you need to define the FULLTEXT index on some columns.
September 27, 2005
Agile Software Development with Jason Fried
I don't listen to podcasts regularly - only when I see one that looks interesting, or someone points me to one. My brother Steve pointed me this IT Conversations podcast with Jason Fried of 37 Signals, on Lessons learned while building basecamp.
September 22, 2005
CSS Techniques Roundup - 20 CSS Tips and Tricks
I never cease to be amazed at what problems can be solved with pure CSS.
September 21, 2005
Best of 2002
I have picked up quite a few new readers over the last few months so I though I would uncover some old blog entries. I started blogging in 2002 and I wrote very few blog entries that year - but some of these entries have remained popular in the search engines.
September 21, 2005
4 Google Tricks
Here are four things I didn't know you could do in a google search until recently:Fuzzy Search - Search for ~music player, and google searches for music player, mp3 player, audio player, and other words that have similar meanings to music.
September 19, 2005
Stopping Pre Approved Credit Card Offers
Those of you that know me personally know that I'm a pretty laid back kind of guy. There are a few things that really annoy me - traffic, and junk mail.
September 19, 2005
No I wasn't avoiding you
I just realized today that my web contact form was not working. It has been down for a few months, but I think I was able to recover all the messages. I have been replying to them...The problem was that I had hard coded localhost as the SMTP server to send the messages to myself.
September 19, 2005
Want additional DB or OS support in ColdFusion?
Are you burnin' for built-in PostgreSQL support in Macromedia ColdFusion (BlueDragon already has this)? How about FreeBSD? Debian Linux Support? Fedora Support? Additional J2EE servers? 64-Bit Operating systems?Then go and take the ColdFusion vendor support survey.
September 17, 2005
Oblique Strategies
As creative professionals we are often forced to be creative. I've always found that creativity does not come naturally, you can't be forced to be innovative. Additionally we are also often tasked to solve difficult problems, where the solution is not easy to come by.
September 14, 2005
Google Blog Search - Not Impressed
Google has no doubt not suprised anyone with their new Blog Search BETA.What is suprising is the search result quality. I was hoping the Google would use their immense trust of brain power to come up with a blog search that produces good accurate and relavent results. But they didn't.
September 14, 2005
EnterpriseDB - PostgreSQL with Oracle Compatibility
I have been hearing a bit of buzz about EnterpriseDB latley. I think the main reason is that they just secured $7 million in venture capital funding.What is EnterpriseDB?
EnterpriseDB is based on the source code for the open source PostgreSQL database server.
September 14, 2005
SQL to Select a random row from a database table
There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.
September 13, 2005
Howto Create an RSS 2.0 Feed
If you can learn HTML, you can easily learn how to build your own RSS 2.0 feeds. I'll take you through the steps to creating an RSS feed from scratch.Step 1: XML Declaration
Since RSS 2.0 must validate as XML, the first line in your rss feed must be the XML declaration.
September 12, 2005
Google Sitemaps Accepts RSS and Atom Feeds
In addition to Google Site verification I also noticed today that Google sitemaps is now accepting formats other than their sitemaps protocol schmea.Google sitemaps now accepts RSS 2.0 and Atom 0.3 feeds.
September 12, 2005
Google Site Verification
I just noticed today that you can verify that you own a web site from within the google sitemaps website. The process is simple - Google will tell you to create a file on your site (something like /GOOGLEea6f95a80579477e.html), then they check to see if its there.
September 12, 2005
Build a directory browser with ColdFusion
Most web servers have directory browsing disabled, but sometimes you want it to work for certain directories. Most web servers also allow you to setup specific settings for your directories for instance you could do it with an .htaccess file on Apache.
September 09, 2005
RDS Security Problems?
Erki Esken posted a comment on Ben Forta's blog asking if the source to the RDS plugin for Eclipse would be released. Forta's response was:"But, my gut feel is that it would not be a good idea to fully expose the source for RDS as that may create potential security problems.
September 07, 2005
Cheat Sheet for PostgreSQL
When I created my list of cheat sheets for web development last week, I left out PostgreSQL. Frank Reiser, asked why it was left out - and the reason was simply that I couldn't find one.Being a PostgreSQL fan, I decided to create a cheat sheet for postgresql myself.
September 07, 2005
Temporary Stored Procedures on SQL Server
I posted about doing fast bulk inserts with PostgreSQL last week, and with MySQL a while back. Now its time for Microsoft SQL Server.I'm using a technique similar to what I used for PostgreSQL for SQL server.
September 07, 2005
SQL Server Express 2005, Finally Installed
September 06, 2005
I got del.icio.us'd
Though it doesn't have quite the same allure as getting slashdotted, getting del.icio.us'd can also draw quite a bit of traffic.I posted a Cheat Sheet Roundup to my blog last thursday around 4pm EST. It made it to the del.icio.us/popular/ page in a few hours, and has been on there since.
September 02, 2005
A whole new kind of CFM
I learned about a new kind of CFM yesterday - cubic feet (of water) per minute.
September 01, 2005
Cheat Sheet Roundup - Over 30 Cheatsheets for developers
Lets face it, unless you have a photographic memory, no developer can remember all the different functions, options, tags, etc. that exist. Documentation can be cumbersome at times, thats why I like cheat sheets.
