Archive for the ‘MySQL’ category

Starting with Zend_Search_Lucene

March 11th, 2009

As websites grows, searches like “LIKE title ‘%search term%’” becomes unreliable. There are very good solutions like Sphinx, Lucene, etc, but not surprisingly, you can’t always have Sphinx installed (shared servers again) and other solutions should be chosen.
MySQL supports full-text indexing, but it doesn’t give a lot of control over actual index. Luckily, Zend [...]

Comments (9) | TrackBack URI

Solving Sudoku puzzle with only MySQL

February 11th, 2009

More than a year ago I’ve read very interesting article in Lamneth blog about MySQL Sudoku solver. I’ve searched for some time, but information was very minimal and I couldn’t find a way to contact original author. So I decided to try it myself and easily found working solution.
Beauty of solving Sudoku puzzle in MySQL [...]

Comments (8) | TrackBack URI