OK, now this beats everything I've seen so far. I can now code in the cloud with Koding.com. From a first, very quick glance, I get: A VM with a terminal (looks like a Debian distribution) PHP and all sorts of stuff that is already installed An app store for apps like PostgreSQL or MySQL … Continue reading This Beats Everything: Koding in the Cloud
I've just discovered the Ninja Web Framework. This one isn't "yet another framework", it's actually heavily based on the very popular Play Framework ideas. It seems to provide a substitute for the latter, since Zenexity and Typesafe have formed an alliance to further support Play primarily in the Scala ecosystem. Some people may feel that this … Continue reading Will Another Play-Style Framework Make its Way to Java?
There was this recent Quora question about why we need RDBMS: Why not just use text files? What can RDBMS do that a simple text file cannot? Or, why not use several different text files to represent different tables? Heh. Let's challenge that through a witty comparison (also given as an answer to the above … Continue reading Why do We Need RDBMS?
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?
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
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
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
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
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
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