DBD::SQLite::FTS3Transitional - helper function for migrating FTS3 applications

  use DBD::SQLite::FTS3Transitional qw/fts3_convert/;
  my $new_match_syntax = fts3_convert($old_match_syntax);
  my $sql = "SELECT ... FROM ... WHERE col MATCH $new_match_syntax";

Starting from version 1.31, DBD::SQLite uses the new, recommended "Enhanced Query Syntax" for binary set operators in fulltext FTS3 queries (AND, OR, NOT, possibly nested with parenthesis).

Previous versions of DBD::SQLite used the "Standard Query Syntax" (see http://www.sqlite.org/fts3.html#section_3_2). Applications built with the old "Standard Query" syntax, have to be migrated, because the precedence of the OR operator has changed.

This module helps in the migration process : it provides a function to automatically translate from old to new syntax.

Takes as input a string for the MATCH clause in a FTS3 fulltext search; returns the same clause rewritten in new, "Extended" syntax.

Laurent Dami <dami@cpan.org>

Copyright 2010 Laurent Dami.

This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.

The full text of the license can be found in the LICENSE file included with this module.

DBD::SQLite::FTS3Transitional - The great new DBD::SQLite::FTS3Transitional!

Version 0.01

Quick summary of what the module does.

Perhaps a little code snippet.

    use DBD::SQLite::FTS3Transitional;

    my $foo = DBD::SQLite::FTS3Transitional->new();
    ...

A list of functions that can be exported. You can delete this section if you don't export anything, such as for a purely object-oriented module.

Laurent Dami, <dami at cpan.org>

Please report any bugs or feature requests to bug-dbd-sqlite-fts3transitional at rt.cpan.org, or through the web interface at http://rt.cpan.org/NoAuth/ReportBug.html?Queue=DBD-SQLite-FTS3Transitional. I will be notified, and then you'll automatically be notified of progress on your bug as I make changes.

You can find documentation for this module with the perldoc command.

    perldoc DBD::SQLite::FTS3Transitional

You can also look for information at:

* RT: CPAN's request tracker

http://rt.cpan.org/NoAuth/Bugs.html?Dist=DBD-SQLite-FTS3Transitional

* AnnoCPAN: Annotated CPAN documentation

http://annocpan.org/dist/DBD-SQLite-FTS3Transitional

* CPAN Ratings

http://cpanratings.perl.org/d/DBD-SQLite-FTS3Transitional

* Search CPAN

http://search.cpan.org/dist/DBD-SQLite-FTS3Transitional/

Copyright 2010 Laurent Dami.

This program is free software; you can redistribute it and/or modify it under the terms of either: the GNU General Public License as published by the Free Software Foundation; or the Artistic License.

See http://dev.perl.org/licenses/ for more information.