Does anyone use the PL / SQL Web Toolkit?

Question

Does anyone even use the PL / SQL Web Toolkit ? We use it for internal reporting where I work.

However, does anyone have experience in building customer-oriented websites? Common advantages / disadvantages over other web languages ​​like JSP, PHP, etc.

Answer 1

I sometimes use toolkit bits, but mostly use Application Express . These days, it would seem to pervert the creation of an application entirely through the APIS toolkit, when Apex makes it all 100 times easier!

Answer 2

If you have enabled Apex then check out the internet apps here and the commercial apps here

If I started a new web development based on PL / SQL, I would go to Apex, and not directly from the toolkit. View it as a Framework. Version 4 is in pre-release (available to run in the host environment), which may fit your timelines better than the current version 3.2.

I have no doubt that you can create usable and usable applications in any of the technologies. If your application is highly data oriented, you can get additional support from a database based. If you already have Oracle skills, this will also aim for Apex.

On the other hand, things like Ruby on Rails, PHP, etc., will have more users and more detailed control over the application. Separating the database from the application is one of the advantages of these technologies, which may be relevant in terms of uptime / scalability.

Answer 3

Just to throw my two cents ... I have used PL / SQL web tools for several web applications over the last ten years or so. What I like best is a close connection to the data, since all processing takes place in the database. (The fact that some database administrators do not like is a close connection to the data, since all processing takes place in the database.)

The Express application is a great repository-based database built on top of the toolkit. Unfortunately, in my opinion, APEX is starting to follow the path of Java EE and other frameworks with huge client libraries for implementing the whiz-bang user interface widget. With that said, I turned on AJAX processing, where it makes sense to me from the HTML generated from the toolkit routines.

So, consider me a fan, first of all, because of integration with the database and unlimited flexibility to create most of any browser-based applications that have no analogues that you can think of.

There are several articles on my website that discuss basic application development and other issues.

Answer 4

There was a lot of toolkit use back 5-10 years ago, most of them used Oracle Designer to generate PL / SQL. We still have external applications using appearance. For example, information on Wisconsin drinking water at http://prodoasext.dnr.wi.gov/inter1/pws2$.startup .

But I look like some other respondents. If you want an Oracle solution, upgrade to APEX (or ADF). If you don't care if this tool is Oracle, there are many options.