Oracle Application Express (APEX) and Oracle Visual Builder Cloud Service (VBCS) are two low-code platforms by Oracle that can both be used for creating web applications. But what are the differences and similarities between the two front-end technologies? In this two-part blog series, we want to get to the bottom of this question. First, Oracle APEX and Oracle VBCS will be introduced. In the second part, we will compare the two technologies according to different categories.
What is Oracle APEX?
APEX is based on a three-tier architecture. HTTP requests are sent from the client, in this case the browser, to the database via the Oracle Rest Data Service. The responses are sent back to the browser vice versa. Here, data queries and manipulations are executed directly in the database.
With Oracle APEX, it is therefore easy to create database-related web applications. It is also possible to create Excel-like evaluations on data of the database. Furthermore, extensions of standard applications – like the Oracle E-Business Suite – can be created easily.
What is Oracle VBCS?
Oracle JET comes with a number of ready-made components such as tables, lists, toolbars and the like. These can be used in VBCS to implement responsive web applications. The data that is to be displayed needs to be provided in the form of REST services. Databases or files cannot be accessed directly. Oracle VBCS is usually operated together with an autonomous database and an ORDS. In order to access data from other data sources, these need to be made available via REST services.
With the help of Oracle VBCS, web applications can be quickly created, debugged and tested. In addition, it is possible to almost seamlessly extend Oracle Software as a Service (SaaS) products such as Oracle Fusion HCM Cloud. Displaying and manipulating data is quickly implemented as well. With the help of Oracle VBCS, responsive web apps as well as Progress Web Apps (PWA) can be easily implemented.
To gain a better understanding of what an application looks like with APEX or VBCS, a simple application was each created in both technologies. This application displays the data of a table with 3 columns (ID, talk and date), and new records can be added. In APEX, this was solved with an Interactive Grid, in VBCS it was realized with a table containing a form.
Example in VBCS:
Example in APEX:
In the second part of this blog series, Oracle APEX and Oracle VBCS are contrasted and compared in seven different categories.