Java 8 Friday Goodies: Lambdas and Sorting

At Data Geekery, we love Java. And as we're really into jOOQ's fluent API and query DSL, we're absolutely thrilled about what Java 8 will bring to our ecosystem. We have blogged a couple of times about some nice Java 8 goodies, and now we feel it's time to start a new blog series, the... … Continue reading Java 8 Friday Goodies: Lambdas and Sorting

Introducing CQLC – a Query DSL for Cassandra’s CQL in Go, Inspired by jOOQ

This morning, we've had very nice feedback about our work on the jOOQ User Group by Ben Hood, who has been a long-time jOOQ user and ideas/bug report contributor. He has taken inspiration from our software to build CQLC, a fluent API / query DSL for Cassandra's CQL written in Go. Citing Ben: I think … Continue reading Introducing CQLC – a Query DSL for Cassandra’s CQL in Go, Inspired by jOOQ

Java 8 Friday Goodies: The New New I/O APIs

At Data Geekery, we love Java. And as we're really into jOOQ's fluent API and query DSL, we're absolutely thrilled about what Java 8 will bring to our ecosystem. We have blogged a couple of times about some nice Java 8 goodies, and now we feel it's time to start a new blog series, the... … Continue reading Java 8 Friday Goodies: The New New I/O APIs

jOOQ Newsletter: January 22, 2014

Subscribe to the newsletter here Tweet of the Day We are contributing this new section of the newsletter to our followers, users, and customers. Here are: Jose M. Arranz who has had plans to build jOOQ, when he happily discovered that jOOQ already exists https://twitter.com/jmarranz/status/417956223468982272 Majid Azimi who wishes for jOOQ to become the new de facto standard in all … Continue reading jOOQ Newsletter: January 22, 2014

Java 8 Friday Goodies: Lambdas and XML

At Data Geekery, we love Java. And as we're really into jOOQ's fluent API and query DSL, we're absolutely thrilled about what Java 8 will bring to our ecosystem. We have blogged a couple of times about some nice Java 8 goodies, and now we feel it's time to start a new blog series, the... … Continue reading Java 8 Friday Goodies: Lambdas and XML

What you Didn’t Know About JDBC Batch

In our previous blog post "10 Common Mistakes Java Developers Make When Writing SQL", we have made a point about batching being important when inserting large data sets. In most databases and with most JDBC drivers, you can get a significant performance improvement when running a single prepared statement in batch mode as such: PreparedStatement … Continue reading What you Didn’t Know About JDBC Batch

Do You Want to be a Better Software Developer?

Bloggers are a different breed. They're spending a lot of time investigating issues in a systematic way that is presentable to others. And then they share - mostly just for the fun of it and for the rewarding feeling sharing gives them. Whenever we google for a technical issue, chances are high that we stumble … Continue reading Do You Want to be a Better Software Developer?

Advanced Java Trickery for Typesafe Query DSLs

When browsing Hacker News, I recently stumbled upon Benji Weber's most interesting attempt at creating typesafe database interaction with Java 8. Benji created a typesafe query DSL somewhat similar to jOOQ with the important difference that it uses Java 8 method references to introspect POJOs and deduce query elements from it. This is best explained by … Continue reading Advanced Java Trickery for Typesafe Query DSLs

Lesser-Known SQL Features: DEFAULT VALUES

A lesser-known SQL feature is the DEFAULT keyword, which can be used in INSERT and UPDATE statements. Consider the following table, created using standard SQL syntax: CREATE TABLE timestamps ( id INTEGER GENERATED BY DEFAULT AS IDENTITY(START WITH 1), t TIMESTAMP DEFAULT CURRENT_TIMESTAMP, CONSTRAINT pk_values PRIMARY KEY (id) ) Now, in order to generate a … Continue reading Lesser-Known SQL Features: DEFAULT VALUES

The SQL Language’s Most Missing Feature

SQL is also awesome in many ways. We can write out the most complex truths and facts and have the database tell us the answer in no time. But the SQL language is arguably the most beautiful programming language out there. It has so many caveats that people like me get ridiculously rich selling consulting services … Continue reading The SQL Language’s Most Missing Feature