days
0
-7
hours
0
-6
minutes
-4
-8
seconds
0
-7
search

#sql

SQL Special

Find the next non-NULL row in a series with SQL

Here is another SQL special from jOOQ inventor Lukas Eder. Looking at a time series of data points where certain events happen, there are several issues that can occur. Here’s how you can deal with those problems.

SQL Special

How to group by “nothing” in SQL

Here is another SQL special from jOOQ inventor Lukas Eder. What’s the point in using GROUPING SETS in SQL standard? Eder demonstrates a pretty subtle effect of using this feature.

An absolute delight

SQLDelight 1.0 arrives with a complete rework

SQLDelight, a library that generates typesafe APIs from your SQL statements, just reached its 1.0 milestone, which happens to bring a complete rework. Let’s have a closer look at what this library has to offer.

Why are they great?

ETL Tools vs. SQL and system tools

Built-in tools have some serious advantages, like easier maintenance, fewer bugs, less dependency on the database in use, easier to migrate to another server, etc. But when it comes to performance it is far from the best. What if you wanted to make our ETL even better? Veselin Davidov gives us a full tour!