Calculating Tupper’s Self-Referential Formula With SQL – Java, SQL and jOOQ.
A really geeky way to start a Monday morning is to be nerd-sniped by the…
A really geeky way to start a Monday morning is to be nerd-sniped by the…
One of the biggest contributors to SQL syntax verbosity is the need to explicitly JOIN…
Sounds fancy, right? But it’s a really nice and reasonable approach to doing dynamic SQL…
The SQL standard is a nice thing. But it’s a standard. And as such, while…
If you’ve been following the fast paced JDK 9+ projects, you may have noticed an…
A common problem with dynamic SQL is parsing performance in production. What makes matters worse…
In a previous blog post, I wrote about why you should (almost) always default to…
Something that has been said many times, but needs constant repeating until every developer is…
When inserting records into SQL databases, we often want to fetch back generated IDs and…
A fun report to write is to calculate a cumulative percentage. For example, when querying…