We're all Software Engineers of one type or another. Most of us have one thing in common, though: We're lazy. And we know that someone else was less lazy and has already solved that tedious problem that we're on. And because we're not only lazy but also stingy, we search for Free Open Source software. … Continue reading 10 Reasons not to Choose a Particular Open Source software
On Terms and Conditions
Now here are some Terms and Conditions that I can most certainly agree with:
MySQL Bad Idea #573
This is MySQL's Bad Idea #573 (after #384, which I've blogged about before) I've just had a terrible experience with a bug report from the jOOQ User Group, related to escaping of backslashes in string literals in MySQL. First, I thought to myself, whatever. SQL doesn't escape backslashes. The only escape character within a string … Continue reading MySQL Bad Idea #573
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?