apex track

V povezavi z APEX-om je verjetno trenutno najbolj aktualno vprašanje, kdaj bo na voljo APEX verzije 5.1. Glede datuma lahko seveda samo ugibamo. Kar pa lahko je gotovo, pa je to da bo SIOUG 2016 prinesel veliko svežih informacij tudi o tej verziji. Letošnje leto se bo SIOUG 2016 dogodka, kot predavatelj med drugimi udeležil tudi Patrick Wolf, ki je eden glavih razvijalcev samega APEX-a.

Poleg Patricka Wolfa, bodo svoje prispevke predstavili še Oracle ACE direktorja Dimitri Gielis in Alex Nuijten, Oracle ACE Richard Martens ter drugi predavatelji med katerimi Marko Gorički, Gregor Malenšek in Aljaž Mali. Kot že omenjeno bo najbolj izpostavljena tema APEX 5.1, predstavljene bodo tudi druge teme in sicer varnost v APEX-u, povezovanja z APEX-a z drugimi sistemi, strukturiranje APEX aplikacij, ...

Z nami bodo torej predavatelji, ki imajo res dolgoletne izkušnje in ti predavatelji bodo svoje znanje z veseljem delili z vami.

Abstract:

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.

Abstract:

The Model Clause adds spreadsheet-like functionality to the SQL language. Very powerful stuff, yet the syntax can be quite daunting. With the Model Clause, you define a multidimensional array from query results and then apply formulas to this array to calculate new values. This presentation will give you a gentle introduction in the complex syntax of the Model Clause and will show you some real life examples where the Model Clause was invaluable.

Abstract:

Apex offers several ways to validate user input. This session shows ways to do just that bit extra to make your application fool proof yet keeping it user friendly. After the session you’ll know how to do server side validation, database validation and client-side validation while helping your users submit good data.

1. Apex validations

2. Database constraints and validations

3. Client side validations in apex

3.1 Client side using dynamic actions

3.2 Client side validation using parsley library

Abstract:

Authentication and Authorization do not need an introduction. But how nice would it be to have a standard implementation from which you can start building your own application? The presentation introduces a barebone application that has a flexible authentication and authorization already built in. It is inspired by the security part of the presentation "5 Lifehacks for the Apex Development environment" given by Oracle employee Koen Lostrie at Apex World in March 2016.

1. The authentication scheme

1.1 Using external authentication schemes (ie the Google Authentication plugin)

2. The authorization scheme

3. Users and Roles

3.1 Creating a new user

3.2 Creating a new role

4. Applying a role to the authorization scheme

Abstract:

With all daily responsibilities, tight schedule and short deadlines we are often not able to explore all the options and a new features that our development tool provides us with. APEX can give us a lot in a short time with just a little bit of experience and knowledge, but there are many options that can speed up the development and runtime of our applications.

In this presentation I’ll cover a series of short tips and tricks that are mostly unknown to developers, regardless of their experience.

Abstract:

In this session I will show the integration of APEX 5.0 and different types of Maps (Google, Here, Open Street Maps). The goal is to show the best practices in integrating Maps in APEX regarding coding, performance and usability.

Abstract:

Universal Theme offers a high grade of customizing and a lots of declarative options to fulfill special requirements. In this session I will show how to customize Universal Theme to the needs of a corporate layout without jeopardizing upgrade compatibility of APEX.

Abstract:

While APEX 5.0 was primarily focused on developer productivity and creating modern user interfaces, APEX 5.1 will be a huge leap in end user productivity. See how the Interactive Grid will bring dynamic, rich-client reporting and multi-row editing capabilities to your APEX applications and how the new, powerful charting engine - based on Oracle’s own JavaScript Extension Toolkit (Oracle JET) - will enable your users to visualize and interact with their data like never before. We’ll also take an in-depth look at numerous other enhancements, such as the new Live Template Options, support for Right-To-Left languages, the future of Page Designer with the integrated Component View and many more. This is part 1 / part 2 of a two-hour in-depth session and live demonstration of the new features introduced with APEX 5.1.

Abstract:

While APEX 5.0 was primarily focused on developer productivity and creating modern user interfaces, APEX 5.1 will be a huge leap in end user productivity. See how the Interactive Grid will bring dynamic, rich-client reporting and multi-row editing capabilities to your APEX applications and how the new, powerful charting engine - based on Oracle’s own JavaScript Extension Toolkit (Oracle JET) - will enable your users to visualize and interact with their data like never before. We’ll also take an in-depth look at numerous other enhancements, such as the new Live Template Options, support for Right-To-Left languages, the future of Page Designer with the integrated Component View and many more. This is part 2 / part 2 of a two-hour in-depth session and live demonstration of the new features introduced with APEX 5.1.

Abstract

When we check Oracle Application Express documentation in chapter Managing Application Security, we can read this : "Administrators are primarily responsible for ensuring the security of the Oracle Application Express installation, while developers are responsible for building secure applications". Just based on this sentence we can see that APEX security is multi role topic. APEX administrator is responsible (hopefully communicating that with developers) for various instance security setting and enabling and disabling APEX features. APEX developer is responsible for building secure applications and this means far more then just set up authorization and authentication. Regardless of the security settings if a developer will not watch for things like SQL injection and Cross-site scripting an application will not be secure. And we must not forget (and this can be easily overlooked) if we are using ORDS we also need to properly set this component.

It this 3 time 45 minutes presentation we will address this issues and we will show with practical examples how set up environment and how to build a secure APEX application.

Abstract:

V predavanju bom predstavil različne strategije uporabe Jave v odvisnosti od tehnologije, potreb in željenega rezultata. Predvsem bo poudarek na tehnologijah, katerih primarni programski jezik ni Java. Zato bomo pogledali na Javo kot integracijsko orodje in kot dodatek za obogatitev uporabniške izkušnje. Tako se bomo osredotočili na Oracle APEX, Oracle Forms&Reports in Oracle bazo. Predstavil bom različne možnosti uporabe Jave na praktičnih primerih. Pogledali si bomo tudi argumente za in proti uporabi jave v teh okoljih, kje so pasti in kaj prinaša prihodnost.

Abstract:

An often overlooked functionality when writing Oracle database code is instrumentation. With instrumentation it is possible to see after the production code has been executed which codepath was taken and which arguments are passed along. Instrumentation is, unfortunately, not used very often and missed when an application goes into production. Writing your own instrumentation code starts easy, but quickly extra features are requested to expand the functionality. A popular framework called Logger, actively maintained on GitHub, which offers a lot of features out of the box.

This session will introduce instrumentation to the delegates, as well as show various aspects of Logger and LoggerUtil to increase the uptake of using instrumentation.