Blog: jooq (Lukas Eder)

202 blogs updated: 60 min. ago
jOOQ Tuesdays: Brett Wooldridge Shows What it Takes to Write the Fastest Java Connection Pool
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...
21-02-2017 13:40:21 jooq (Lukas Eder) Advanced
Should I Implement the Arcane Iterator.remove() Method? Yes You (Probably) Should
An interesting question was asked on reddit's /r/java recently: Should Iterators be used to modify a custom Collection? Paraphrasing the que...
17-02-2017 12:30:31 jooq (Lukas Eder) Advanced
Beautiful SQL: Lateral Unnesting of Array Columns
Sometimes, SQL can just be so beautiful. One of the less mainstream features in SQL is the array type (or nested collections). In fact, it's...
10-02-2017 14:51:41 jooq (Lukas Eder) Advanced
How to Fetch Oracle 12c Implicit Cursors with JDBC and jOOQ
Earlier this week, I've blogged about how to execute SQL batches with JDBC and jOOQ. This was useful for the MySQL, SQL Server, and Sybase u...
08-02-2017 15:42:36 jooq (Lukas Eder) Advanced
How to Execute SQL Batches With JDBC and jOOQ
Some databases (in particular MySQL and T-SQL databases like SQL Server and Sybase) support a very nice feature: They allow for running a "b...
06-02-2017 14:58:12 jooq (Lukas Eder) Advanced
How to Emulate Partial Indexes in Oracle
A very interesting feature of the SQL Server and PostgreSQL databases (and some others, including SQLite) is the partial index (sometimes al...
18-01-2017 14:20:39 jooq (Lukas Eder) Advanced
A Functional Programming Approach to Dynamic SQL with jOOQ
Typesafe embedded DSLs like jOOQ are extremely powerful for dynamic SQL, because the query you're constructing with the jOOQ DSL is a dynami...
16-01-2017 15:01:30 jooq (Lukas Eder) Advanced
A Probably Incomplete, Comprehensive Guide to the Many Different Ways to JOIN Tables in SQL
Perhaps the most powerful SQL feature is the JOIN operation. It is the envy of all non-relational databases, because the concept is so simpl...
12-01-2017 13:31:48 jooq (Lukas Eder) Advanced
jOOQ 3.10 will Support SQL Server's Table Valued Parameters
SQL Server has this nice feature called table-valued parameters (TVP), where users can pass table variables to a stored procedure for bulk d...
10-01-2017 13:19:13 jooq (Lukas Eder) Advanced
How to Write a Quick and Dirty Converter in jOOQ
One of jOOQ s most powerful features is the capability of introducing custom data types, pretending the database actually understands them. ...
06-01-2017 12:29:32 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.