Channels

Public threads, grouped by where they are happening. Pick a place to read its topics.

sql

Filed under this by 32 pieces from 2 sources · the whole ledger

  1. Simplifying ANTI JOIN with jOOQ Syntaxjooq.orgstory
  2. Why JOIN USING Can Lead to Errors in SQLjooq.orgstory
  3. You’ve got 99 problems but data shouldn’t be onesimplecast.comaudio
  4. When SQL Meets Lambda Expressionsjooq.orgstory
  5. Think About SQL MERGE in Terms of a RIGHT JOINjooq.orgstory
  6. Emulating SQL FILTER with Oracle JSON Aggregate Functionsjooq.orgstory
  7. Supporting the world’s most-used database engine through 2050simplecast.comaudio
  8. Getting Top 1 Values Per Group in Oraclejooq.orgstory
  9. An Efficient Way to Check for Existence of Multiple Values in SQLjooq.orgstory
  10. A Hidden Benefit of Implicit Joins: Join Eliminationjooq.orgstory
  11. jOOQ 3.19’s new Explicit and Implicit to-many path joinsjooq.orgstory
  12. Workaround for MySQL’s “can’t specify target table for update in FROM clause” Errorjooq.orgstory
  13. Maven Coordinates of the most popular JDBC Driversjooq.orgstory
  14. JDBC Connection URLs of the Most Popular RDBMSjooq.orgstory
  15. How to write high-performance SQL for your Postgres databasesimplecast.comaudio
  16. How to Turn a List of Flat Elements into a Hierarchy in Java, SQL, or jOOQjooq.orgstory
  17. How to Write a Derived Table in jOOQjooq.orgstory
  18. The Performance Impact of SQL’s FILTER Clausejooq.orgstory
  19. Emulating Window Functions in MySQL 5.7jooq.orgstory
  20. When to Use jOOQ and When to Use Native SQLjooq.orgstory
  21. LATERAL is Your Friend to Create Local Column Variables in SQLjooq.orgstory
  22. How to Plot an ASCII Bar Chart with SQLjooq.orgstory
  23. A Condition is a Fieldjooq.orgstory
  24. The Many Ways to Return Data From SQL DMLjooq.orgstory
  25. Using H2 as a Test Database Product with jOOQjooq.orgstory
  26. Create Dynamic Views with jOOQ 3.17’s new Virtual Client Side Computed Columnsjooq.orgstory
  27. How to Filter a SQL Nested Collection by a Valuejooq.orgstory
  28. The Performance of Various To-Many Nesting Algorithmsjooq.orgstory
  29. Changing SELECT .. FROM Into FROM .. SELECT Does Not “Fix” SQLjooq.orgstory
  30. The Many Different Ways to Fetch Data in jOOQjooq.orgstory
  31. Setting the JDBC Statement.setFetchSize() to 1 for Single Row Queriesjooq.orgstory
  32. How to Typesafely Map a Nested SQL Collection into a Nested Java Map with jOOQjooq.orgstory

A topic here is a label each publisher printed on its own piece. Equal labels from different publishers are shown together; that does not make them one subject.

Keep going

Each of these is read from what this estate already kept: the feed a piece came through, the publisher behind it, the credits and topics the publisher printed. None of it is a recommendation, an identity or a record kept anywhere else.

Where this comes from

Solid branches are exact SourceFrontier census edges used by this page. Folded branches share the publisher but did not supply these items.

Hacker News

1 feed · 1 available · hn.algolia.com

text1 channel · 1 available
  1. Used here by hn-new hacker-attention Hacker News
    used on this pagehacker-attention

Latest

High performance policy routed IPsec mesh SD-WANlobste.rs High performance policy routed IPsec mesh SD-WANysun lobste.rs A New Way to Think About Borrow Checking (In Reverse)lobste.rs A New Way to Think About Borrow Checking (In Reverse)Verdagon lobste.rs ARP! Tell your network to explain itselflobste.rs ARP! Tell your network to explain itselfbenj lobste.rs Algorithmic Sound Design with L-Systems and Granular Synthesischrisl lobste.rs It's enough - vibecoding tag crossed from useless to harmfulThe vibecoding tag has been getting more and more useless for a while now. It lost the original meaning as the culture of software engineering with LLMs matured a bit. It got silly when posts talking about LLMs in general got tagged. It got useless when posts even mentioning some project created with LLMs in passing got tagged. Now it actually got harmful to the community when tagging posts turns away very valuable members https://lobste.rs/c/vecuxj I sighed and moved on for a while now as almost everything gets tagged - you can skip a word. But now it not only carries no signal whatsoever, it turns away people creating original technical content - which is what I assume anti-vibecoding people would actually like to see more of. Please split it or kill it. But we'd be better off without what exists today. Added: To be clear, I totally support people filtering out llm-generated or llm-centric posts. But right now everyone loses. And every day we lose a little bit more. Whether it's an original, interesting arviraptor lobste.rs Un-hanging the HP Envy 17-DA0013dx for OpenBSDzk lobste.rs Making Hybrid Images (2014)zk lobste.rs