Philipp Hartenfeller's Blog
Advent of Code 2023 in Oracle - Day 1 and 2
Advent of Code 2023 in Oracle SQL and PL/SQL. Day 1 and 2.
Oracle APEX 23.2 Workflows: A First Look
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.
Oracle APEX Template Components with Web Components #JoelKallmanDay
View Transitions in Oracle APEX
View Transitions allow you to animate page transitions. This makes the UI more polished and engaging.
Mastering Web Components: A Comprehensive Step-by-Step Guide
Learn step-by-step how Web Components work and how to use them. Including HTML templates, custom elements, shadow DOM, attributes, properties, and slots.
APEX Template Component Competition is live now
Share your Template Components with the community and win great prizes.
Reusable, and Translatable: Oracle APEX Text Messages
Oracle APEX AG-Grid Plug-In 0.3 (beta)
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.
Creating an Offline-Ready SvelteKit Application Using SQLite (Part 2): Messaging and Client Tables
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.
Introduction to Template Components in Oracle APEX 23.1
The most exciting feature in APEX 23.1 for me is Template Components. Find out what they are and how to use them.
Creating an Offline-Ready SvelteKit Application Using SQLite (Part 1): Setting up the Database
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.
SvelteKit with SQLite: Uploading, Storing and Retrieving Images
In this post, we will learn how to upload, store and retrieve images in a SvelteKit application with SQLite.
DIY Authentication and Authorization in SvelteKit 1 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.
Advent of Code 2022 in Oracle - Day 10
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!
Advent of Code 2022 in Oracle - Day 7
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)...
Advent of Code 2022 in Oracle - Day 5
My solution for the fifth day of the Advent of Code 2022 challenge "Supply Stacks" with Oracle. Its starting to get complex...
Advent of Code 2022 in Oracle - Day 3
My solution for the third day of the Advent of Code 2022 challenge "Rucksack Reorganization" with Oracle. Its starting to get complex...
Advent of Code 2022 in Oracle - Day 2
My solution for the second day of the Advent of Code 2022 challenge "Rock Paper Scissors" with Oracle. This time in pure SQL.
Advent of Code 2022 in Oracle - Day 1
My solution for the first day of Advent of Code 2022 challenge "Calorie Counting" with Oracle.
Oracle APEX anchored inline popups for data input
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.
Oracle APEX AG-Grid Plug-In 0.2 (beta)
Second beta release of the AG-Grid plug-in for Oracle APEX. Find out what's new and how to get it.
Ode to APEX_T_VARCHAR2 #JoelKallmanDay
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.
Alfred workflow to quickly navigate Visual Studio Code workspaces
I created a workflow to open VSCode workspaces for the macOS search tool Alfred quickly. It supports local and remote repositories.
Dynamic click handling with APEX actions in 22.1
APEX 22.1 changed a lot to the actions interface and added a new method with which we can call them easily from links.