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.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