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

By Peter Raganitsch

Oh child, exactly just exactly what took place?

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

From then on we turned far from Twitter, decided to go to rest, got up once more, and had an incredible day with the household. Until we looked over my Twitter reactions and mentions.

Below are a few examples:

This discussion steered a wrong means and partly painted a wrong photo and wasn’t the things I had been after. I’D LIKE commentary. I THINK they truly are vital and good.

Simply because some feedback are wrong or unnecessary, doesn’t suggest you should not comment at all.

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

Regardless of how smart you are thought by you will be. In spite of how “self explanatory” you believe your genius rule is. Feedback are vital. Commentary exist to describe the thinking behind your (crappy? ) rule to OTHER PEOPLE. They could never be as smart as you, they could n’t have equivalent information degree as you.

Heck, for many we understand they may perhaps perhaps maybe not be developers that are#orclAPEX 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 scuba scuba diving into APEX. They require guidance and a little more description of the “oh so smart code”.

Now get the feelings that are personal and do your task. Precisely! And produce the essential code that is beautiful ever!

P.S.: I Am Aware, I Understand. Life is difficult, there is absolutely no time. No body would like to spend you for additional time. But commenting your rule just isn’t time that is extra. Composing paperwork about implementation details is certainly not more time. Its an essentialPART of software development.

If you’re in work that does not provide you with the time for you to comment your rule, think about a big change.

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

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

Have a look at occasion details and join!

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

We invited Sunil Tandan through the APEX workplace Print Team, to offer a halfday intro training to any or all that is interested (and fits the available space).

If you should be in your community you really need lovestruck log in to surely book this.

Accelerating APEX Static Application and Workspace Data

A few years back it had been deemed state-of-the-art to keep any type of extra resources (pictures, css/js-files) right on the webserver.

Needless to say this is simply the best-practice, kept with numerous who had been unable to follow due to business limitations: no use of internet host, maybe maybe maybe not permitted to store files, way too many laws, an such like.

Fortunately APEX 5++ gave us well working Static Application Files and Static Workspace data. Now everybody is utilizing those to keep additional files.

Tomcat with ORDS operating APEX behind a reverse proxy

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

An available issue was that APEX had been nevertheless thinking it operates on slot 80 with http, while nginx ended up being running https on slot 443.

APEX Survey

As a large fan of APEX Packaged Applications i usually wished to have actual life usecase for the Survey Builder.

Work with a directory structure as Image Prefix in APEX

Often the APEX images live in a directory in your server called /i/, and that can be changed on example or application degree.

In 95per cent of all of the 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 mentioned changing the /ords Address to something else, now I would like to show another solution to manipulate the URL.

I disliked deploying multiple ORDS circumstances, merely to provide paths that are different exactly the same DB. This occurred away from SEO or legacy purposes up to now.

Now let’s put up a easy reverse proxy to produce any URL structure you desire for the APEX host.

Deploy ORDS on tomcat in a subdirectory

Often ORDS is implemented on Tomcat just as /ords, right?

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

Exactly what if you would like have “mod/plsql“, like in http: 8080/mod/plsql this is certainly: //myserver. Tld?

Why the Trim Spaces environment on APEX items is very important

Oracle APEX delivers a declarative environment for Text and Textarea what to “Trim Spaces”, which will eliminate leading/trailing areas through the individual input prior to saving the value towards the database.