Название: Beginning jOOQ: Learn to Write Efficient and Effective Java-Based SQL Database Operations
Автор: Tayo Koleoso
Издательство: Apress
Год: 2022
Страниц: 221
Язык: английский
Формат: pdf (true), epub
Размер: 19.2 MB

Practical examples and case studies demonstrate how jOOQ offers a more efficient and versatile alternative to Object-Relational Mapping frameworks like Hibernate and JPA, while providing a natural, native-SQL feeling for the developer. You'll see how to maximize the full potential of your SQL database with advanced query syntax and functions with this lightweight, SQL-friendly framework. Come see how you can use high performance approaches like reactive, data streaming and cloud-native programming to get data from SQL tables.

That tall drink of SQL? Probably me; I don’t know. The point is I deeply appreciate Structured Query Language (SQL) and all it has to offer. The industry’s been going gaga about NoSQL because it’s “easy to use” and it “scales quickly,” but the fact of the matter is that SQL is still the undisputed king of Online Analytical Processing (OLAP). When you want sanity and integrity in your data, SQL is there. When you want (most of2) the guarantees of reliable transaction handling (à la ACID), you’re still going to need solid SQL in your stack. Not for nothing, database stored procedures will typically outperform application-layer (e.g., Java, .Net) processing in many cases. In the words of the late, great Thanos: “SQL is inevitable. It’s in the interests of your application’s scalability and correctness to get it right.”

Unfortunately, SQL gets very short shrift from devs nowadays. The database is just another “black box” that we’re supposed to yell commands at, so it yields some data and then we move on. It’s not until our queries progressively degrade due to preventable problems; our schema is an incoherent mess after two versions of our applications; SQL injection attacks expose our weaknesses; the application chokes on queries returning more than a few hundred rows. One of the dark sides of SQL is that you’re not likely to realize that your SQL query is returning incorrect or incomplete data at first glance. You ran a query, it returned some queries, and that’s that, right? Yikes.

This book isn’t about the fundamentals of SQL. Or even the joys of SQL per se (there are many). This book is about taking a different look at handling SQL work in Java.