[Gambas-user] sqlite full text search i.e. virtual tables

Benoît Minisini benoit.minisini at gambas-basic.org
Sat Sep 2 14:50:49 CEST 2023

Le 02/09/2023 à 08:16, BB a écrit :
> Do we support queries on sqlite virtual tables? I am trying to implement 
> a full text search on names in 3 tables. sqlite3 has a full text search 
> (FTS) facility that seems to work quite well after limited testing* but 
> I can't seem to get access to it via gb.db conn.Find() or conn.Exec().
> The info on sqlite FTS can be found here <https://www.sqlite.org/fts5.html>.
> Any clues?
> tia
> Bruce
> * I can add, delete and change the base tables and can successfully 
> "update" the FTS "table". Queries executed outside Gambas work fine. The 
> search table has two columns, name and type where type is "person", 
> "building", "place". A simple query on the FTS would be something like 
> "SELECT * FROM namesrch WHERE name MATCH 'Haricot';"

The Exec() method allows you to run any SQL request, so I don't see why 
you couldn't use this SQLite extension.


Benoît Minisini.

More information about the User mailing list