Skip to content Skip to sidebar Skip to footer
Showing posts with the label Full Text Search

Sqlite With Real "full Text Search" And Spelling Mistakes (fts+spellfix Together)

Let's say we have 1 million of rows like this: import sqlite3 db = sqlite3.connect(':memory… Read more Sqlite With Real "full Text Search" And Spelling Mistakes (fts+spellfix Together)

Poor Performance When Trigram Similarity And Full-text-search Were Combined With Q Ind Django Using Postgres

I'm creating a web application to search people with their properties such as education, experi… Read more Poor Performance When Trigram Similarity And Full-text-search Were Combined With Q Ind Django Using Postgres

Properly Install Sqlite3 With FTS5 Support

I'm developing a Python tool which uses a sqlite3 virtual table with FTS5 (Full Text Search). I… Read more Properly Install Sqlite3 With FTS5 Support