SDF Chatter
  • Communities
  • Create Post
  • Create Community
  • heart
    Support Lemmy
  • search
    Search
  • Login
  • Sign Up
Aijan@programming.dev to Programming@programming.dev · 6 months ago

Writing Composable SQL using Knex and Pipelines

lackofimagination.org

external-link
message-square
7
fedilink
22
external-link

Writing Composable SQL using Knex and Pipelines

lackofimagination.org

Aijan@programming.dev to Programming@programming.dev · 6 months ago
message-square
7
fedilink
Despite all its strengths, SQL can be awkward to integrate with host languages such as JavaScript and Python. There’s often an impedance mismatch between SQL’s declarative nature and the host language’s object-oriented or functional paradigms – SQL queries are typically written as strings within the host language, making it difficult to apply composable programming techniques…
alert-triangle
You must log in or register to comment.
  • vext01
    link
    fedilink
    arrow-up
    10
    ·
    6 months ago

    Got excited when I read “knex”, but it wasn’t what I thought… not the amazing construction set I had as a kid.

    • MonkderVierte@lemmy.ml
      link
      fedilink
      arrow-up
      2
      ·
      6 months ago

      It still exists.

  • MonkderVierte@lemmy.ml
    link
    fedilink
    arrow-up
    9
    ·
    6 months ago

    Knex pipelines:

  • abbadon420@lemm.ee
    link
    fedilink
    arrow-up
    4
    ·
    6 months ago

    Serious question, what’s the problem with hibernate?

    • Aijan@programming.devOP
      link
      fedilink
      arrow-up
      4
      ·
      6 months ago

      I think this page explains it well: https://en.wikipedia.org/wiki/Object–relational_impedance_mismatch

      • MajorHavoc@programming.dev
        link
        fedilink
        arrow-up
        2
        ·
        edit-2
        6 months ago

        That’s a great write-up. Thank you.

    • SandLight@lemmy.world
      link
      fedilink
      English
      arrow-up
      4
      ·
      6 months ago

      Half the time I wish I was raw dogging sql and object mappers. Hibernate can be so annoying to set up right with complicated relations.

Programming@programming.dev

programming@programming.dev

Subscribe from Remote Instance

Create a post
You are not logged in. However you can subscribe from another Fediverse account, for example Lemmy or Mastodon. To do this, paste the following into the search field of your instance: !programming@programming.dev

Welcome to the main community in programming.dev! Feel free to post anything relating to programming here!

Cross posting is strongly encouraged in the instance. If you feel your post or another person’s post makes sense in another community cross post into it.

Hope you enjoy the instance!

Rules

Rules

  • Follow the programming.dev instance rules
  • Keep content related to programming in some way
  • If you’re posting long videos try to add in some form of tldr for those who don’t want to watch videos

Wormhole

Follow the wormhole through a path of communities !webdev@programming.dev



Visibility: Public
globe

This community can be federated to other instances and be posted/commented in by their users.

  • 37 users / day
  • 556 users / week
  • 3.18K users / month
  • 7.5K users / 6 months
  • 312 local subscribers
  • 20.6K subscribers
  • 2.27K Posts
  • 35.4K Comments
  • Modlog
  • mods:
  • snowe@programming.dev
    cake
  • Ategon@programming.dev
  • MaungaHikoi@lemmy.nz
  • UlrikHD@programming.dev
  • BE: 0.19.8
  • Modlog
  • Instances
  • Docs
  • Code
  • join-lemmy.org