08:30 Keynote by Joel Kallman
Join Joel when he talks about Oracle Application Express. How it started out and what it became.
Hear about Joel's passion to make customers extraordinarily successful with the Oracle Database, PL/SQL and Oracle Application Express.
09:45 From Python/Postgresql to APEX in the Oracle Cloud
FOEX was running an open source Forum software built with Python and Postgresql for more than 5 years. Since none of our developers had any Python knowledge, any kind of customisation was problematic. Also connecting the forums data to our internal CRM (APEX/Oracle DB) was wished for.
This was when we decided to rebuild the Forum using the tool we know by heart: Oracle APEX.
What started out as a training project for our summer intern turned into a big success. The forum now runs live on our Oracle cloud server at https://forum.tryfoexnow.com and will be open sourced in 2018.
In this session we want you to learn about how we built the forum app, using Quick SQL and APEX, and how data migration from Postgresql to Oracle worked using SQL Developer.
09:45 APEX Shared Components- Revised
In this presentation we will look at features of the APEX Shared Components that we all know but are often overlooked or at least we don’t know all the good stuff about them. We will focus on Global Application Items, new features of Build Options in APEX 5.1, Data Load Definitions, Shortcuts and Text Messages. This presentation is not about basic usage of this features, it is about tips and tricks. We will look at how to overcome limitations when we work with Data Load Definitions, how to combine Shortcuts with Text Messages and also and exciting feature of APEX 5.2 - Authentication Scheme using OAuth2 ( Google, Facebook, …)
10:45 Oracle APEX 5.2 - The Golden Nuggets
Every new APEX Release contains a few major features that everybody talks about. For APEX 5.2 for example this will be Remote SQL Data Access, REST service consumption, the new REST workshop and improvements in the interactive grid.
Many of these features are certainly not talked about enough because they continually increase our productity or make things simply easier ... if and only if you are aware that they exist and how to use them.
In this presentation we will have a close look at the most noteworthy of the smaller new features. Certainly we will see hands on demos and the full demo application will be provided as a download.
10:45 APEX Nitro - Your essential APEX companion
APEX community is full of great open source products. One of them is APEX Nitro - must have for every APEX project. It's the tool that will boost your productivity and make JS and CSS coding faster and easier than ever. Also, it will speed up your apps because of file compression.
In this session, you'll learn how to install it and how to use all of its cool features, like:
- Device synchronization
- CSS and JS file compression
- File merging
- File uploads to APEX
- Handling JS and CSS errors
- And a lot more…
11:45 Managing your REST APIs - From Spec to Code and Back
Being able to provide RESTful interfaces to our data has become a common requirement and we as APEX developers certainly have to deal with it, too.
But how can we provide these interface and manage them over time? How can we deal with changes in the APIs, support multiple versions of the API? How does that impact our deployment to the production system?
The Open API Initiative (OAI) provides an open specification, originally known as the Swagger specification, for describing and documenting REST APIs. From version 17.4 onward, Oracle REST Data Services (ORDS) exposes the metadata of specific web services in Open API 2.0 format, making it easy to document and generate calling code for REST APIs using Swagger.
In this presentation we will cover a design-first approach in which we start by designing the API based on Swagger / Open API 2.0. From that definition we will then generate the actual implementation using Oracle REST Data Services (ORDS).
We will also cover a full roundtrip by reverse engineering a modified implementation in the database and generate the swagger definition from that.
This approach makes really sense for two reasons. Firstly we have a long-term focus in mind when designing the APIs. We begin with the documentation and generate the code from that.
Secondly we can always go back and reverse engineer the swagger definition of the RESTful service since ORDS will support that. This is just what happens in real life and also good to easily document your existing RESTful services.
11:45 Dockerizing Oracle Database
You are new to Docker or want to learn more about it? Then this session is right for you! You will learn how to install Docker, create an Oracle image and run Oracle Databases inside a container.
12:45 Structuring an APEX application
Creating beautiful applications with APEX is easy, especially after the introduction of Universal Theme.
It is easy to follow the wizards and drop SQL and PL/SQL all over the place in your application thereby creating a maintenance nightmare. When a table is changed, which pages are affected? How can you easily find out?
Getting the structure of your application right requires a method to follow. In this session I will share my thoughts on structuring your APEX application.
This session will focus on just that: build robust applications; leverage views, packages, instrumentation, etc.
12:45 Alexa, what about APEX?
Voice assistants like Amazon Echo with Alexa becoming more and more attractive and usable. Since Amazon marketing almost gave Echo Dots away like free gifts a lot of people have such assistants at home.
But what about using Alexa in the company or enterprise? How could such a voice assistant be integrated inside of my business applications and what can be the benefit doing it?
This talk is supposed to bring light into the dark, so attendees will learn how an Alexa Skill will work and how to put the different components like Alexa Skill, RESTful Services, Web Sockets, Amazon Lambda Functions and of course the integration into an APEX app, together.
13:30 Lunch Break
Enjoy your lunch !
14:15 Continuous Integration and Testing with APEX
Continuous Integration and Testing is a hot topic right now, in this session I will show how you can configure your Development environment to get the benefits of a Continuous Integration and Testing metholodology.
Why would you want to do this? Simple - to make our lives as developers less stressful. We will gain confidence in our releases and streamline the deployment process.
14:15 Exploring the details of APEX sessions
A session is one of the main features of APEX. It established a stateful behavior across pages for each user. Usually, we take a session for granted but knowing how sessions work in detail can be of great use when debugging errors. How does APEX secure and validate a session and its items? We will see what happens between creation and destruction of a session and how you can interact with it.
There are some important differences when assigning a value to an item via Automatic Row Fetch, Computation, Source or Default value. We all struggle with these things from time to time. And what happens exactly when you submit a page for page processing?
Ever heard about a 32k limitation in APEX? We’ll go into detail to clear out the exact problem and how to deal with CLOBs.
The latest APEX releases have introduced additional features like asynchronous page submits, rejoin session and session cloning. We’ll take a look at how these things work and what the possible consequences are for our applications.
This presentation will be of value for both beginners and experienced APEX developers.
15:15 Oracle JET: No Slides, Just Code!
15:15 Integration of OpenLayers into APEX - a hands-on example
In this presentation, Andreas Hocevar, a main contributor and developer of OpenLayers, will give an introduction to its architecture and features.
Christian Klingbacher will then demonstrate, by a hands-on example, how fast and easy this library can be integrated into an APEX application. Furthermore, he will show the integration of OpenLayers into a real life application where geospatial data is not only displayed, but where searching, drawing, routing, measuring, and dynamic changes on the map are possible - all of this by using either Bing Maps, HERE, or OpenStreetMaps.
16:15 Building an Image library for an International Organisation
This case study will describe the approach and challenges faced when overhauling a 14-year old image library of over 40’000 photos. The new version was developed using Oracle APEX 5.1, Oracle Multimedia and PL/SQL. Issues addressed include: automatic extraction of image metadata to facilitate searches and image description; automatic resizing of images using Oracle Multimedia; customization of APEX reports to produce a modern presentation format for the photo library.
16:15 Plugins Unplugged - Revised
Oracle Application Express enables developers to build data-centric web applications declaratively, meaning, you can build feature rich applications, running in web browsers. But APEX declarative functionality is limited, not providing the full capabilities of what is possible with web technologies these days. And, let’s admit, not all developers are able (yet) to easily integrate these capabilities in APEX.
Unplug yourself from APEX’s declarative limits
This session will start with some fundamental Plugin basics to start with and accelerate to more advanced techniques, which will help you to kick-start your own Plugin development.
Additionally, this presentation will cover the recent changes of the plug-in framework since APEX version 5.
17:15 Insider News from the APEX Development Lab
Join Patrick Wolf and Joel Kallman to hear about the current and planned enhancements of Oracle Application Express.
Take the opportunity to get insider information and a first look at the new features of the upcoming Oracle APEX 5.2 from one of the core developers of Application Express. See it live how easy, seamless and how quick it will be to integrate remote data sources like REST services and Remote SQL into your own application. With the new chart types, it will be even easier to visualize that data. I will also show you the new Create Application wizard which allows to create beautiful applications in no-time. In addition, you will get an outlook what we plan after APEX 5.2.
18:00 Drinks and Fingerfood
Refresh after a long study day and enjoy a refreshment and some snacks. But still talk APEX :-)
Get some more food and dance it off!