SQL
-
Software Development
How to Detect Slow Queries with jOOQ
Just now, we implemented a nice little feature in jOOQ’s code generator: https://github.com/jOOQ/jOOQ/issues/4974 It detects whenever the jOOQ code generator…
Read More » -
Software Development
Impress Your Coworkers by Using SQL UNPIVOT!
I’ve recently encountered a very interesting question on Stack Overflow by an unnamed user. The question was about generating a…
Read More » -
Software Development
Oracle LONG and LONG RAW Causing “Stream has already been closed” Exception
Like many old databases, Oracle has legacy data types, which are rather nasty to work with in every day SQL.…
Read More » -
Software Development
How to Fill Sparse Data With the Previous Non-Empty Value in SQL
The following is a very common problem in all data related technologies and we’re going to look into two very…
Read More » -
Software Development
SQL GROUP BY and Functional Dependencies: A Very Useful Feature
Relational databases define the term “Functional Dependency” as such (from Wikipedia): In relational database theory, a functional dependency is a…
Read More » -
Software Development
How to Find the Longest Consecutive Series of Events in SQL
A very interesting problem that can be solved very easily with SQL is to find consecutive series of events in…
Read More » -
Software Development
NoSQL vs. SQL: Choosing a Data Management Solution
Table Of Contents 1. Introduction 2. Distributed systems: the CAP theorem 3. Relational data stores 3.1. MySQL / MariaDB 3.2.…
Read More » -
Software Development
How to Find the Closest Subset Sum with SQL
I’ve stumbled upon this very interesting question on Stack Overflow, recently. Its title is: [How to] compare a number with…
Read More » -
Software Development
Leveraging new features in Drill 1.2 – ANSI SQL Analytic/Window functions
Today we are very excited to announce the latest version of Apache Drill, 1.2,) as part of the MapR distribution.…
Read More »