Tin: full-text search for Postgres

Posted by ksec 8 hours ago

Tin: full-text search for Postgres(planetscale.com)

156 points | 65 commentspage 2

downsplat 5 hours ago|

I suppose it all depends on the scale of your project, but I've had pretty good luck using both MySQL's and SQLite's FTS capabilities. Surprised to hear that Open Source champion Postgres didn't have up-to-snuff FTS up to now...?

dragonwriter 5 hours ago|

It has FTS built in and has had it for a VERY long time.

dorianmariecom 4 hours ago||

it does what it says on the TIN

adityapatadia 5 hours ago||

It’s just me or there are others who keep seeing these updates and think mongodb had all of this years ago?

Seriously so happy to be running our production stack on mongo.

stickfigure 5 hours ago||

Poe's Law strikes again.

groundzeros2015 5 hours ago||

Is this an ad? Postgres has had search for more than a decade.

dragonwriter 5 hours ago||

> Postgres has had search for more than a decade.

More than two decades (it moved to core from contrib in version 8.3 in 2008, but it was available in contrib since 7.4 in 2003.)

znpy 5 hours ago||

This was already posted and ignored at https://news.ycombinator.com/item?id=49751888 so i’ll ask the same question: again:

I don’t see any github link, is this 21st century embrace, extend, extinguish ?

rs_rs_rs_rs_rs 5 hours ago|

>is this 21st century embrace, extend, extinguish

I assume here you're talking about Amazon's modus operandi?

alexnewman 6 hours ago||

What’s funny is I worked with a company with planet in the name Who could really use a full text search that was great in the Postgres

sick_of_slop 6 hours ago|

What are the advantages of Tin over using ts_vector with gin and gist indexes?

dragonwriter 5 hours ago|

From the benchmarks deep in the document, TIN is much faster than built in text search (tested against GIN, which is itself much faster than GiST for text search.)