SQL(ite) question

Richard Gaskin ambassador at fourthworld.com
Tue Jan 14 17:05:23 EST 2020


Bob Sneidar wrote:
 > Yes, but the original question was about whether or not it could be
 > done with a single statement. Also I am not a big fan of full text
 > searches the way they are implemented typically. For instance, on our
 > copier vendor's websites they of course have searches, but what I end
 > up with are 10,000 hits and almost none of them relevant. This is
 > because they are not ranked, and the ranking makes all the difference
 > in the world.
 >
 > My method does not rank of course, but it is a quick one liner that
 > gets the job done (unless you have to build the query on the fly in a
 > repeat loop).

SQLite's FTS is described as providing ranking.  Maybe they were using 
an older version, or not using the full API?

-- 
  Richard Gaskin
  Fourth World Systems
  Software Design and Development for the Desktop, Mobile, and the Web
  ____________________________________________________________________
  Ambassador at FourthWorld.com                http://www.FourthWorld.com





More information about the use-livecode mailing list