TechPrufer
Get started
PlanetScale
PlanetScale logoPlanetScale · Feature trail

CI-compatible Full-Text Search

1 post · Sep 2026

What this trail covers

PlanetScale offers TIN, a high-performance full-text search extension for PostgreSQL. For development and CI environments, they introduce Lead, a compatible but intentionally slower extension that provides the same SQL and TINQL interface. This allows developers to build and test applications using full-text search capabilities without the performance overhead of TIN in non-production settings, ensuring feature parity while managing costs and performance in CI.

All PlanetScale trails
  1. Introducing Lead: TIN-compatible full-text search for CIIntroduces Lead, a PostgreSQL full-text search extension designed for CI/development environments. Lead replicates the feature set of TIN (tokenizing, ACID compliance, BM25 scoring, highlighting) but intentionally sacrifices performance by using full table scans. This enables developers to build and test applications that utilize full-text search without the performance demands of TIN in production, offering a cost-effective and functional alternative for non-production use cases.