days
-3
0
hours
-2
-2
minutes
-3
-9
seconds
0
-8

#sql

JAXenter Masterclass special

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

Have you heard of our Masterclass workshops? Here is a Masterclass special from your SQL trainer, 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.

JAXenter Masterclass special

How to group by “nothing” in SQL

Have you heard of our Masterclass workshops? Here is a Masterclass special from your SQL trainer, 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!