جستجو | Virtuala

جستجو

وبلاگ ها

گروه‌ها

رویدادها

Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·1K بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!
Luka Matijević @luka وبلاگ اضافه شد in 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 نظرات ·0 اشتراک‌گذاری‌ها ·992 بازدیدها

لطفا برای لایک، اشتراک گذاری و کامنت وارد شوید!

نتایج بیشتر

حمایت‌شده

Virtuala https://virtuala.site