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 instance, to generate charts:

http://theformspider.com/API/api_chart.html

Intrigued? Me too! ;-)

What Will be Oracle’s Next Big Acquisition?

Now THIS is an interesting Quora question. Citing:

What will be the next big acquisition by Oracle?

What will be the next acquisition made by Oracle that could be compared (as a strategic decision, not necessarily  by value) to Oracle’s Sun Microsystems acquisition?

From my perspective, clearly, Oracle will buy jOOQ from Data Geekery GmbH, in order to finally closely integrate their two most valuable assets:

  • The Oracle Database
  • The JVM and Java

But maybe, they’ll just buy another airline ;-)

What is your bet? Comment below, or answer the question here:
http://www.quora.com/Oracle-company/What-will-be-the-next-big-acquisition-by-Oracle

The Myth About Slow SQL JOIN Operations

In my recent SQL work for a large Swiss bank, I have maintained nested database view monsters whose unnested SQL code amounted up to 5k lines of code, joining the same table over and over again in separate subselects combined via UNION operations. This monster performed in way under 50ms, no matter how we queried it (see “10 more common mistakes” about the speed of queries). Of course, this performance was only achieved after lots of fine-tuning, load-testing and benchmarking. But it worked. Our Oracle database never let us down on these things.

Nonetheless, many SQL users think that JOIN operations are slow. Why? Perhaps because they are / used to be, in MySQL? I’m currently reading this interesting book by Markus Winand. The book is called SQL Performance Explained. He’s also the author of Use-The-Index-Luke.com where you can get free insight into his book. I still recommend reading the whole book, though. Even SQL old-timers and SQL nerds like me will find 1-2 novel, very interesting approaches, some of which will be incorporated into jOOQ very soon!

In particular, consider this page which explains very well how Hash JOIN operations work:
http://use-the-index-luke.com/sql/join/hash-join-partial-objects