Tin: full-text search for Postgres

Tiberium an hour ago | parent | next [-]

If anyone's curious - https://planetscale.com/docs/postgres/search/get-started#loc...:

They're not providing a local extension with the same performance at the time - it's only offered on their cloud services.

The local version https://github.com/planetscale/lead is mainly just for testing the syntax, it doesn't have the same perf characteristics.

	▲	noir_lord an hour ago \| parent [-]
		Becoming more the norm for them, Neki is the same. Immediately rules out ever using them (though I don't currently have any problems that would benefit from that level of scale currently, have in the past though). Postgres's license allows this but for me (personally) it leaves a bad taste.

▲

bob1029 an hour ago | parent | prev [-]

I struggle with FTS inside SQL (SQLite and MSSQL). There is often a fairly significant impedance mismatch between the relational concerns and how the documents need to be stored.

I've always preferred to use SQL as the system of record and then build/maintain an external Lucene index. Do we think these integral FTS capabilities are at the point where a hybrid architecture doesn't make sense anymore? How much customization exists in this provider?