Blog: jooq (Lukas Eder)

200 blogs updated: 76 min. ago
Prevent SQL Injection with SQL Builders Like jOOQ
As long as we allow ourselves to write string-based dynamic SQL embedded in other programming languages like Java, we will have a certain ri...
05-12-2016 11:28:49 jooq (Lukas Eder) Advanced
The Java Ecosystem's Obsession with NonNull Annotations
I'm not well known for my love of annotations. While I do recognise that they can serve a very limited purpose in some areas (e.g. hinting s...
24-11-2016 11:30:34 jooq (Lukas Eder) Advanced
Use jOOQ to Read / Write Oracle PL/SQL RECORD Types
Some of the biggest limitations when working with Oracle PL/SQL from Java is the lack of support for a variety of PL/SQL features through th...
08-11-2016 15:29:05 jooq (Lukas Eder) Advanced
Applying Queueing Theory to Dynamic Connection Pool Sizing with FlexyPool
I'm very happy to have another interesting blog post by Vlad Mihalcea on the jOOQ blog, this time about his Open Source library flexypool. R...
02-11-2016 12:25:30 jooq (Lukas Eder) Advanced
Why You Should (Sometimes) Avoid Expressions in SQL Predicates
I've recently discovered a rather significant performance issue on a productive Oracle 11g customer database. And I'm sure you have this iss...
01-11-2016 13:08:20 jooq (Lukas Eder) Advanced
A Little Known SQL Feature: Use Logical Windowing to Aggregate Sliding Ranges
I'm frequently telling developers to put window functions almost everywhere, because they're so awesome! One feature that I rarely see in th...
31-10-2016 11:16:26 jooq (Lukas Eder) Advanced
Don't Even use COUNT(*) For Primary Key Existence Checks
In a recent blog post, I've advocated against the use of COUNT(*) in SQL, when a simple EXISTS() would suffice. This is important stuff. I k...
28-10-2016 11:19:30 jooq (Lukas Eder) Advanced
How to Quickly Rename all Primary Keys in Oracle
Are you working with someone else's schema and they haven't declared nice names for all their constraints? Unfortunately, it is all too easy...
21-10-2016 10:40:25 jooq (Lukas Eder) Advanced
Be Careful When Emulating Parameterised Views with SYS_CONTEXT in Oracle
Everyone who writes complex SQL (or dare I say, move business logic into the database?) wishes for parameterised views from time to time. Th...
20-10-2016 12:26:37 jooq (Lukas Eder) Advanced
jOOQ Tuesdays: Daniel Dietrich Explains the Benefits of Object-Functional Programming
Welcome to the jOOQ Tuesdays series. In this series, we'll publish an article on the third Tuesday every other month where we interview some...
18-10-2016 14:15:04 jooq (Lukas Eder) Advanced

© Jiri Pinkas | this project on GitHub | related: JavaVids | Maven Central Repository Search | Java školení | Top SQL Blogs | monitored using: sitemonitoring

Top Java Blogs is a Java blog aggregator (with English-written blogs only) focused on Java SE, Java EE, Spring Framework and Hibernate.