Skip to Main Content
  • Questions
  • Is there a risk in continuing to develop using plsql web toolkit?

Breadcrumb

May 4th

Question and Answer

Connor McDonald

Thanks for the question, Paul.

Asked: September 25, 2017 - 9:07 am UTC

Last updated: September 25, 2017 - 1:18 pm UTC

Version: 11.2.0.3

Viewed 1000+ times

You Asked

Hi Tom,

I hope you can help or point me in the right direction. I have been asked to evaluate an in-house developed system that is written entirely in plsql/web toolkit using mod_plsql. This is a heavily used service, sometimes with very high concurrency and supported by a handful of good developers, who only know plsql and java script.

We are aware that Mod_PLSQL is deprecated in 12c R2, so i am wondering if we need to consider different technologies away from plsql (web toolkit) for future development. Most of the packaged solutions we currently use are now moving to different development technologies such as Groovy/Grails and i am wondering if we should also consider changing development platforms away from plsql/web toolkit?

My question is, do you think that mod_plsql/web toolkit/ ORDS is the development platform/technologies for the next 5 to 10 years or should we consider changing?. I am also wondering if mod_plsql/ORDS is supported by Oracle for production environments, as some blogs appear to suggests it is not suitable for production high load web sites?

Thanks in advance,
Kind regards,
Paul

and Connor said...

mod_plsql is just the *delivery* mechanism. The core elements of database-centric code providing a window into data I think is here to stay. Because that is what APEX is built on.

APEX is a good model for how I think things are evolving. Back in the very early days of htmldb etc, we just to generate *everything* out of the database. But now we perform logic and the fundamentals of data presentation (ie getting the data to the browser) and we rely on more appropriate technologies (Javascript, CSS, etc) to render that data in the most appropriate way.

The comment that "as some blogs appear to suggests it is not suitable for production high load web sites?" is totally fake news. We use APEX internally for hundreds of mission critical applications. AskTOM itself handles millions of hits per month, and is just a single app in a workspace on an APEX installation that contains a huge number of workspaces and applications in those workspaces.

Is this answer out of date? If it is, please let us know via a Comment

More to Explore

APEX

Keep your APEX skills fresh by attending their regular Office Hours sessions.