PostgreSQL Extensions in Go

(jespino.github.io)

109 points | by valyala 6 hours ago

9 comments

  • 3eb7988a1663 5 hours ago
    The Go community sold me on the necessity of programming mascots. The gopher is adorable, and I love seeing the creative tweaks for how people incorporate it into their marketing.

    Ferris the crab also seems like it has been around since the early days, but I do not see nearly as many projects with crab heavy media. Guess it also has to be a mammal.

    • noir_lord 9 minutes ago
      PHP has the elephants, lots and lots of different elephants.

      https://afieldguidetoelephpants.net/#variations

      I think they are cute as well but despite programming PHP (among other things) for decades, never had an elephant though I know a bunch of PHP devs who have dozens (or more).

    • alexpadula 16 minutes ago
      The mascot is indeed cute af!
  • QGQBGdeZREunxLe 3 hours ago
    From the same author: https://jespino.github.io/gokm/ (Linux kernel modules in Go)
  • Wicher 4 hours ago
  • Icathian 2 hours ago
    Okay now this is cool. Anything to make postgres extensions nice and easy to write.

    Still gonna go with pgrx though.

  • ltbarcly3 4 hours ago
    LLMs make "I need to shoehorn a language I already know well into an environment where it doesn't really belong" an unnecessary extravagance.

    Just have an AI write plpgsql. If what you are doing is too complicated for plpgsql you are doing something stupid.

    • tehlike 2 hours ago
      PLV8 is amazing. plpgsql is overly verbose. It's also now possible to write modules in rust. They are all great.
    • sgarland 1 hour ago
      Depends what the extension is doing; C (or Rust) is much faster for CPU-heavy operations than PL/PgSQL.
    • cannonpalms 1 hour ago
      What about the full storage engine extensions, like ClickHouse, Timescale, etc.?
    • dapperdrake 2 hours ago
      Then you will love plv8.

      Load an entire Chrome V8 or NodeJS V8 into Postgres to have JS pg modules.

      JS now runs on phones, on web servers, and inside your postgres relational database. Add Mongo and vibe code JS for redis or memcached for bonus internet points.

      If Rust is rewritten in JS, then Bun can finally return to its roots.

      https://github.com/plv8/plv8

      END half satire (plv8 is real, though)

      • jerrysievert 1 hour ago
        Give pljs a chance, fast startup, very fast execution, and a lot lighter weight than plv8.
  • angrydingo 4 hours ago
    for code snippets on darkmode i can't see bracket
    • jttnr 3 hours ago
      [flagged]
  • Kinrany 2 hours ago
    Now that reimplementing old ideas is a commodity, can't we have a new database without carrying the historical baggage and bad decisions of old?
    • alexpadula 17 minutes ago
      Turborel, check it out.
    • gjvc 2 hours ago
      which particular historical baggage and bad decisions of old were you thinking of here?
    • pigeonhole123 2 hours ago
      pgrust seems promising
  • collabspherestu 3 hours ago
    [flagged]