Zoopy's new search algorithm and its evolution
Mar 9, 2009 6:04:24 PM
Today I implemented a new search algorithm on Zoopy. I've been working on this project over the last couple of months, on and off, and I thought I'd share with you some of the details and learnings. I can't divulge most of the efficiencies and optimizations for IP reasons, but I'll try to give you enough juice to make this post worth reading.
MySQL Search Relevancy Scoring
Aug 24, 2008 5:45:44 PM
Although MySQL's fulltext index functionality allows the relevance of search results to be determined easily, it is often the case that relevance is dependent on non-textual columns, or on business logic that is not easily modeled in a relational database. There are ways, luckily, to score results on these types of factors, but the implementation is not trivial.
phpMyAdmin 3.0.0-alpha released
Aug 11, 2008 10:16:40 AM
phpMyAdmin, that ubiquitous tool we all use for low-level MySQL database access (and some of us for content management as well), has released version 3.0.0-alpha. I had high expectations of the next major version of this tool, which have not been met in this alpha.
Mysql pseudo-inheritance with Zend_Db
May 15, 2008 7:23:57 PM
I've spent the last couple of days musing to myself about Zend Framework's extensibility. One particular feature that's always intrigued and impressed me is the way that Zend_Db handles rowsets and rows fetched by the Zend_Db_Table class: using inheritance it's possible define custom behaviour on both types of objects. As a demonstration of this, I thought I'd explore the concept of database object inheritance.
Quality control with PHP and Mysql
Dec 22, 2007 3:55:08 PM
For me, one of the toughest challenges in developing a CMS is quality control. Most projects I've worked on have had the requirement that users of the CMS should be able to edit content 'offline' (i.e. without affecting the live website) and preview it. Sounds simple enough, but it's trickier than that.
