jOOQ Loves SQL

An airhacks.fm conversation with Lukas Eder (@lukaseder) about: a
Unisys 8086, don't break your dad's computer, playing with
"format", starting with QBasic and 12 years, serial cable chat
programs in QBasic, Turbo Pascal with 15, changing the font in the
BIOS, starting CMS with PHP and MySQL, no transactions, no
connection pools in PHP, the beginning with serverless and CGI,
Java is not a website technology, Java static pages vs. PHP
includes, enterprise PHP: Zend Framework, from PHP to Java, PHP 4
to PHP 5 migration and the assignment operator, enjoying Java 1.3,
Ant vs. Maven 1, a reporting project for a telco company with Java
and Hibernate, writing backends in SQL and frontends with XSLT,
stateless, functional programming with XSQL and SQL, jooq manual
was built with XSLT, apache Cocoon and XSLT, Servlets and Java
Message System (JMS) with WebLogic, from Hibernate query builder to
jooq in 2006, cascading interfaces which feel like SQL, everyone
built a query builder, rewriting jooq - jooq2 in 2008, queryDSL -
the abstraction across multiple query language, jooq only abstracts
SQL, dynamic "where" clauses with criteria query, jooq stands for:
j-object oriented query, jooq started with stored procedure
support, SQLJ the preprocessor, PRO-C* -> the C preprocessor for
Oracle to generate boring glue code, jooq 1 was a procedural query
builder, jooq 2 DSL API looks like SQL and uses the query builder
layer, the database first design, SQL is not composable, SQL:
different syntax on different levels, 1000 lines of jooq code is
not unusual, DSLContext - the starting point, commercial support
for jooq is available, database migrations with jooq, opensource
vs. commercial edition, dependency on products, saving costs with
opensource, focus on Jakarta EE, Java EE, MicroProfile API vs.
direct runtime dependencies, working with dynamic SQL and jooq,
database vs. Java first

Lukas Eder on twitter: @lukaseder