Progressive Web Apps (PWA)
Start course

This course will guide you through how to create a database application through a variety of features offered by Oracle APEX.

Learning Objectives

  • Gain a foundational understanding of App Builder Concepts
  • Learn how to access App Builder and how to access the Create Application Wizard to build your APEX applications.
  • Understand how to create an APEX application based on existing tables
  • Understand how to create an Apex application from a file
  • Learn about Progressive Web Applications and how to enable Progressive Web Application installability within your APEX application

Intended Audience

  • Anyone who wants to enhance their knowledge of Oracle APEX


We recommend that you take this course as part of our Oracle APEX: Foundations learning path.


Hello, welcome to Oracle APEX Foundations Course, Creating a Database Application Module, Progressive Web Application Lesson. My name is Chaitanya. I am a product manager on the Oracle APEX Product Development team. So far, we learned how to create an APEX application based on existing database tables and how to create an APEX application from a fan. It's time now to learn about Progressive Web Application, PWA, and how to enable the installability of PWA on your device. Let's get started. In this lesson, we'll learn about a Progressive Web Application and how to enable Progressive Web Application installability in your APEX application. So, what is a Progressive Web App. Progressive Web Applications, or PWA, are web applications that can be integrated more closely with the device

it's running on, whether it is a desktop or a mobile device. Progressive Web Applications leverage modern web APIs, giving users an experience that looks and feels like a native application. Your APEX applications can easily be defined as a PWA or Progressive Web Application, to take advantage of advanced caching and improved performance.

These applications can also be installed on your smartphone of choice with device-specific installation instructions. You can create a Progressive Web Application by creating a new application with the Create Application Wizard, or by editing attributes of an existing APEX application. As you learn how to create an APEX application, in a previous lesson, you can recall the Create Application Wizard which displayed features section and a checkbox to select for Progressive Web Application installability. So, what are the requirements for a Progressive Web Application? The APEX application must be served over a secured HTTPS environment or local host. If you are using an unsecured environment, PWA features will not be rendered. The application Definition, Properties, Friendly URLs attributes must be set to On. What happens with enabling PWA functionality in your APEX application? It adds the ability to install the application as a Progressive Web App. It adds a new navigation bar entry named Install App to your application. It optimizes page loading speed on the mobile device. It improves page load rendering time with a new browser cache architecture for static files.

Enabling PWA functionality enables users to install the application on their devices. It provides a customizable offline page when users are offline and cannot request the network. Enabling PWA functionality supports hooks into the service worker code for a fully customizable PWA experience. So, now is the demo time to watch how to enable Progressive Web Application functionality and how you can install and run the application on your device. Enabling PWA installability in your APEX application. On the workspace homepage, let's go to SQL Workshop, Utilities, Sample Datasets. Let's install a sample dataset, for example, Project Data. Let's click 'Install', click 'Next', and then click 'Install Dataset'. Once the sample dataset has been installed, let's click 'Create Application' to create an application on top of this dataset. Click 'Create Application'. Let's accept the defaults in the 'Create Application Wizard'. Scrolling down a bit, you see features, and you notice that all of the features' checkboxes have been selected by default.

Let's uncheck the checkboxes for all of the features except Install Progressive Web App. And now let's click 'Create Application'. The application has been created successfully, let's click 'Run Application'. Enter your workspace username password and then click 'Sign In'. On the application home page, notice the 'Install App' button. Let's click the left navigation menu and click 'Dashboard'. This displays the charts. And then let's click 'Projects'. This displays a card's page for us. And then let's click 'Milestones'. This displays an interactive break. Let's click 'Tasks'. This displays a faster search page. And then let's click 'Tasks Calendar', which displays a calendar for us. Now, let's go back and click the 'Install App' button to see what happens. We now see that there is an Install App dialog box which is asking you to install the application. So, lets click 'Install'. Notice, that the application is now installed on your device. So, let's click this, and you can run the application. Go through the Homepage, go through the Dashboard page, Projects, and the other features as well.

So, now that you have watched how to enable PWA installability in your APEX application and how to install this application on your device, let's learn how to make an existing application a PWA. To make an existing application into a PWA, edit your application definition, and then under Properties, make sure the Friendly URLs switch is turned on. Then click the Progressive Web App tab and then make sure under the General, enable Progressive Web App switch is turned on. You can then configure the remaining Progressive Web App attributes. In this lesson, we learned what is a Progressive Web Application and how to enable Progressive Web Application installability in your APEX application. This concludes the lesson on Progressive Web Application. I hope you find that useful. Thank you for watching.

About the Author
Oracle University
Training Provider
Learning Paths

Oracle University, the learning and training arm of Oracle, is a leader in cloud education, providing modern digital training, certification, and learning solutions across Oracle’s entire product portfolio that enable our customers to master their Oracle Cloud solutions and maximize their investments. Over 2 million certified professionals worldwide have placed their trust Oracle University to reach their learning goals. Learn about Oracle University.

Covered Topics