# Beyond FTS5: Building Transactional Full-Text Search in TursoDB

DevFeed: [Beyond FTS5: Building Transactional Full-Text Search in TursoDB](<https://devfeed.tech/articles/beyond-fts5-building-transactional-full-text-search-in-tursodb-5896.md>)

Original publisher: [Read original article](<https://turso.tech/blog/beyond-fts5>)

Author: Preston Thorpe

Published: 2026-01-27T00:00:00Z

Content type: article

Language: en

Sources: [Turso Blog](<https://devfeed.tech/sources/turso-blog.md>)

Topics: [AI search](<https://devfeed.tech/topics/ai-search.md>), [SQLite](<https://devfeed.tech/topics/sqlite.md>)

Tags: [building](<https://devfeed.tech/tags/building.md>), [rust](<https://devfeed.tech/tags/rust.md>), [search](<https://devfeed.tech/tags/search.md>), [sql](<https://devfeed.tech/tags/sql.md>), [sqlite](<https://devfeed.tech/tags/sqlite.md>), [tokenizers](<https://devfeed.tech/tags/tokenizers.md>), [turso](<https://devfeed.tech/tags/turso.md>), [vector](<https://devfeed.tech/tags/vector.md>)

## AI overview

Turso describes its native transactional full-text search engine, built on Tantivy. The article contrasts it with SQLite FTS5 and covers BM25 ranking, tokenizers, SQL index syntax, query-planner integration, and internal storage design.

## Source excerpt

How we built native, transactional full-text search in Turso on top of Tantivy, replacing SQLite's FTS5 with BM25 ranking and tighter query planner integration.