{"id":24951,"date":"2023-05-03T19:13:34","date_gmt":"2023-05-03T17:13:34","guid":{"rendered":"https:\/\/www.dbi-services.com\/blog\/?p=24951"},"modified":"2023-06-12T10:06:54","modified_gmt":"2023-06-12T08:06:54","slug":"apex-connect-2023-day-1","status":"publish","type":"post","link":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/","title":{"rendered":"APEX Connect 2023 (Day 1)"},"content":{"rendered":"\n
\n
\"\"<\/figure>\n\n\n\n
\"\"<\/figure>\n<\/figure>\n\n\n\n

This year again the APEX connect conference spans over two days onsite in Berlin, with mixed topics around APEX, like JavaScript, PL\/SQL and much more.
After the welcome speech and the Keynote about “22.2, 23.1, and beyond” by the Oracle APEX Team, I decided to attend presentations on following topics:
\u2013 How should we design a database? You decide!
\u2013 IoT and APEX to reduce gas
\u2013 Automated APEX application deployment with Liquibase and Jenkins
\u2013 Low Code Testing (LCT) Testing APEX apps is just as easy as creating them
\u2013 Templates – Next Generation: Dynamic Templates in 23.1
\u2013 Multi language application in APEX – really ease?<\/p>\n\n\n\n

I also had the chance to give some presentation about ORDS 22.x and the changes it introduces.<\/p>\n\n\n\n

22.2, 23.1, and beyond:<\/h3>\n\n\n\n

The APEX Team was growing very fast lately (with taking over FOEX<\/a> for example) to be more than 80 people now. This shows that APEX is on the heart of Oracle strategy, also internally for the Global Business Units (GBO).
A quick overview of APEX 22.2 new features was given but more interesting, details about APEX 23.1 new features which are not yet available for download:
– Declarative push notifications
– Template components
– Refreshed Object Browser
– SQL Developer Web integration
– Refreshed items (Rich Text Editor, Color Picker)
– Administrator Diggest
– REST Source discovery based on Swagger\/Open AI
– Invoke API for REST Data Sources
– Background execution of Page Processes
It all looks promising and I’m looking forward for it to being released outside of apex.oracle.com<\/a><\/p>\n\n\n\n

How should we design a database? You decide!<\/h3>\n\n\n\n

We the example of creating an application to manage international games with the final target to show some league results, based on 2 tables (country, games) some design decisions had to be made and consequences were analyzed.
Outcome:
– Use natural keys (like ISO country code) only when codes are standardized. If not use surrogate keys.
– Use check constraints if fixed and small number of values. For all other cases use lookup tables.
– Use columns to store limited number of data of same type related to main entry (e.g. score). For other cases use a separate table.
– Use NULL when no data is stored rather than a default value which could be a valid data for final result (i.e. 0 for the score until the game was played).
In order to eas developer’s work, design guidelines should be created. SQL Developer Data Modeler can be used with Design Rules feature, to do so.<\/p>\n\n\n\n

IoT and APEX to reduce gas<\/h3>\n\n\n\n

With expanding CO2 emissions, we need to reconsider our way of consuming fossil energies. The war in Ukraine and the impact it has on the gas price makes it visible on the bill also.
Analog gas counters are using magnets to show progress which can be used to add IoT based detection and turn it into digital equipments with traceability features. Thanks to magnet sensor coupled with Raspberry pi pico and some Python software consumption data can be exported in csv files.
Those csv files can then be imported into an APEX application which is used to do some dashboarding and cost analysis quite easily.
This way some experiments can be done on the heating settings to see how best savings can be done.<\/p>\n\n\n\n

Automated APEX application deployment with Liquibase and Jenkins<\/h3>\n\n\n\n

Liquibase<\/a> allows to manage and track deployments on databases based on Change Logs and Change Sets. Structure of scripts used to do the changes must be adapted with for example:
– Pre DDL
– DDL
– Post DDL
scripts to cover all aspects.
Beside the DB code, APEX application code can be managed in GIT and commit to master branch used to trigger deployment with Jenkins<\/a>.
The link between GIT and Jenkins can be done over web hook based on some specific plugins.
Authentication needs to be managed carefully as changes might be required on different databases within the same release.<\/p>\n\n\n\n

Low Code Testing (LCT) Testing APEX apps is just as easy as creating them<\/h3>\n\n\n\n

LCT<\/a> is a tool developed in APEX to test APEX applications.
The tool is managing test cases within Worksheets and Test Suites where the definitions are based on the APEX metadata, which makes it very intuitive.
It is only testing the UI, not the PL\/SQL code.
Compared to other testing tools, it is able to handle the context of modal pages and record all states of the application during the test run for later analysis.
Based on Docker containers, it’s footprint is rather small for simple applications. But it also allows to scale up easily to up to 256 containers if required for big applications and multiple parallel testings. It is worth have a look into it if you want to do automated testing of your APEX application.<\/p>\n\n\n\n

Templates – Next Generation: Dynamic Templates in 23.1<\/h3>\n\n\n\n

With APEX 23.1, a new plugin type was introduced: Template components
It supports template directives, CSS, JavaScript, declarative images and CLOB.
It can be used as:
– Partial region
– Report region
– Interactive Report column
Most of it’s setup is declarative which doesn’t require any PL\/SQL and almost no JavaScript, depending how far you want to personalize it.
Some new APPLY WITH feature even allows to combine different plugins within themselves, which makes it even more powerful.<\/p>\n\n\n\n

Multi language application in APEX – really ease?<\/h3>\n\n\n\n

APEX is supporting multi language applications. It is based on translations of the text found in the application but this excludes any data in LOVs or Read Only items. So that multi language should be integrated in the tables design (at least for lookup tables).
APEX allows to export the static text to be translated in XLIF format so it can be given to a specialized service for processing. But, NO CHANGE must be done to the APEX application while the translation file is processed, unless issues will show-up when the translated text will be imported again.
Multi language applications are not that strait forward and require some design thoughts from the beginning and attention during development.<\/p>\n","protected":false},"excerpt":{"rendered":"

This year again the APEX connect conference spans over two days onsite in Berlin, with mixed topics around APEX, like JavaScript, PL\/SQL and much more.After the welcome speech and the Keynote about “22.2, 23.1, and beyond” by the Oracle APEX Team, I decided to attend presentations on following topics:\u2013 How should we design a database? […]<\/p>\n","protected":false},"author":17,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[368],"tags":[304,2955,96,1352],"type_dbi":[2956],"class_list":["post-24951","post","type-post","status-publish","format-standard","hentry","category-development-performance","tag-apex","tag-apex-connect","tag-oracle","tag-ords","type-apexconnect"],"acf":[],"yoast_head":"\nAPEX Connect 2023 (Day 1) - dbi Blog<\/title>\n<meta name=\"description\" content=\"Oracle APEX connect conference is running in Berlin for the third time, over 2 years. Providing technical insight to developers.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"APEX Connect 2023 (Day 1)\" \/>\n<meta property=\"og:description\" content=\"Oracle APEX connect conference is running in Berlin for the third time, over 2 years. Providing technical insight to developers.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\" \/>\n<meta property=\"og:site_name\" content=\"dbi Blog\" \/>\n<meta property=\"article:published_time\" content=\"2023-05-03T17:13:34+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-06-12T08:06:54+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg\" \/>\n<meta name=\"author\" content=\"Alain Lacour\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Alain Lacour\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\"},\"author\":{\"name\":\"Alain Lacour\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"headline\":\"APEX Connect 2023 (Day 1)\",\"datePublished\":\"2023-05-03T17:13:34+00:00\",\"dateModified\":\"2023-06-12T08:06:54+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\"},\"wordCount\":997,\"commentCount\":0,\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg\",\"keywords\":[\"APEX\",\"APEX connect\",\"Oracle\",\"ORDS\"],\"articleSection\":[\"Development & Performance\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\",\"name\":\"APEX Connect 2023 (Day 1) - dbi Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg\",\"datePublished\":\"2023-05-03T17:13:34+00:00\",\"dateModified\":\"2023-06-12T08:06:54+00:00\",\"author\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\"},\"description\":\"Oracle APEX connect conference is running in Berlin for the third time, over 2 years. Providing technical insight to developers.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg\",\"contentUrl\":\"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/www.dbi-services.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"APEX Connect 2023 (Day 1)\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#website\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/\",\"name\":\"dbi Blog\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0\",\"name\":\"Alain Lacour\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g\",\"caption\":\"Alain Lacour\"},\"description\":\"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.\",\"url\":\"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"APEX Connect 2023 (Day 1) - dbi Blog","description":"Oracle APEX connect conference is running in Berlin for the third time, over 2 years. Providing technical insight to developers.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/","og_locale":"en_US","og_type":"article","og_title":"APEX Connect 2023 (Day 1)","og_description":"Oracle APEX connect conference is running in Berlin for the third time, over 2 years. Providing technical insight to developers.","og_url":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/","og_site_name":"dbi Blog","article_published_time":"2023-05-03T17:13:34+00:00","article_modified_time":"2023-06-12T08:06:54+00:00","og_image":[{"url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg","type":"","width":"","height":""}],"author":"Alain Lacour","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Alain Lacour","Est. reading time":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#article","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/"},"author":{"name":"Alain Lacour","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"headline":"APEX Connect 2023 (Day 1)","datePublished":"2023-05-03T17:13:34+00:00","dateModified":"2023-06-12T08:06:54+00:00","mainEntityOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/"},"wordCount":997,"commentCount":0,"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg","keywords":["APEX","APEX connect","Oracle","ORDS"],"articleSection":["Development & Performance"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/","url":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/","name":"APEX Connect 2023 (Day 1) - dbi Blog","isPartOf":{"@id":"https:\/\/www.dbi-services.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage"},"image":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage"},"thumbnailUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg","datePublished":"2023-05-03T17:13:34+00:00","dateModified":"2023-06-12T08:06:54+00:00","author":{"@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0"},"description":"Oracle APEX connect conference is running in Berlin for the third time, over 2 years. Providing technical insight to developers.","breadcrumb":{"@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#primaryimage","url":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg","contentUrl":"https:\/\/www.dbi-services.com\/blog\/wp-content\/uploads\/sites\/2\/2023\/05\/IMG_5334-1-1024x768.jpeg"},{"@type":"BreadcrumbList","@id":"https:\/\/www.dbi-services.com\/blog\/apex-connect-2023-day-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/www.dbi-services.com\/blog\/"},{"@type":"ListItem","position":2,"name":"APEX Connect 2023 (Day 1)"}]},{"@type":"WebSite","@id":"https:\/\/www.dbi-services.com\/blog\/#website","url":"https:\/\/www.dbi-services.com\/blog\/","name":"dbi Blog","description":"","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.dbi-services.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.dbi-services.com\/blog\/#\/schema\/person\/acabba2b6ca473b44b098c2de61294b0","name":"Alain Lacour","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/455c4c7743e192ae868a6f9e6ed875415c5887567577eccbbbf2d65012cd976a?s=96&d=mm&r=g","caption":"Alain Lacour"},"description":"Alain Lacour has more than 15 years of experience in application development with Oracle technologies. He is specialized in APEX, Java, and PL\/SQL development. His expertise also includes middleware technologies such as Oracle Weblogic and EMC Documentum. He also has a broad experience in business analysis and architecture solutions as well as in service and project management. Prior to dbi services, Alain Lacour was Senior Consultant at IMS Health in Basel. He also worked as a Software Engineer for M&H Informatics in Basel. Alain Lacour holds a Master of Science in Industrial Computing from the University of Mulhouse (F). His branch-related experience mainly covers the pharma industry, with an in-depth knowledge of the drug development process as well as drug distribution.","url":"https:\/\/www.dbi-services.com\/blog\/author\/alain-lacour\/"}]}},"_links":{"self":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24951","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/users\/17"}],"replies":[{"embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/comments?post=24951"}],"version-history":[{"count":6,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24951\/revisions"}],"predecessor-version":[{"id":24960,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/posts\/24951\/revisions\/24960"}],"wp:attachment":[{"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/media?parent=24951"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/categories?post=24951"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/tags?post=24951"},{"taxonomy":"type","embeddable":true,"href":"https:\/\/www.dbi-services.com\/blog\/wp-json\/wp\/v2\/type_dbi?post=24951"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}