The SQL language is very intuitive. Until it isn't. Over the years, a lot of people have criticised the SQL language for a variety of reasons. For instance: IDEs cannot easily guess what auto completion options to offer, because as long as you don't specify the FROM clause, there are no tables in scope (yet): … Continue reading A Beginner’s Guide to the True Order of SQL Operations
Tag: Operations
How to Know if a Given Index Can be Dropped
It seems that perfection is attained not when there is nothing more to add, but when there is nothing more to remove. - Antoine de Saint Exupéry in Terre des Hommes As SQL developers, we keep adding more and more indexes to our tables. Every time we run new queries that are potentially slow, a … Continue reading How to Know if a Given Index Can be Dropped
jOOQ Tuesdays: Axel Fontaine Predicts Exciting Times as our Industry is Maturing
Welcome to the jOOQ Tuesdays series. In this series, we’ll publish an article on the third Tuesday every other month where we interview someone we find exciting in our industry from a jOOQ perspective. This includes people who work with SQL, Java, Open Source, and a variety of other related topics. We have the pleasure … Continue reading jOOQ Tuesdays: Axel Fontaine Predicts Exciting Times as our Industry is Maturing