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
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 … Continue reading What Will be Oracle’s Next Big Acquisition?
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 … Continue reading The Myth About Slow SQL JOIN Operations