[DBD-SQLite] [Fwd: [sqlite] DBD::SQLite with FTS3 finally works. here is how...]

[Darren Duncan]

I think the forwarded subject and body speak for themselves.

Thanks to Puneet Kishor for this bit of sleuth work.

So if indeed the new t/rt_50503_fts3.t test passes with an appropriately 
gut-swapped DBD-SQLite-Amalgamation, then the question will be in determining in 
what important way Audrey's version, which was supposedly merged into the 
mainline version already, still differs from the mainline version that matters.

-- Darren Duncan

-------- Original Message --------
Subject: [sqlite] DBD::SQLite with FTS3 finally works. here is how...
Date: Fri, 16 Oct 2009 00:23:56 -0500
From: P Kishor <punk.kish at gmail.com>
Reply-To: punkish at eidesis.org,        General Discussion of SQLite Database 
<sqlite-users at sqlite.org>
To: General Discussion of SQLite Database <sqlite-users at sqlite.org>

I started with DBD::SQLite 1.26_05 and went back as much as
DBD::SQLite 1.21. Kept on getting segfaults. Any further back, and I
got DBD::SQLite 1.14 which bundled FTS2, so that wasn't good as well.

Finally, the amazing Audrey Tang to rescue. I downloaded the classic
DBD::SQLite::Amalgamation 3.6.12
(http://search.cpan.org/~audreyt/DBD-SQLite-Amalgamation-3.6.1.2/),
replaced the .c and .h files in it with those from the latest tarball
of original source 3.6.19, built it, and it works just fine, thank you
very much.

Of course, now my problem is that I have to somehow convince my shared
web host provider to also do the above rigmaroo or wait until the
default version from CPAN starts working again.

FTS3, in my personal view, is far more useful and important than
getting Foreign Keys support. That is because the latter can be
emulated in the app code, but the former can't. Will be grateful when
FTS3 is working again flawlessly in the publicly available CPAN
version.

-- 
Puneet Kishor http://www.punkish.org
Carbon Model http://carbonmodel.org
Charter Member, Open Source Geospatial Foundation http://www.osgeo.org
Science Commons Fellow, http://sciencecommons.org/about/whoweare/kishor
Nelson Institute, UW-Madison http://www.nelson.wisc.edu
-----------------------------------------------------------------------
Assertions are politics; backing up assertions with evidence is science
=======================================================================
Sent from Madison, WI, United States
_______________________________________________
sqlite-users mailing list
sqlite-users at sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users