Category Archives: APEX

Having a little fun with Wordle

Posted on by
Reply

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.

Continue reading →

Differences between APEX 20.2 and 21.1

Posted on by
Reply

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.

Continue reading →

Speeding up APEX Static Application and Workspace Files

Posted on by
4

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.

Continue reading →

Behind the scenes of an all APEX organized conference

Posted on by
1

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.

Continue reading →

Translating User Agent Strings

Posted on by
Reply

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

Continue reading →

Streaming flat File data into Database

Posted on by
8

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:

Continue reading →

New APEX conference: APEX Alpe Adria

Posted on by
Reply

During the recent SIOUG and HrOUG conferences past October, my friends Dario Bilić, Aljaž Mali and Dietmar Gabauer had a great Idea: why not establish a proper APEX conference for our neighborly region?

As soon as Dietmar returned to our office after the conferences, we set up a meeting with Dario and Aljaž and instantly agreed that we want to do this.

Our goal is to have a first class APEX conference, with top speakers from abroad and from the neighborhood. All that for a minimum cost. This conference should be accessible for every APEX fan in the region, even if they are not sponsored by their respective bosses and pay everything out of their own pocket.

There it is: April 20, 2018, will feature the first APEX Alpe Adria conference in Graz, Austria.

We picked Graz as first location as it is fairly easy to reach from a number of surrounding countries. So no matter if you want to come by plane, train, bus, or car, everyone will be able to get a connection.

Call for Papers is still open until January 9th, but we already pre-confirmed two top speakers: Patrick Wolf and Joel Kallman from the Oracle APEX Development Team.

I want to encourage all APEX speakers from anywhere in or around the Adriatic region to submit an abstract to this conference. Together we can provide a fantastic lineup and and interesting program.
We would like to see submissions from Italy, Slovenia, Croatia, Hungary, Serbia, Austria, Bosnia, Switzerland, and everyone else who wants to visit a beautiful town and be part of the best APEX conference in the region.

Lots of fun, a great community and new friends are guaranteed.

Did I mention the low cost of just EUR 30,- for the Early Bird tickets? Go and get your ticket right now, there is a limited number available.