• Welcome, Guest. Please login.
 
June 01, 2020, 11:11:23 pm

News:

Welcome to the SQLitening support forums!


Add full text search?

Started by Paul Breen, April 21, 2008, 05:25:10 pm

Previous topic - Next topic

Paul Breen

April 21, 2008, 05:25:10 pm Last Edit: May 19, 2008, 11:03:21 pm by Paul Breen
If you compile your own sqlite (you have to add two source files) you can add full text search capabilities so theoretically at least you could start your own "googlette" with your client server sqlite. Doing a little reading on the internet the full text search of sqlite has been used to imitate the search format of google and to implement your own file system within a single database file.
See if you like the idea. Try googling "sqlite full text search" and interesting sites will pop up.

Update: Without documenting it sqlite has put fts into the precompiled binaries for windows so you don't have to compile your own dll any longer to get this feature.

This is one case where reading the instructions caused a lot of unnecesary trouble. I did learn how to compile the sqlite source code with visual studio 2005, it turned out to be easier than using FireFly ;D

aiting patiently for Vista out in the sticks.

Paul Squires

Hi Paul,

I had heard before about the FTS for SQLite. Up to now I have not had a need for it. I don't compile my own versions of the DLL. I will keep this in mind if there is a need from users and people want it.

Thanks!