From: "Jesús Gabriel y Galán" <jgabrielygalan@...>
Date: 2011-03-17T21:05:29+09:00
Subject: Question about amalgalite and fts3

Hi,

I was happily using a script that used Sequel and Amalgalite to read a
sqlite database (the one generated by gnome-hamster-applet), until I
upgraded to Ubuntu 10.10.
Now, my script fails with:

/home/jesus/.rvm/gems/ruby-1.8.7-p334/gems/amalgalite-1.0.0/lib/amalgalite/statement.rb:33:in
`prepare': Amalgalite::SQLite3::Error: Failure to prepare statement
PRAGMA table_info('fact_index') : [SQLITE_ERROR 1] : no such module:
fts3 (Sequel::DatabaseError)
	from /home/jesus/.rvm/gems/ruby-1.8.7-p334/gems/amalgalite-1.0.0/lib/amalgalite/statement.rb:33:in
`send'
	from /home/jesus/.rvm/gems/ruby-1.8.7-p334/gems/amalgalite-1.0.0/lib/amalgalite/statement.rb:33:in
`initialize'
	from /home/jesus/.rvm/gems/ruby-1.8.7-p334/gems/amalgalite-1.0.0/lib/amalgalite/database.rb:265:in
`new'
        [*snip many more lines*]

I've read that fts3 is a SQLite extension module that can be enabled
or disabled when compiling sqlite. So, my question is, is there
something I can do to enable this module in Amalgalite?

Thanks,

Jesus.