<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=us-ascii">
<META NAME="Generator" CONTENT="MS Exchange Server version 6.5.7654.12">
<TITLE>added support for FTS3</TITLE>
</HEAD>
<BODY>
<!-- Converted from text/rtf format -->
<P><FONT SIZE=2 FACE="Arial">Hi all,</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">For info : I just committed a number of additions for better support of FTS3 fulltext searches within DBD::SQLite; in particular, adding hooks for tokenizers written in Perl, adding documentation and tests.</FONT></P>
<P><FONT SIZE=2 FACE="Arial">I changed the compilation flag to use -DSQLITE_ENABLE_FTS3_PARENTHESIS (recommanded by the SQLite team for new applications), and added the following note into the documentation :</FONT></P>
<P><FONT SIZE=2 FACE="Arial">B<Incompatible change> : </FONT>
<BR><FONT SIZE=2 FACE="Arial">starting from version 1.31, C<DBD::SQLite> uses the new, recommended</FONT>
<BR><FONT SIZE=2 FACE="Arial">"Enhanced Query Syntax" for binary set operators (AND, OR, NOT, possibly </FONT>
<BR><FONT SIZE=2 FACE="Arial">nested with parenthesis). Previous versions of C<DBD::SQLite> used the</FONT>
<BR><FONT SIZE=2 FACE="Arial">"Standard Query Syntax" (see L<<A HREF="http://www.sqlite.org/fts3.html#section_3_2">http://www.sqlite.org/fts3.html#section_3_2</A>>).</FONT>
<BR><FONT SIZE=2 FACE="Arial">Unfortunately this is a compilation switch, so it cannot be tuned</FONT>
<BR><FONT SIZE=2 FACE="Arial">at runtime; however, since FTS3 was never advertised in versions prior</FONT>
<BR><FONT SIZE=2 FACE="Arial">to 1.31, the change should be invisible to the vast majority of </FONT>
<BR><FONT SIZE=2 FACE="Arial">C<DBD::SQLite> users. If, however, there are any applications</FONT>
<BR><FONT SIZE=2 FACE="Arial">that nevertheless were built using the "Standard Query" syntax,</FONT>
<BR><FONT SIZE=2 FACE="Arial">they have to be migrated; but the conversion </FONT>
<BR><FONT SIZE=2 FACE="Arial">function provided in in L<DBD::SQLite::FTS3Transitional></FONT>
<BR><FONT SIZE=2 FACE="Arial">is there to help.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">All of this is committed directly into trunk; I hope this is OK with the current release plan.</FONT>
</P>
<P><FONT SIZE=2 FACE="Arial">Best regards, Laurent Dami</FONT>
</P>
</BODY>
</HTML>