12 min read
Full-Text Search in SQLite with FTS5
Go beyond LIKE queries. Learn how to build lightning-fast full-text search using SQLite FTS5 virtual tables with BM25 relevance ranking.
Read articleTag
This is a lightweight tag archive. It can help you find repeated concepts across posts, but topic hubs are the primary reading paths when you want a stronger sequence or a clearer problem-focused cluster.
This tag overlaps with the broader blog topic paths below. Use them when you want a more curated reading order rather than a raw tag archive.
Performance
Start here if your goal is faster SQL. This path connects indexing, execution plans, anti-patterns, and production query tuning.
Data Prep
Use this path when the hard part is turning messy files, semi-structured payloads, or staging tables into something you can query with confidence.
This tag is also connected to practical tools. Use these workflow hubs when you want to apply the concept directly instead of reading more articles first.
Conversion
Useful when JSON, CSV, spreadsheets, or SQL seed files need to move quickly between application payloads and relational tables.
Analysis
Best when a query already exists and you need to explain it, spot performance risks, or translate search logic into SQL-friendly patterns.
Go beyond LIKE queries. Learn how to build lightning-fast full-text search using SQLite FTS5 virtual tables with BM25 relevance ranking.
Read articleIs your query taking forever? Learn proven optimization techniques: indexing strategies, JOIN optimization, subquery rewrites, and execution plan analysis.
Read articleNeed to store intermediate results without cluttering your database? Learn when and how to use Temporary Tables for complex analysis.
Read articleNeed 1,000 rows to test your query performance? Don't write a Python script. Learn how to use Recursive CTEs to generate massive datasets directly in SQLite.
Read articleSQLite doesn't support materialized views, but you can build them yourself! Learn how to use triggers to create high-performance cached summary tables.
Read articleWhy does "Page 10,000" load so slowly? Learn why OFFSET is widely considered harmful for large datasets and implementation the high-performance "Seek Method" (Keyset Pagination) in SQL.
Read articleIs your query working but slow? You might be using an Anti-Pattern. Learn about SARGability, Implicit Conversions, and why your WHERE clauses are bypassing your indexes.
Read articleLearn how to choose the right SQL data types for performance and storage. We dive into INT vs BIGINT, VARCHAR vs TEXT, and precision management.
Read articleStop guessing why your queries are slow. Learn to read SQL execution plans, understand EXPLAIN output, and spot performance bottlenecks like full table scans.
Read articleUnderstand the difference between EXISTS and IN in SQL. Learn which performs better and avoid the NOT IN NULL trap.
Read articleWhy is my query slow? The answer is usually indexes. Learn how database indexes work, when to create them, and how they speed up your SQL.
Read articleIs your database crawling? Learn the 3 most common reasons for slow SQL queries and how to use the EXPLAIN command to fix them.
Read articleTags are kept as cross-cutting archives, not as the main blog information architecture. If you are choosing where to start, the topic hubs usually provide a better reading order and clearer surrounding context.