I don’t talk much about APEX here. That’s not because I don’t endorse the technology. It’s more because we have an entire team that can talk about APEX so much more intelligently than I!
I have however talked about APEX before. Here are a few examples you might find useful:
I worked with Joel for almost a decade. We’d see each other a few times a year at conferences. We’d ride bikes or run together. We argued. We did all the things co-workers and friends do. He told me about APEX team members they had lost and celebrated at their favorite Thai restaurant. We spent more than a few hours at pubs together… It still feels weird to talk about him in the past tense.
If you search the Google or Twitter for #JoelKallmanDay you’ll find a ton of other posts, and if you wait a day or two, Tim will probably inventory them up for us. Also, thanks Tim for starting the Oracle Community Appreciation Day so many years ago and also for honoring Joel’s memory.
ORDS & APEX
Oracle REST Data Services (ORDS) has a few major features. One of them is serving up PL/SQL programs and getting the web content back. If that sounds familiar, it should as it’s what makes getting APEX pages to pop-up in your browsers.
Over the last decade ORDS has grown to be so much more than just a PL/SQL gateway. What this means is, if you’re an APEX customer, with a few configuration flag updates, your ORDS install could make the following things available to you, immediately, for free:
- SQL Developer Web
- REST APIs
- SODA for REST {json-doc-store}
- REST APIs for managing your Oracle Database
Specifically in today’s post I want to call out that last item, and the REST Endpoints for APEX.
So let’s take a quick tour of these!
Get instance statistics /_/db-api/latest/apex/statistics/instance/
Yes, I’m pulling these from my Always Free Autonomous Database instance.
GET APEX Workspaces /_/db-api/latest/apex/workspaces/
GET APEX App/Workspace Statistics /_/db-api/latest/apex/statistics/workspace/{workspace}/
GET APEX Instance Overview /_/db-api/latest/apex/statistics/overview