Free and convenient Web application development framework for Oracle (1)

Free and convenient Web application development framework for Oracle (1)

APEX

In general, APEX is the most convenient and efficient development framework I have ever seen. It is more comfortable to use than PHP. It was easy to get started, and the learning cost was very low. I once had an administrative girl who could develop a simple approval management site within two days under my guidance. If an enterprise wants to do some internal applications, APEX is the top choice.

Compared with other frameworks I have used, APEX has two unique features:

Online Editing without desktop IDE.

Developed using SQL and PL/SQL.

Is the APEX Development interface:

APEX relies on databases to execute business logic and generate html pages. Various la S and control templates on the page are stored in the database. An Oracle data plus an http server is all about it. If you use the PL/SQL Gateway of the database, even independent http servers are not required. Therefore, APEX is a part of the Oracle database. The latest versions of Oracle databases contain APEX, which is installed along with the database by default.

APEX does not have a dedicated data access layer, and SQL is used for data operations. On the one hand, it is simple, on the other hand, because it is online development in the database environment, you can directly read database objects, SQL is mostly semi-automated generation. The background business logic is implemented using PL/SQL. The Oracle package is powerful enough, but it cannot be used. The Oracle database also has jvm and can write java code; or it also supports web service, you can call an external module.

The UI is very MVC-based. M includes items for data storage. V uses html templates to generate layout and controls. C is responsible for computing, verification, data processing, and navigation. APEX interface elements include commonly used list, form, chart, button, and various input controls. You can also build your own plugin, or use a third-party plugin, or even join extjs js framework. However, as a convenient framework, I do not advocate in-depth custom development. Form + list can satisfy most applications. There are only a few types of applets for large systems such as Siebel.

Is the APEX application style:

APEX also comes with dozens of packaged applications, such as project management, issue tracking, and reports, which can be quickly deployed.

In terms of fees, APEX does not require additional licenses. If you have purchased an Oracle database, you can directly use APEX. If not, APEX also supports Oracle XE databases.