Hledat | Virtuala FansOnly

Luka Matijević added blog Coding
2025-05-31 20:25:36 -

A Hidden Benefit of Implicit Joins: Join Elimination
Implicit path joins may now skip unnecessary tables in the join tree One of jOOQ’s key features so far has always been to render pretty much exactly the SQL that users expect, without any surprises – unless some emulation is required to make a query work, of course. This means that while join elimination is a powerful feature of many RDBMS, it isn’t part of jOOQ’s feature set, so far....

0 Komentáře 0 Sdílení 262 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:21:44 -

A Reader’s Question on Nested Lists
A Reader's Question on Nested Lists | CSS-Tricks A couple of days back, among the tens of crypto-scams that flood our contact inbox, we found an interesting question on nested lists from one of our readers. I have a problem (related to list-numbering) that seems commonplace, but I can’t seem to solve it or find any solution for. If any of your geniuses can answer...

0 Komentáře 0 Sdílení 248 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:25:35 -

An Efficient Way to Check for Existence of Multiple Values in SQL
What's faster, COUNT(*) or COUNT(*) with LIMIT in SQL? Let's check In a previous blog post, we’ve advertised the use of SQL EXISTS rather than COUNT(*) to check for existence of a value in SQL. I.e. to check if in the Sakila database, actors called WAHLBERG have played in any films, instead of: SELECT count(*) FROM actor a JOIN film_actor fa USING (actor_id) WHERE a.last_name =...

0 Komentáře 0 Sdílení 263 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:21:42 -

Better CSS Shapes Using shape() — Part 1: Lines and Arcs
Better CSS Shapes Using shape() — Part 1: Lines and Arcs | CSS-Tricks Creating CSS Shapes is a classic and one of my favorite exercise. Indeed, I have one of the biggest collections of CSS Shapes from where you can easily copy the code of any shape. I also wrote an extensive guide on how to create them: The Modern Guide For Making CSS Shapes. Even if I have detailed...

0 Komentáře 0 Sdílení 224 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:21:41 -

Better CSS Shapes Using shape() — Part 2: More on Arcs
Better CSS Shapes Using shape() — Part 2: More on Arcs | CSS-Tricks Ready for the second part? We are still exploring the shape() function, and more precisely, the arc command. I hope you took the time to digest the first part because we will jump straight into creating more shapes! As a reminder, the shape() function is only supported in Chrome 137+ and Safari 18.4+...

0 Komentáře 0 Sdílení 237 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:25:33 -

Emulating SQL FILTER with Oracle JSON Aggregate Functions
How to implement FILTER semantics with Oracle JSON aggregate functions A cool standard SQL:2003 feature is the aggregate FILTER clause, which is supported natively by at least these RDBMS: ClickHouse CockroachDB DuckDB Firebird H2 HSQLDB PostgreSQL SQLite Trino YugabyteDB The following aggregate function computes the number of rows per group which satifsy...

0 Komentáře 0 Sdílení 263 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:25:34 -

Getting Top 1 Values Per Group in Oracle
Oracle's way to get multiple values in a top 1 per group query I’ve blogged about generic ways of getting top 1 or top n per category queries before on this blog. An Oracle specific version in that post used the arcane KEEP syntax: SELECT max(actor_id) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id), max(first_name) KEEP (DENSE_RANK FIRST ORDER BY c DESC, actor_id),...

0 Komentáře 0 Sdílení 282 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:21:45 -

HTML Email Accessibility Report 2025
HTML Email Accessibility Report 2025 | CSS-Tricks Some weekend reading on the heels of Global Accessibility Awareness Day (GAADM), which took place yesterday. The Email Markup Consortium (EMC) released its 2025 study on the accessibility in HTML emails, and the TL;DR is not totally dissimilar from what we heard from WebAIM’s annual web report: This is the third full...

1

0 Komentáře 0 Sdílení 278 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:25:37 -

jOOQ 3.19’s new Explicit and Implicit to-many path joins
jOOQ 3.19 offers many new and useful path based join features jOOQ 3.19 finally delivers on a set of features that will greatly simplify your queries further, after jOOQ 3.11 introduced implicit to-one joins: Explicit path joins To-many path joins Implicit join path correlation What are these features? Many ORMs (e.g. JPA, Doctrine, jOOQ 3.11 and others) support “path joins”...

0 Komentáře 0 Sdílení 283 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:25:32 -

jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more
jOOQ 3.20 released with ClickHouse, Databricks, and much more DuckDB support, new modules, Oracle type hierarchies, more spatial support, decfloat and synonym support, hidden columns, Scala 3, Kotlin 2, and much more New dialects: jOOQ 3.20 ships with 2 new experimental dialects: ClickHouse in all editions, including the jOOQ Open Source Edition Databricks in the jOOQ Enterprise...

0 Komentáře 0 Sdílení 293 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:25:32 -

Resisting the Urge to Document Everything Everywhere
Why I don't document quirks of a feature on the feature itself. Every product manager knows this situation: A user works with feature X1. They find a limitation / bug / quirk and want to work around it. The perfect workaround or alternative is feature X2, but without knowing that X2 exists, the user doesn’t find it and spends a lot of time looking for it. The user requests X2 be...

0 Komentáře 0 Sdílení 300 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!
Luka Matijević added blog Coding
2025-05-31 20:21:45 -

Scroll-Driven Animations Inside a CSS Carousel
Scroll-Driven Animations Inside a CSS Carousel | CSS-Tricks I was reflecting on what I learned about CSS Carousels recently. There’s a lot they can do right out of the box (and some things they don’t) once you define a scroll container and hide the overflow. Hey, isn’t there another fairly new CSS feature that works with scroll regions? Oh yes, that’s Scroll-Driven...

0 Komentáře 0 Sdílení 250 Zobrazení 0 Hodnocení

Prosím, přihlaste se, aby se vám líbilo, sdílejte a komentujte!

Další výsledky