Rethinking Database Programming

 (acadia.engineering)

61 points | by honungsburk 3 hours ago

9 comments

  • pelagicAustral 1 hour ago
    So this is capable of turning a one-liner of SQL into six lines of barely readable code?
    [-]
    • janderland 0 minutes ago
      SQL is a horrible language. I’d gladly program in something composable like Elm.
    • fwlr 3 minutes ago
      It seems that is the price you pay for the power to turn a 600-line nightmare SQL query into 60 lines of barely readable code.
  • raumgeist 48 minutes ago
    Looks very nice. Last year I took up rust, coming from c++, and some of the modern features rust brings are just so nice to have (even something as simple as not having to forward declare a class).

    This year I started working with postgres and you just can't help but notice how sql is coming from the c-Era of programming. Having better and more modern ways to express my queries would be great to improve correctness and performance.

  • mjaniczek 38 minutes ago
    Having reusable functions and pipelines compiling to SQL sounds amazing. (EDIT: and sum types!) Will want to try this out on some side project later.

    Although for my Elm + backend needs I feel like I still prefer Lamdera: https://dashboard.lamdera.app/ - WebSocket communication and being able to push new data to clients immediately instead of juggling HTTP endpoints and the client having to pull/refresh. `sendToBackend`, `sendToFrontend`, `broadcast` are a great primitive.

  • nylonstrung 44 minutes ago
    For columnar databases, I love Vortex' Dtypes which lets you attach semantic context in a logical type to what is essentially compressed Arrow https://docs.vortex.dev/concepts/dtypes#logical-types
  • DarkNova6 50 minutes ago
    I was hoping for an alternative to PLSQL or stored procedures. But this isn’t about „Database Programming“, it’s a SQL replacement…
  • honungsburk 3 hours ago
    New functional query language for PostgreSQL and SQLite by Evan Czaplicki the author of Elm
  • ArtemKhymenko 1 hour ago
    Pretty nice, thanks
  • somelady 1 hour ago
    Exciting news!! Love Elm, can't wait to use it more
  • DarkNova6 1 hour ago
    It looks like the HN hug of death has found a new victim
    [-]