Tin: full-text search for Postgres

(planetscale.com)

30 points | by ksec 1 hour ago

2 comments

  • Tiberium 42 minutes ago
    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 33 minutes ago
      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 33 minutes ago
    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?