Why PL/SQL is still the best data access language
Who said PL/SQL isn’t sexy? Sure, its an old language and not embraced as “cool” by the new generation of application developers. But once they see the benefits, its amazing how many people embrace the language they have so long steered clear of.
Another year goes by, and most likely, another data access framework has been invented. It will claim to be the fastest, smartest way to talk to the database, and just like all those that came before it, it will not be. Because the best database access tool has been there for more than 30 years now, and that is PL/SQL. Although we all sometimes fall prey to the mindset of “Oh look, a shiny new tool, we should start using it,” the performance and simplicity of PL/SQL remains unmatched. This session looks at the failings of other data access languages, why even a cursory knowledge of PL/SQL will make you a better developer, and how to get the most out of PL/SQL when it comes to database performance.
An in-depth look at the benefits of PLSQL, and why, even though it is seen as an “old” and “proprietary” language, that it is provably the best tool for building Oracle database applications that perform well, are easily maintained and robust.
Not a “religious war” kind of presentation that we’ve seen in the past by people saying “you must be 100% PLSQL”. This is a more realistic view of how application developers can take advantage of just a little PL/SQL here and there to dramatically improve their apps.