NAME
DBIx::TextIndex - Perl extension for full-text searching in SQL
databases
SYNOPSIS
use DBIx::TextIndex;
$index = DBIx::TextIndex->new({
index_dbh => $index_dbh,
collection => 'collection_name',
doc_fields => ['field1', 'field2'],
});
$index->initialize();
$index->add( key1 => { field1 => 'some text', field2 => 'more text' } );
$results = $index->search({
field1 => '"a phrase" +and -not or',
field2 => 'more words',
});
foreach my $key
(sort {$$results{$b} <=> $$results{$a}} keys %$results )
{
print "Key: $key Score: $$results{$key} \n";
}
DESCRIPTION
DBIx::TextIndex was developed for doing full-text searches on BLOB
columns stored in a database. Almost any database with BLOB and DBI
support should work with minor adjustments to SQL statements in the
module. MySQL, PostgreSQL, and SQLite are currently supported.
As of version 0.24, data from any source outside of a database can be
indexed by passing the data to the "add()" method as a string.
CHANGES
0.27
Fixed POD coverage test error
0.26
Fixed problem with re-indexing a document several times with
SQLite (rt.cpan.org #16247)
Stoplists now work with QueryParser
unscored_search() was returning internal document ids instead of keys
Fixed table_exists() in case schema name is prefixed to table name
in results of DBI->tables() call