I believe there have never been bigger announcements surrounding Oracle Application Express (APEX) than in the last weeks (or actually months). Oracle is really putting cannons on the marketing of Oracle APEX now!
In the Oracle APEX community, we typically come together at the many APEX conferences in the world. Things changed with COVID and while all the conferences got canceled, the awareness of Oracle APEX rose significantly. Oracle setup special forces to build COVID apps (including Larry Ellison himself!)... and used Oracle APEX to do so. Those apps were mentioned in the White House and many different articles around the world. Not only on the outside things changed, but also on the inside at Oracle, the view towards APEX changed a lot. Oracle APEX finally received the recognition of the leadership team we already knew it deserved for 15 years. And once Larry Ellison, Safra Catz, and the entire management and marketing team get behind something, it's unstoppable.
It started on December 8th through the 10th, 2020, with the Build Low Code Apps using APEX - Partner Technical Council 2020, where Joel Kallman and many people of the APEX Development team gave an update and did Q&A with the audience.
December 16th, 2020, with the Virtual Summit Build Applications Faster with Low Code. There were different presentations, but the biggest impact came from Michael Hichwa, the father of Oracle APEX, who announced the new Oracle APEX Application Development Service.
On January 13th, 2021, Andrew Mendelsohn, executive vice president of Oracle database server technologies, presented the latest announcements about Oracle Database 21c and the new Oracle Application Express (APEX) low-code application development service.
Today when you go to oracle.com, Oracle APEX is front and center.
So things changed a bit compared to a few years ago... so let's go back to why I am writing this blog post.
This new Oracle APEX Application Development Service is an interesting spin on the Oracle Cloud. Where before you would set up an Oracle Database and Oracle APEX came with it, with this service it's the other way around! You sign up for a Low Code Development Platform called Oracle APEX, and you get an Oracle Database with it!
I really like this service, because for a relatively low price (360 USD all costs included) you get a fully managed Oracle APEX instance running on unbeatable hardware (Exadata), which is able to autoscale based on your needs!
And what is even better, it looks like this service will also come in the Oracle Cloud Free Tier! I wonder if the disk space is the same as the ATP free tier... remains to be seen. At the moment you can either buy it or try it with the free credits when you sign up.
Just like my blog series when Oracle launched the Always Free Oracle Cloud, I thought to write a few posts while I set up and test this new service myself.
Here's my agenda for the upcoming blog posts (subject to change based on my experiences and questions raised by you):
This post is part of the Getting Started with Plug-ins Pro APEX plug-ins series.
In many Oracle Application Express projects, there's a requirement that people can upload files. Typically the end-users want the ability to drag-and-drop images, PDFs, or other file types in their application.
For example, if you use APEX Office Print, you might have added in your application the ability for end-users to upload their own templates which typically are docx, xlsx, pptx, html and text files.
Those files are then stored in the database in a BLOB column or they might be stored on a file server or cloud storage.
In order to add this capability in your app, APEX provides a File Browse item.
But be careful with the accepted File Types feature. You can define image/* if you want your browser to only allow selecting of images. BUT specifying the file type doesn't prevent users from dragging-and-dropping other file types! So you can't rely on this feature to keep other file types out of your database.
As this is a native HTML File Browse item, you can customize it with CSS (and HTML and JavaScript). For example, you can make it look like what APEX provides in the APEX Builder itself:
In most of the projects I'm involved in, the end-users want more than the standard HTML File Browse that Oracle APEX provides out-of-the-box.
The most requested features are: