News Feed
Sections




News Archive
Looking for more information on how to do PHP the right way? Check out PHP: The Right Way

Content with Style:
Fulltext searches with Xapian and PHP
November 04, 2009 @ 08:19:13

New on the Content with Style blog today there's this tutorial looking at full-text searching combining Xapian and PHP to replace the slower full-text methods in something like a MySQL database.

Sometimes MySQL just isn't quick enough. Especially when it comes to fulltext searches. Everything needs to be indexed correctly, and if we're using different fields with different weights for a relevance percentage, things get very complicated quickly. Xapian to the rescue.

The Xapian library can be compiled and installed as a binding for your PHP installation. He includes some sample scripts to get you started - the SQL to build the table, a Xapian wrapper class, and three simple PHP scripts to search for, view and delete records. Some sample results are also included.

0 comments voice your opinion now!
fulltext search xapian mysql database tutorial


blog comments powered by Disqus

Similar Posts

Gonzalo Ayuso's Blog: Database connection pooling with PHP and React (node.php)

Codewalkers.com: Creating a CAPTCHA with PHP

NuoDB Blog: CodeIgniter - Fired Up on NuoDB

PHPMaster.com: Bulletproofing Database Interactions with PHPUnit's Database Extension

Fawad Hassan's Blog: Load More Using KnockoutJS, PHP/CodeIgniter (Part 1)


Community Events

Don't see your event here?
Let us know!


php7 podcast interview laravel configure performance api framework application series composer conference opinion introduction community voicesoftheelephpant example symfony2 part2 release

All content copyright, 2015 PHPDeveloper.org :: info@phpdeveloper.org - Powered by the Solar PHP Framework