Advent of Code 2023 in Oracle SQL and PL/SQL. Day 1 and 2.
A preview version of Oracle APEX 23.2 just got released on apex.oracle.com. Let's take a look at the new workflow feature.
Web Components make it easy to create custom JavaScript-heavy components and integrate well into Oracle APEX.
View Transitions allow you to animate page transitions. This makes the UI more polished and engaging.
Learn step-by-step how Web Components work and how to use them. Including HTML templates, custom elements, shadow DOM, attributes, properties, and slots.
Share your Template Components with the community and win great prizes.
APEX Text Messages is a powerful feature to organize reusable and translatable text fragments. You can use them in PL/SQL, JavaScript, and Substitution Strings.
I released the third beta release of the AG-Grid plug-in for Oracle APEX. Find out what's new and how to get it.
In this series, we develop an offline-capable SvelteKit application utilizing SQLite as a client-side storage solution. In this part, we optimize the communication between the main thread and the Web Worker and create the client data tables.
The most exciting feature in APEX 23.1 for me is Template Components. Find out what they are and how to use them.
In this series, we develop an offline-capable SvelteKit application utilizing SQLite as a client-side storage solution. In this part, we explore how to set up the database effectively.
In this post, we will learn how to upload, store and retrieve images in a SvelteKit application with SQLite.
In this post, we look into how we can build our own Authentication and Authorization solution for SvelteKit. We will store and hash user credentials, create sessions with Cookies, and make the session info available to the app through hooks and locals.
SvelteKit and SQLite are a great combo as they are both lightweight and easy to use, making it simple to build high-performance, data-driven web applications.
My solution for the tenth day of the Advent of Code 2022 challenge "Cathode-Ray Tube" with Oracle. We simulate a CPU and a Pixel-Screen in pure SQL!
My solution for the seventh day of the Advent of Code 2022 challenge "No Space Left On Device" with Oracle. Today with a tree (not for christmas)...
My solution for the fifth day of the Advent of Code 2022 challenge "Supply Stacks" with Oracle. Its starting to get complex...
My solution for the third day of the Advent of Code 2022 challenge "Rucksack Reorganization" with Oracle. Its starting to get complex...
My solution for the second day of the Advent of Code 2022 challenge "Rock Paper Scissors" with Oracle. This time in pure SQL.
My solution for the first day of Advent of Code 2022 challenge "Calorie Counting" with Oracle.
How to create anchored popups in Oracle APEX that are positioned close to the button that triggers it. They offer a nice UX for quick data input.
Second beta release of the AG-Grid plug-in for Oracle APEX. Find out what's new and how to get it.
APEX_T_VARCHAR2 is a database type that comes with an Oracle APEX installation. I use it quite frequently and think that with it you can write better code.
I created a workflow to open VSCode workspaces for the macOS search tool Alfred quickly. It supports local and remote repositories.
APEX 22.1 changed a lot to the actions interface and added a new method with which we can call them easily from links.
Maps (not cartography but the data store) are a powerful tool for storing and accessing data in memory. In Oracle PL/SQL they are available too under the name Associative Arrays.