SAP’s Hilarious SQL Whitepaper(s)

While looking for some authoritative information about Sybase SQL Anywhere 12's TOP .. START AT clause, I stumbled upon this hilarious white paper here, which I do not want to keep from you: http://www.sybase.com/files/White_Papers/Sybase_Top_10_Features_In_SQL_Anywhere_12.pdf I will take advantage of "fair use policy" and cite parts from section 7: Feature number 7: improved support for DaffySQL … Continue reading SAP’s Hilarious SQL Whitepaper(s)

jOOQ at the MEDIT Symposium

Join me at the MEDIT Symposium in Sicilly in early October: http://www.medit-symposium.com/lukas-eder.html I'll be talking and demonstrating in details about jOOQ. A lot of other, geeky and open sourcey talks are held during two days for very competitive prices: http://www.medit-symposium.com/schedule-day-one.html http://www.medit-symposium.com/schedule-day-two.html See you there!

The Announcer Badge on Stack Overflow

It just struck me like lightning. I just realised one (surely not the only) very important reason, why Stack Overflow always winds up at least once in the top 10 search results on Google for virtually any programming-related search. The Announcer Badge. When you share a link to a Stack Overflow question or answer using the … Continue reading The Announcer Badge on Stack Overflow

10 Common Mistakes Java Developers Make when Writing SQL

This article is part of a series. You might also like: 10 More Common Mistakes Java Developers Make when Writing SQLYet Another 10 Common Mistakes Java Developers Make When Writing SQL Java developers mix object-oriented thinking with imperative thinking, depending on their levels of: Skill (anyone can code imperatively)Dogma (some use the "Pattern-Pattern", i.e. the … Continue reading 10 Common Mistakes Java Developers Make when Writing SQL

Jenkins (and Others) about Dropping Support for Java 5

As an Open Source developer, I'm used to trying to support as many reasonable things for my users as possible. However, this has never included support for Java 5, which itself is hardly supported by popular Java vendors anymore. Hence jOOQ requires Java 6 or more to compile and run. There is now an interesting initiative … Continue reading Jenkins (and Others) about Dropping Support for Java 5

How to Generate Date Ranges in Oracle SQL

I've just come across an interesting SQL question here on CodeRanch. How to generate date ranges in SQL, given any input date. The question didn't specify the SQL dialect, so let's choose Oracle SQL, which features the awesome CONNECT BY clause. The requirements specify that given any input date: Date ranges span 12 months The … Continue reading How to Generate Date Ranges in Oracle SQL

Leap Seconds. Will our Understanding of Time Change in 2015?

No matter what programming language we choose, we programmers all share one big misery: Having to deal with calendars. We all get it wrong dozens of times in our working lives. And when we think we finally understood calenders, we get taught better. While some take the time to delve into the misteries of calendars, … Continue reading Leap Seconds. Will our Understanding of Time Change in 2015?

How to Make Your Advertisement Look Like Spam

I had experienced ZeroTurnaround's marketing and sales before, and I thought it was a bit agressive, although their products seem really nice and cool, so I had forgiven them at the time... However, looking at the numerous links to their product JRebel on CodeRanch just looks like quite offending spam to me. Consider an arbitrary … Continue reading How to Make Your Advertisement Look Like Spam

10 Things in SQL Server Which Don’t Work as Expected

So far, I have been blogging about curious RDBMS caveats mostly related to Oracle and MySQL databases. Some examples: You never stop learning about Oracle features NOT IN vs. NOT EXISTS vs. LEFT JOIN / IS NULL: MySQL SQL incompatibilities: NOT IN and NULL values MySQL Bad Idea #384 But there are also other databases, … Continue reading 10 Things in SQL Server Which Don’t Work as Expected

Nice Tutorial for Creating an External DSL with Xtext

When blogging about DSLs, I'm mostly blogging about internal domain-specific languages, because jOOQ is a good example for internal DSLs. But external domain-specific languages are an interesting topic as well. As an external DSL does not depend on any host language (e.g. Java), it can be much richer in syntax and expressivity. On the other … Continue reading Nice Tutorial for Creating an External DSL with Xtext