News Feed
Sections




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

php|architect:
Full-text Search with SQLite
November 15, 2011 @ 09:53:50

On the php|architect site there's a recent tutorial from Jeremy Kendall about full-text searching in SQLite, a lightweight database alternative that, since it's stored locally, can be used without a full database server.

Full-text search with SQLite is so ridiculously easy to implement, there are only two valid reasons you haven't done it yet. The first is you don't need the full-text capability, and the second is you didn't know it could be done.

In his method he creates a full-text search table (using fts4) and populating it with your data. You can use the "MATCH" keyword in your SQL to find the closest matches and even handy modifiers like "NEARBY", wildcards and token/prefixes in queries. For more detailed information, check out the SQLite documentation for a full guide.

0 comments voice your opinion now!
fulltext sqlite search fts4 table


blog comments powered by Disqus

Similar Posts

Raphael Stolt's Blog: Creating Zend Framework snippets for TextMate

DotGeek.org: Free Hosting Goes Bingo!

Antony Dovgal's Blog: PECL/sphinx - fast fulltext search made easy

Zend Developer Zone: Whip Up a Yahoo! Mashup Using PHP

Cyberlot\'s Blog: Searching Zend Frameworks mailing list


Community Events





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


deployment threedevsandamaybe interview bugfix tips community language introduction framework symfony podcast zendserver list series voicesoftheelephpant release code conference api laravel

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