DBIx::TextIndex Perl extension for full-text searching in SQL databases
Download

DBIx::TextIndex Ranking & Summary

DBIx::TextIndex Tags

database SQL Perl module perl full-text searching SQL database search

DBIx::TextIndex Description

Perl extension for full-text searching in SQL databases DBIx::TextIndex is a Perl module used for full-text searching in SQL databases.SYNOPSIS use DBIx::TextIndex; $index = DBIx::TextIndex->new({ index_dbh => $index_dbh, collection => 'collection_name', doc_fields => , }); $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} "; }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. Requirements: · Perl

DBIx::TextIndex Related Software