Philipp Hartenfeller
My Blog
*/Topics
Posts
-
UC AI v25.7: Embeddings, xAI, OpenRouter and Toon
The current UC AI release adds support for xAI (Grok) and OpenRouter (almost all models). Additionally, embedding is supported for all providers, you can use Toon, and override URLs for all providers.
-
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.
-
Toon for Oracle: A Token-Efficient Data Format for LLMs
Toon is a data representation format that is optimized for usage for LLMs. With UC AI's PL/SQL package, you can convert any JSON data to the Toon format.
-
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
-
Build Real AI Solutions with Oracle PL/SQL (No 23ai Required)
Learn how data engineers can leverage AI for Oracle automation using PL/SQL. Discover structured output, file analysis, reasoning, and tool calling with the open-source UC AI SDK.
-
How to Run Open GPT Models Locally and Integrate Them with Oracle APEX
How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.
-
Oracle APEX Reactive Markdown Plug-in #JoelKallmanDay
Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.
-
How to Run Open GPT Models Locally and Integrate Them with Oracle APEX
How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.
-
How to Run Open GPT Models Locally and Integrate Them with Oracle APEX
How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.
-
You should try having a local database with APEX
A local Oracle APEX environment eliminates friction through safe experimentation, administrative access, and instant performance.
-
Easily query testdata with Oracle APEX and the power of SQL Macros
How to use the Oracle APEX Data Generator/Blueprints feature purely from SQL and how to make it convenient with SQL Macros.
-
APEX Offline for everyone: APEX Off Grid
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.
-
UC AI v25.7: Embeddings, xAI, OpenRouter and Toon
The current UC AI release adds support for xAI (Grok) and OpenRouter (almost all models). Additionally, embedding is supported for all providers, you can use Toon, and override URLs for all providers.
-
Advent of Code 2025 in SQL - Day 1
Advent of Code 2025 in Oracle SQL Day 1 solutions and explanations.
-
Toon for Oracle: A Token-Efficient Data Format for LLMs
Toon is a data representation format that is optimized for usage for LLMs. With UC AI's PL/SQL package, you can convert any JSON data to the Toon format.
-
Build Real AI Solutions with Oracle PL/SQL (No 23ai Required)
Learn how data engineers can leverage AI for Oracle automation using PL/SQL. Discover structured output, file analysis, reasoning, and tool calling with the open-source UC AI SDK.
-
How to Run Open GPT Models Locally and Integrate Them with Oracle APEX
How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.
-
How to Run Open GPT Models Locally and Integrate Them with Oracle APEX
How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.
-
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.