Military Campaigns?? Haha. Let's meet Capt. DBA, mastering Sun Tsu's Art of SQL: http://de.scribd.com/doc/15490992/The-Art-of-SQL Citing from the book cover: Do you view database applications as military campaigns? Do you see data as row upon row upon row of enemy columns to be winnowed down and slashed away? [sic!] SQL veteran Stéphane Faroult does. This is … Continue reading Do You View Database Applications as Military Campaigns?
Brian Goetz’s Final State of the Lambda Documentation
This week, Brian Goetz has published the final State of the Lambda documentation, which can be seen here: State of the Lambda State of the Lambda: Libraries Edition These are exciting times in Java, as Java 8's most impactful project has finally stabilised and can be downloaded here: JDK8 Developer Preview
Amazing Web Applications with PL/SQL and Formspider
In the good old days, dynamic web applications were created using cgi-bin and C. Yes, C as in pre-C++. Today, this might seem odd or even crazy. But why not. And why not create a website using PL/SQL? Check out Formspider, a web framework that connects AJAX requests directly with PL/SQL stored procedure calls. For … Continue reading Amazing Web Applications with PL/SQL and Formspider
Fast File System Operations with Xtend, Lambdas, and ThreadPools
Recently, I've blogged about 10 Subtle Best Practices when Coding Java, and I have mentioned that you should start writing SAMs (Single Abstract Method) now, in order to be prepared for Java 8. But there's another language gem out there, which comes in handy every once in a while, and that's Eclipse Xtend. Xtend is a … Continue reading Fast File System Operations with Xtend, Lambdas, and ThreadPools
jOOQ Newsletter September 17, 2013
Subscribe to this newsletter here. SQL for calculations SQL can be used for heavy calculations. This doesn't mean that it has to, of course. Many Java-oriented software architects are reluctant to allow for business logic entering their database. DBA tend to disagree and promote complex logic in database views or stored procedures. The pros and … Continue reading jOOQ Newsletter September 17, 2013
Why PostgreSQL is so Awesome
Just recently, I've blogged about PostgreSQL 9.3 having been released, which is awesome enough as PostgreSQL finally supports materialised views and updatable views. I have then blogged about PostgreSQL's syntax being a mystery only exceeded by its power, as it allows for treating INSERT and UPDATE statements as table references, when used with the RETURNING … Continue reading Why PostgreSQL is so Awesome
PostgreSQL Syntax is a Mystery Only Exceeded by its Power
I just ran across this rather powerful PostgreSQL example statement from the manual. It reads Increment the sales count of the salesperson who manages the account for Acme Corporation, and record the whole updated row along with current time in a log table: WITH upd AS ( UPDATE employees SET sales_count = sales_count + 1 … Continue reading PostgreSQL Syntax is a Mystery Only Exceeded by its Power
Crazy Translations of Simple SQL Expressions to Various SQL Dialects
SQL is standardised by ISO / IEC. We have wonderful standards, such as SQL-92, SQL:1999, SQL:2003, SQL:2008. Right? In theory. In practice, many things do not have an equivalence between the actual SQL implementations. This is very true for common function support - most of which are not part of any standard. Here's an interesting … Continue reading Crazy Translations of Simple SQL Expressions to Various SQL Dialects
PostgreSQL 9.3 Released!
A great database has just gotten better. PostgreSQL 9.3 has been released today. While improved reliability and availability is certainly quite a thrilling addition, from the jOOQ perspective, the most interesting features are new SQL syntax elements. These include: Better support for JSON LATERAL JOIN (or as SQL:1999 calls it: lateral derived table) Materialised views … Continue reading PostgreSQL 9.3 Released!
jOOQ Newsletter September 2013
Subscribe to this newsletter here SQL Popularity and Controversy In the last newsletter, SQL popularity was well addressed by the tremendous feedback our articles received: 10 Common Mistakes Java Developers Make When Writing SQL 10 More Common Mistakes Java Developers Make When Writing SQL Together, the above articles have have reached out to more than … Continue reading jOOQ Newsletter September 2013