Skip to main content

My two cents on low code and APEX

Today was (again) a nice day. A sunny day with almost 20 degrees (Celsius), no clouds and just the right amount of wind. Perfect conditions to do some paragliding and after the flight, a cold beer with a friend. 

But there was something else that made my day. It was something that happened in the office. Today we got a visit from a young 18 years old future student. Next year he will go to college and he is still not sure which one or which direction. But he said, he is interested in programming and that is why I invited him to visit us. 

We started talking, and it went like this: 


Me: Do you know Oracle or databases.

Him: no

Me: OK, do you know anything about APEX

Him; no

Me: OK, what about PL/SQL, SQL, Java, ...

Him: no


And I thought to my self, this is perfect! My next question was: Do you know anything about ER diagrams? The answer was...No. And I thought to my self, even better...let's try to teach him and see how fast he can learn and even more important if he will understand the logic. 

So I started: Let's say we have departments and employees...I know this was a big gamble, talking about departments and employees to someone who is 18! Luckily he did not run away. We started to draw squares and connecting them with lines ( crows feet ). I could just see that he was following and in a few minutes he already extended the ER with new entities (posts,...). Great, he can learn fast and he can also understand the design. 

The next step, create tables. For someone who does not know Oracle or in this case even databases, this is a problem. For a smart kid like him, that is not a problem, but again it would take some time to learn.

But luckily we are working with APEX and part of APEX is Quick SQL. First things first! We need an environment where he will work. apex.oracle.com to the rescue and in under 5 minutes we were already in Quick SQL in the newly created workspace. First 10 minutes in Quick SQL I explained the basics of constraints, data types, not nulls and foreign keys. It was just to connect what he already learned when drawing the ER diagram. Then I asked him to describe to me the database model and we have used this for Quick SQL...automagically code was generated on the fly. He did not know a single thing about Oracle and yet he was able to create tables ( physical model ). 

You can image what happened next. We run the script and based on the script we created the APEX application (we all know how that goes). His words were, OK this is cool!

If I just compare this to how it was 20 years ago when I started to work with Oracle!

My main point of this blog post is not that someone can learn to be a developer in 2 hours. It will take a lot more than that. But today with the low code approach, with Quick SQL and APEX we have the option to show how interesting it can be to develop applications. Like this bright kid, he was able to build something useful really fast. We already agreed on the next steps which will include more details...and hopefully someday we will have a new bright APEX developer.

And to that I say, cheers (with the cold beer after the flight) !


Aljaž



Popular posts from this blog

Change image prefix when using ORDS in standalone mode

In Oracle Application Express we can specify instance wide image prefix ( we provide this when installing APEX or later if we run apex/utilities/reset_image_prefix.sql ). Purpose of this blog post in not to explain what image prefix is, but if you would like to know more about it, then I recommend that you read a blog post from Joel Kallman - Image Prefix changes in Oracle Application Express 4.2.2 My blog post is about what we need to do, if we are changing image prefix and at the same time we are using Oracle REST Data Services (ORDS) in standalone mode . If we need to change image prefix, first thing is to run apex/utilities/reset_image_prefix.sql script and here we specify new image prefix - for example /i_test/ After this change when accessing APEX login page we will see this warning: I find this warning very useful. It's telling us that we have to verify that we have copied images directory to right location and also that our new path is /i_test/ . In case w

New Look & Feel for Radio Group in Oracle Application Express 5.1

With Oracle Application Express version 5.1 we are getting lots of new features. Among most notable or exposed are for sure Interactive Grids, JET Charts and Live Template Options. But we can also find some smaller (and really nice) enhancements. One of this is new look and feel of Radio Group item. We can spot this for example when we use Create New Page wizard in Page Designer: So what do we need to do, if we want to have this look and feel in our applications. Just adding combo box item to our page is not enough, it will have the same effect as in version 5.0. It will look like this : Basically we need to change three things. Number of Columns: should match number of elements in group or you can also set it to some bigger value (for example 100) Display Null Value: NO  Template Option -> Region Group Display: Display as Pill Button After this three small changes we now have new look and feel for our radio group: For me personally the s

Fixing Skillbuilders Super LOV (v3) in APEX 5.1

We have already migrated some of the existing applications to a new version of Oracle Application Express - 5.1. After few weeks in production I can just say...do it :). But when doing an upgrade there is always a possibility that you will hit some issues. For me one of the issue was Skillbuilders Super LOV (v3), and it looks like I'm not alone ( https://community.oracle.com/thread/4010580 ) So what is the issue?  When you select a value (Super LOV item) and try to save a form then the value is not submitted. Now if you are lucky, then your item is mandatory and you will see the error - end users will tell you right away that something is not working. If your item is not mandatory then you might see this error much later, with complaints that some data is not saved correctly. Value is selected After submit, value is cleared and we see an error After a bit of research I have found a quick fix, that you can use, until the plugin is fixed by original authors. Wh