While waiting to find out if my hosting provider will change the minimum fulltext word length for MySQL, here’s what I’ve done in the meantime to deal with viable three-character search terms. First, I split the search string into the component words (an array). I subtract any stopwords (I’ve got a big list) and for… Continue reading Search Patch
Tag: MySQL
Searching and Minimum Word Length
Mike Boone, in the comments section of yesterday’s entry on searching (“Updated Search“), correctly points out that searching my site for a word that is less than four characters in length (like “php” or “cow”) does not work—no results are returned. Obviously, since I write about PHP on occasion, this is untenable. The problem is… Continue reading Searching and Minimum Word Length
Updated Search
I’ve been vastly updating the search functionality on my site. I’m still using MySQL‘s built-in FULLTEXT indexing to perform searches, but I’ve made the results page look a lot more (okay, almost exactly like) Google‘s. The main differences are that I’m not paginating search results (yet)—all searches limit to 10 results—and that I’m showing a… Continue reading Updated Search
Content Management: Spokane Database Schema
As promised, here’s my proposed database schema (using MySQL) for my Spokane Personal Publishing System. It’s long and technical, read on at your own risk.
Thoughts on Content Management
I’ve been thinking a long time about content management systems (which isn’t surprising considering developing various types of website CMSes is what I do for a living), how they pertain to weblogs and similar types of content, how to implement them in PHP and MySQL, and what type of system I would really like to… Continue reading Thoughts on Content Management
MySQL’s SET
I was just thinking today that MySQL’s SET datatype has to be the most underused feature of MySQL, and how I could implement a multiple category system for my ebooks using it, when I got the MySQL AB Newsletter and lo and behold, it has an article on using SET. I love fun coincidences like… Continue reading MySQL’s SET
On Blogs
This is a bit about the blog software I wrote for this site. If you’re into the technical aspects of blogs, or PHP and MySQL, you’ll be interested in this. If not, you can safely skip it and not really miss out on anything. I’ve taken to calling my home-grown blog software blognutt (“blog +… Continue reading On Blogs
Site Updates
I’ve been busy on this site the last few days with updates and revisions. To wit: Got the search feature working (finally). This is using MySQL’s built-in FULLTEXT indexing capabilities; it’s pretty slick, the first time I’ve played with it. It does natural language searches using frequency of keywords to produce relevancy scores… if you… Continue reading Site Updates