Tool Open source
Lead is a deliberately non-production PostgreSQL text-search extension from PlanetScale for exercising TIN-compatible application SQL in development, testing, CI, and staging. It provides the TIN access method, TINQL parsing and tokenization, the `==>` search operator, scoring functions, and highlighting.
Lead does not store search data in its index. Each scan adds all table blocks as candidates to a lossy bitmap, after which PostgreSQL rechecks visible rows for exact TINQL and MVCC behavior; scoring rescans and retokenizes the indexed column or expression. It is designed as a slow, correctness-focused substitute for TIN at small scales, is unsuitable for production workloads, targets PostgreSQL 17 and 18, and loads as a normal extension without shared preload libraries.
1 use taken from transcripts — each links to the moment in the video.
Provides a test-compatible text-search implementation for PostgreSQL, including query parsing, scoring, and highlighting, without storing a separate search index.
1 in the library.