‹ BackHN Continuity

Thread

Tin: full-text search for Postgres

230 points · 98 comments · ksec

  1. Tiberium · · focus · HN ↗
    If anyone&#x27;s curious - <a href="https:&#x2F;&#x2F;planetscale.com&#x2F;docs&#x2F;postgres&#x2F;search&#x2F;get-started#local-development-and-ci" rel="nofollow">https:&#x2F;&#x2F;planetscale.com&#x2F;docs&#x2F;postgres&#x2F;search&#x2F;get-started#loc...:

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

    The local version <a href="https:&#x2F;&#x2F;github.com&#x2F;planetscale&#x2F;lead" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;planetscale&#x2F;lead is mainly just for testing the syntax, it doesn&#x27;t have the same perf characteristics.

    1. noir_lord · · focus · HN ↗
      Becoming more the norm for them, Neki is the same.

      Immediately rules out ever using them (though I don&#x27;t currently have any problems that would benefit from that level of scale currently, have in the past though).

      Postgres&#x27;s license allows this but for me (personally) it leaves a bad taste.

      Also it&#x27;s not really &quot;full-text search for Postgres&quot; it&#x27;s &quot;full-text search for our hosted version of Postgres&quot; so the title is a little misleading.

      1. zombodb · · focus · HN ↗
        Why don’t you like Postgres’ license? It’s as permissive as a license gets.
        1. noir_lord · · focus · HN ↗
          Building non-open extensions on top of it, it&#x27;s not the license I don&#x27;t like, the bad taste is that they use something open extend it and keep part of it closed.

          The license allows it but on the flip side it&#x27;s vendor lock-in predicated on using something open as the base.

          Fully proprietary no issue with that, full open, no issue with that, building proprietary on top of open is where the bad taste comes in.

          For completeness, it&#x27;s not them specifically either, the other cloud companies do similar things and I suspect in part the reason they don&#x27;t open these extensions up is because the others will but then they are doing the same thing themselves.

          1. zombodb · · focus · HN ↗
            When one develops using open-source software they have an obligation to follow the licenses. They also have a moral obligation to be respectful of the work upon which they’re building. And they have a social obligation to help improve that software where they can.

            Those that develop on top of open-source have no obligation to give you their work for free.

            You’d be surprised as to the amount of open-source contributions TIN drove towards Postgres, LLVM, and pgrx. And you’d be speechless at the amount of upstream work across all sorts of open-source PlanetScale does. Postgres 18.6, for example, is better for you today, in part, because of TIN. You’re welcome.

            1. xyzzy_plugh · · focus · HN ↗
              Everything else aside

              &gt; Those that develop on top of open-source have no obligation to give you their work for free.

              This is a pretty narrow view of open source.

              Just as a simple example, GPLv3 and AGPLv3 are both considered Open Source and, depending on how you hold them, may obligate releasing work to customers essentially for free.

              1. zombodb · · focus · HN ↗
                I thought I was clear:

                &gt; When one develops using open-source software they have an obligation to follow the licenses.

                Obviously what follows from one of those licenses is what you say.

                I’m glad we agree!

              2. jamienk · · focus · HN ↗
                &quot;...are both considered Open Source&quot; &lt;&lt; Free Software (GPL) is the O.G. - it&#x27;s like saying &quot;George Washington is considered to be an American President&quot; or &quot;The Beatles are considered to be a pop&#x2F;rock band&quot; or &quot;water is considered to be...&quot;

                I remember so well when &quot;Open Source&quot; branding started with Bruce Perens - all the business arguments. When you need a database, someone ELSE&#x27;S business decisions (how THEY are going to make money) never end up helping YOU. If you use proprietary extensions and become dependent on them, you inevitably will get BURNED when their business needs diverge from your needs. - They close shop - They refuse to interop with something you need - They demand that you obey their arcane rules - They rug-pull - They get hacked as only they can - They lie to you - They stab you in the back

Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.