I was able to stay away from socially hyped Wordle for a long time, but recently started to take a look at it. Despite my hesitation it is a great game and I really like it.
If it weren’t for my limited english skills and a profound lack of vocabulary. Just to come up with any 5-letter word was a challenging task, not to speak of finding THE right word.
So I set out to search for sites showing lists of words, which there are many around. Unfortunately none of those lists provided all the features I wanted for filtering: get me all words with an “A” on second position and a “Y” anywhere but not on position 2+3.
A long list of words and a need for filtering? That sounded like a perfect opportunity to build an APEX application to help me there.
Oracle APEX 21.1.0 was released on May 12, 2021.
Here is the shortcut link to the download: apex.oracle.com/download/ and don’t forget to apply the Patch Set Bundle for Oracle APEX 21.1
As you already know from my previous comparison posts (e.g. this one), I always start by looking at the changes on APEX View’s and API’s. This will reveal all the important fundamental changes.
Of course we won’t catch UI changes this way, but most features are based on Metadata/View/API changes, so this approach will give us a good overview of changes.
Quick Note: this Friday, October 4th 2019, will be a morning event about extending Oracle APEX with Single Page Applications, Master-Detail, and Drag&Drop. In Vienna at the Oracle office.
Check out the event details and sign up!
Reserve a free spot in our AOP Introduction training, on November 8th 2019 in Vienna/Austria.
We invited Sunil Tandan from the APEX Office Print Team, to give a halfday intro training to everyone who is interested (and fits the room).
If you are in the area you should definitely book this.
A few years ago it was deemed state-of-the-art to store any kind of extra resources (images, css/js-files) directly on the webserver.
Of course this was just the best-practice, left with many who were not able to follow because of company restrictions: no access to web server, not allowed to store files, too many regulations, and so on.
Luckily APEX 5++ gave us nicely working Static Application Files and Static Workspace Files. Now everyone is using those to store extra files.
A while ago I posted a guide how to set up nginx as a reverse proxy in front of tomcat to run ORDS and APEX. See the post here.
An open problem was that APEX was still thinking it runs on port 80 with http, while nginx was running https on port 443.
As a big fan of APEX Packaged Applications I always wanted to have a real life usecase for the Survey Builder.
Recently we held the very first edition of the “APEX Alpe Adria” conference in Graz, Austria (see this old post about how it started). This conference is meant for everyone in the Adriatic Region, and everyone willing to travel there.
With more than 180 attendees it was a huge success for the first edition. Today I want to share how we managed the conference, website, call for papers, selection, name tags, and so on.
Hint: With Oracle APEX you can do just about everything.
For the Analyse Webserver Logfile Application (AWL) I wanted to show better information instead of just the Useragent String, because they are a mess and contain confusing information.
As an example look at this Useragent String: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_12_5) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/59.0.3071.109 Safari/537.36
I rather would want to show it like this: Chrome (59) OS X
For my little Webserver Logfile Analysis project I had to solve the problem of how to stream data from a flat file into a relational datamodel in my target database.
Since I used NodeJS in several projects over the past years, it came to my mind at first. On a second thought and by consulting some friends another, easier, solution materialized: