Episode 465: Kevlin Henney and Trisha Gee on 97 Things Every Java Programmer Should Know

SQL Thinking

The concept of SQL thinking in Java encourages developers to adopt a declarative approach to data handling, moving away from traditional control flow methods. Kevlin Henney explains that SQL thinking involves framing questions about data in terms of selection criteria rather than loops, which can lead to clearer and more efficient code 1. This approach helps developers focus on the intention behind their code, enhancing their relationship with data collections.

As a developer, you have written all the loops you will ever need to write.

--- Kevlin Henney

By recognizing the logic programming aspects of SQL, developers can apply similar strategies in Java, leading to improved clarity and functionality 1.

   

Java Streams

Java Streams, introduced in Java 8, offer a powerful way to manipulate data collections using a SQL-inspired approach. Trisha Gee highlights how streams allow developers to filter, sort, and process data without explicitly iterating over collections, similar to SQL queries 2. This shift in thinking requires developers to specify what they want from the data, rather than how to retrieve it.

Instead of iterating over and pulling stuff out of our collections, we could say for every one of, well, actually the worst one is for everyone do this thing.

--- Trisha Gee

The introduction of streams, alongside lambdas, enriches Java's capabilities, enabling more concise and expressive code 2.