By Peter Raganitsch

Oh kid, exactly just what occurred?

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

From then on we switched far from Twitter, decided to go to rest, got up once more, together with a day that is awesome your family. Until I 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 WOULD LIKE remarks. I THINK these are typically good and vital.

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

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

In spite of how smart you are thought by you might be. No matter what “self explanatory” you believe your genius code is. Feedback are vital. Remarks are there any to spell out the reasoning behind your (crappy? ) rule to OTHER PEOPLE. They may not be because smart they might not have the same information level while you as you.

Heck, for many we all know they could maybe 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 previous Forms designers diving into APEX. They want guidance and a little more description of the “oh so smart code”.

Now ensure you get your feelings that are personal and do your task. Correctly! And create the absolute most code that is beautiful ever!

P.S.: I know, I Understand. Life is difficult, there’s absolutely no time. No body would like to spend you for additional time. But commenting your rule is certainly not additional time. Composing paperwork about execution details isn’t more time. It really is an essentialPART of computer software development.

You the time to comment your code, think of a change if you are in a job that doesn’t give.

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 at the Oracle workplace.

Take a look at event details and sign up!

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

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

If you’re in the region you really need to certainly book this.

Quickening APEX Static Application and Workspace Files

A few years back it had been 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 ukrainian girlfriend dating, kept with numerous have been unable to follow due to business limitations: no use of internet host, perhaps maybe not permitted to keep files, way too many laws, and so forth.

Luckily for us APEX 5++ gave us well working Static Application data and Static Workspace data. Now many people are making use of those to keep files that are extra.

Tomcat with ORDS operating APEX behind a reverse proxy

Not long ago we posted helpful information how exactly to create nginx as a reverse proxy right in front of tomcat to operate ORDS and APEX. Look at post right right here.

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

APEX Survey

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

Make use of directory framework as Image Prefix in APEX

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

In 95per cent of all of the instances 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 another thing, now i do want to show another method to manipulate the URL.

I disliked deploying multiple ORDS circumstances, in order to offer various paths to exactly the same DB. This occurred away from legacy or SEO purposes to date.

Now let’s put up a reverse that is simple to produce any URL framework you prefer for the APEX host.

Deploy ORDS on tomcat in a subdirectory

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

What now?, if you prefer an alternative title than ords, let’s say you desire to see “bruce” when you look at the Address? Simple solution: simply rename ords. War to bruce. War before deploying to Tomcat.

Exactly what if you wish to have “mod/plsql“, like in http: //myserver. Tld: 8080/mod/plsql?

Why the Trim Spaces environment on APEX items is essential

Oracle APEX supplies a declarative environment for Text and Textarea what to “Trim Spaces”, which may eliminate leading/trailing areas through the individual input before saving the value to your database.