SQL
-
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 » -
Software Development
jOOQ Tuesdays: Markus Winand is on a Modern SQL Mission
Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month…
Read More » -
Software Development
The 10 Most Popular DB Engines (SQL and NoSQL) in 2015
About two years ago, we’ve published this post about the 10 most popular DB engines, where we analyzed the data…
Read More » -
Software Development
You Probably don’t Use SQL INTERSECT or EXCEPT Often Enough
When people talk about SQL JOIN, they often use Venn Diagrams to illustrate inclusion and exclusion of the two joined…
Read More » -
Software Development
Don’t Format Dates in SQL. Use the DATE Literal!
I’m seeing people do this all the time. They want to hammer a date or timestamp constant into their SQL…
Read More » -
Software Development
Passing Arrays to a PostgreSQL PL/pgSQL Function
It can be handy to pass a collection of strings to a PL/pgSQL stored function via a PostgreSQL array. This…
Read More » -
Software Development
There is no Such Thing as Object-Relational Impedance Mismatch
Much of the ORM criticism of the last decade missed the point, being inaccurate. By the end of this article,…
Read More » -
Software Development
Divided we Stand: Optional
Our recent article “NULL is Not The Billion Dollar Mistake. A Counter-Rant” got us a lot of reads, controversial comments,…
Read More »