sqlite-fts4

import sqlite3 from sqlite_fts4 import register_functions # Connect to an in-memory SQLite database conn = sqlite3.connect(':memory:') # Register all custom FTS4 functions register_functions(conn) # Create an FTS4 virtual table conn.execute("CREATE VIRTUAL TABLE docs USING fts4(title, body);") # Insert some data conn.execute("INSERT INTO docs (title, body) VALUES (?, ?)", ("Hello World", "This is a test document with some words.")) conn.execute("INSERT INTO docs (title, body) VALUES (?, ?)", ("Python SQLite FTS4", "Exploring full-text search capabilities in Python with SQLite FTS4.")) # Perform a search and rank results using rank_score # 'pcx' is required for rank_score() cursor = conn.execute( "SELECT title, body, rank_score(matchinfo(docs, 'pcx')) as score FROM docs WHERE docs MATCH ? ORDER BY score DESC", ("python search",) ) for row in cursor.fetchall(): print(f"Title: {row[0]}, Score: {row[2]:.2f}") conn.close()