‹ 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. noir_lord · · focus · HN ↗
              &gt; You’re welcome.

              I didn&#x27;t say thank you and don&#x27;t presume I would, Planetscale acting in their own self interest by improving postgres upstream isn&#x27;t deserving of thanks, any more than Intel upstreaming a bunch of Linux kernel work is or myriad other examples.

              Corporations acting in their self interest isn&#x27;t worth giving thanks for, neither is the work of the people paid to do work on their behalf.

              I don&#x27;t expect my employer to thank me, I expect them to pay me, I don&#x27;t expect users of software I was paid to write to thank me because I did it for the money not out of altruism towards those users.

              1. zombodb · · focus · HN ↗
                It’s clear that we’re on opposite ends of open-source ideology.

                Good luck out there! 2026 is wild times!!

                1. noir_lord · · focus · HN ↗
                  You as well, and yes it&#x27;s very &quot;may you live in interesting times&quot; at the moment everywhere.
              2. ksec · · focus · HN ↗
                &gt;Planetscale acting in their own self interest by improving postgres upstream isn&#x27;t deserving of thanks,

                And that is in the context of

                &gt;Fully proprietary no issue with that,

                I guess I learned something new everyday.

            2. 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

            3. aarondf · · focus · HN ↗
              &gt; When one develops using open-source software they have an obligation to follow the licenses.

              Agreed!

              &gt; They also have a moral obligation to be respectful of the work upon which they’re building.

              Respectfully, completely disagree!

              Open source is a license, not a moral framework. Your only duty is to abide by the license. If you want to enforce that everything built on top of a particular open source package also be open source, that belongs in the license.

              1. zombodb · · focus · HN ↗
                &gt; Your only duty is to abide by the license.

                We live in a society. I don’t see any harm in believing we ought to be respectful of the work. That’s all I’m saying. You don’t have to be, but it’s a better world if you are.

                &gt; If you want to enforce that everything built on top of a particular open source package also be open source, that belongs in the license.

                Yes! I fully agree. The one that creates the thing is the one that gets to choose its license.

                Having opened-sourced some bit of work myself, that’s a very difficult decision.

Open on Hacker News to reply ↗

Unofficial Hacker News client; not affiliated with Y Combinator.