be friends with Oracle and APEX. Commenting your rule is a must!

By Peter Raganitsch

Oh kid, exactly just what occurred?

Yesterday we delivered a tweet that is emotional reviewing a bit of (open supply) rule, that wasn’t documented well and didn’t consist of inline responses:

From then on we switched far from Twitter, went along to rest, got up again, along with is sugar daddy meet free a wonderful day with your family. Until we looked over my Twitter reactions and mentions.

Below are a few examples:

This discussion steered a wrong method and partly painted a wrong image and wasn’t the things I had been after. I’D LIKE commentary. I THINK they’ve been good and vital.

Simply because some feedback are unneeded or incorrect, doesn’t suggest you shouldn’t comment at all.

The exact opposite does work: should anyone ever stumble across a incorrect remark in some rule, allows change it out. Lets enhance it. Lets repair it.

Regardless of how smart you think you might be. Regardless of how “self explanatory” you might think your genius rule is. Commentary are vital. Reviews are there any to spell out the thinking behind your (crappy? ) rule to OTHER PEOPLE. They could never be because smart as you, they could n’t have exactly the same information degree as you.

Heck, for several we realize they may perhaps not be #orclAPEX designers at all. I’ve seen Java dudes (no offense) tempering with APEX applications. Mostly we come across regular database designers, or forms that are former scuba diving into APEX. They require guidance and much more description of the “oh so code” that is smart.

Now ensure you get your individual emotions apart and do your task. Precisely! And create probably the most stunning rule, ever!

P.S.: I Understand, I Understand. Life is difficult, there is absolutely no time. No body really wants to spend you for additional time. But commenting your rule just isn’t additional time. Composing documents about execution details is certainly not time that is extra. It’s an essentialPART of pc software development.

If you’re in work that does not supply you with the time and energy to comment your rule, think about an alteration.

Expanding Oracle APEX – real time event in Vienna. AOP Introduction in Vienna

Quick Note: this Friday, October 4th 2019, will soon be a early morning occasion about extending Oracle APEX with Single Page Applications, Master-Detail, and Drag&Drop. In Vienna during the Oracle workplace.

Take a look at the occasion details and join!

Reserve a free of charge spot in our AOP Introduction training, on November 8th 2019 in Vienna/Austria.

We invited Sunil Tandan through the APEX workplace Print Team, to provide a halfday intro training to everyone else that is interested (and fits the space).

If you should be in your community you need to absolutely book this.

Quickening APEX Static Application and Workspace Data

A years that are few it absolutely was deemed state-of-the-art to keep almost any additional resources (pictures, css/js-files) right on the webserver.

Needless to say it was simply the best-practice, kept with several who had been unable to follow due to business restrictions: no use of internet host, maybe maybe perhaps not allowed to keep files, a lot of laws, and so forth.

Fortunately APEX 5++ gave us Static that is nicely working Application and Static Workspace data. Now most people are utilizing those to keep files that are extra.

Tomcat with ORDS APEX that is running behind reverse proxy

Not long ago we posted helpful information just how to put up nginx as a reverse proxy right in front of tomcat to operate ORDS and APEX. Start to see the post right here.

An available issue had been that APEX had been still thinking it operates on slot 80 with http, while nginx had been running https on slot 443.

APEX Survey

As a huge fan of APEX Packaged Applications i usually desired to have life that is real when it comes to Survey Builder.

Work with a directory framework as Image Prefix in APEX

Often the APEX images have a home in a directory in your server called /i/, which is often changed on example or application degree.

In 95per cent of most situations We saw, the image prefix is /i/, frequently it’s extended by a variation quantity like /i501/ or /i181/. Maintain reading >

The Oracle APEX Reverse Proxy Gu published on 08.10.2018 by Peter Raganitsch

Just lately we discussed changing the /ords Address to something different, now i do want to show another real solution to manipulate the URL.

I usually disliked deploying multiple ORDS circumstances, simply to provide paths that are different exactly the same DB. This took place away from legacy or SEO purposes to date.

Now let’s put up a reverse that is simple to accomplish any URL structure you would like for the APEX server.

Deploy ORDS on tomcat in a subdirectory

Often ORDS is deployed on Tomcat merely as /ords, right?

Where do you turn, if you like a unique title than ords, let’s say you may like to see “bruce” in the Address? Simple solution: just rename ords. War to bruce. War before deploying to Tomcat.

But exactly what if you would like have “mod/plsql“, like in http: 8080/mod/plsql that is: //myserver. Tld?

Why the Trim Spaces environment on APEX items is very important

Oracle APEX delivers a setting that is declarative Text and Textarea what to “Trim Spaces”, which will eliminate leading/trailing areas from the user input prior to saving the value towards the database.