Tin: full-text search for Postgres

In one line

TIN is a fast, full-featured, full-text search index for Postgres

Opening excerpt

One of the Postgres features our customers ask us for the most is full-text search. Today, we are excited to announce TIN: a fast, full-featured, reliable full-text search extension for Postgres. TIN stands for “Text INdex,” and that is what it does.

TIN is available immediately as a GA release for all Postgres and Neki databases. Check it out:

CREATE INDEX an_index_name ON table_name USING tin(text_column_name); SELECT * FROM table_name WHERE text_column_name ==> ‘some words’ ; We built TIN because we believe a good text index should support:

A good text index in Postgres must support all of those things while also handling joins, complicated WHERE clauses across full-text and other column types, continuous updates, replication, backups, and correct transaction visibility.

(Excerpted from the original; full article via the source link below.)

This story hit the Hacker News front page today (160 points / 69 comments, via planetscale.com). Our Tech Radar aggregates daily signals on AI engineering, backend architecture and DevOps — browse the related services and further reading below, or get in touch with our team.