Philipp Hartenfeller
My Blog
*/Topics
Posts
-
Run Oracle APEX 26.1 Locally
APEX 26.1 was finally released yesterday. Learn how to quickly set it up locally and test the new features with uc-local-apex-dev.
-
UC AI Chat Plug-In Beta
Build APEX AI agents with UC AI thanks to the new chat plug-in
-
Best Practices for LLM Tools or Function Calling for Oracle Developers
APEX 26.1 brings native LLM function calling to PL/SQL. Here's how to design tools that the model actually uses correctly: scope, validation, and security.
-
Mixing APEX Universal Theme Colors with the mix-color function
Lighten or darken APEX Universal Theme colors with the mix-color function to create custom colors for your APEX applications.
-
UC AI v26.1: Multi-Agent Systems, Prompt Profiles & Responses API for PL/SQL
UC AI v26.1 brings multi-agent systems, prompt profiles for reusable LLM configurations, and support for OpenAI's new Responses API.
-
Teaching AI coding assistants Oracle APEX
How to utilize SKILL.md files to teach AI coding assistants like Claude Code about how to use Oracle APEX-specific concepts.
-
Run Oracle APEX 26.1 Locally
APEX 26.1 was finally released yesterday. Learn how to quickly set it up locally and test the new features with uc-local-apex-dev.
-
UC AI Chat Plug-In Beta
Build APEX AI agents with UC AI thanks to the new chat plug-in
-
Best Practices for LLM Tools or Function Calling for Oracle Developers
APEX 26.1 brings native LLM function calling to PL/SQL. Here's how to design tools that the model actually uses correctly: scope, validation, and security.
-
Mixing APEX Universal Theme Colors with the mix-color function
Lighten or darken APEX Universal Theme colors with the mix-color function to create custom colors for your APEX applications.
-
Upgrading uc-local-apex-dev from 23ai to 26ai without data loss
uc-local-apex-dev lets you run Oracle APEX and Database 26ai locally with minimal setup. Upgrade from 23ai without data loss.
-
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
-
Run Oracle APEX 26.1 Locally
APEX 26.1 was finally released yesterday. Learn how to quickly set it up locally and test the new features with uc-local-apex-dev.
-
UC AI Chat Plug-In Beta
Build APEX AI agents with UC AI thanks to the new chat plug-in
-
Best Practices for LLM Tools or Function Calling for Oracle Developers
APEX 26.1 brings native LLM function calling to PL/SQL. Here's how to design tools that the model actually uses correctly: scope, validation, and security.
-
UC AI v26.1: Multi-Agent Systems, Prompt Profiles & Responses API for PL/SQL
UC AI v26.1 brings multi-agent systems, prompt profiles for reusable LLM configurations, and support for OpenAI's new Responses API.
-
Teaching AI coding assistants Oracle APEX
How to utilize SKILL.md files to teach AI coding assistants like Claude Code about how to use Oracle APEX-specific concepts.
-
Upgrading uc-local-apex-dev from 23ai to 26ai without data loss
uc-local-apex-dev lets you run Oracle APEX and Database 26ai locally with minimal setup. Upgrade from 23ai without data loss.
-
This blog is now on Astro thanks to Antigravity!
How I migrated my blog from a custom React setup to Astro, improving performance and maintainability.
-
Oracle APEX Template Components with Web Components #JoelKallmanDay
Web Components make it easy to create custom JavaScript-heavy components and integrate well into Oracle APEX.
-
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.
-
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.
-
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.
-
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.
About
*/Hi my name is Philipp Hartenfeller and I am a software engineer from Germany.
I am interested in full stack web dev, including databases and and JavaScript.
I am Product Lead at United Codes where I work on products, do marketing, give training, and support our customers. I frequently give talks at international conferences.
A few things I work(ed) on
*/Oracle APEX
- APEX Off Grid: Plug-in system that enables offline-first APEX apps (proof of concept).
- uc-local-apex-dev: Local containerized APEX development set-up with plenty of developer experience related scripts.
- APEX Template Studio: Online APEX HTML + CSS template IDE.
- Enhanced Grid Pro: APEX plug-in with a powerful, spreadsheet-like grid component.
- apex.world: I help maintining the #1 APEX community website (mainly the AI assistant).
- United Codes Advent Calendar 2024: 24 festive APEX tips.
Websites
- f1report.net: Formula1 race and stats analysis site.
- Minesweeper PWA: Classic Minesweeper game as a PWA.
- SvelteKit SQLite demo app: Demo app to show how to use SQLite with SvelteKit.
Knowledge sharing
- My blog: I write about APEX, Svelte, and other web development topics.
- Talks: I frequently give talks at conferences and meetups.
- My YouTube channel: I share videos about APEX, Svelte, and other web development topics.
- United Codes Blog: I frequently write articles for my employers blog.
- United Codes YouTube: I publish videos ony for my employers channel.