Philipp Hartenfeller Blog RSS Feed

How a makefile turns the SQLcl, Git and dbLinter commands of an APEX project into short make commands, and how a Git-based sync script stops APEXlang imports from overwriting your colleagues' App Builder changes.

Changing the Oracle Free image tag keeps your data but leaves the data dictionary behind.

Letting an LLM write one small program that calls your tools in a loop beats round-tripping every call through the model.

Coding agents write plenty of PL/SQL, but they need a feedback loop to write it well.

APEX 26.1 was finally released yesterday.

Build APEX AI agents with UC AI thanks to the new chat plug-in

APEX 26.1 brings native LLM function calling to PL/SQL.

Lighten or darken APEX Universal Theme colors with the mix-color function to create custom colors for your APEX applications.

UC AI v26.1 brings multi-agent systems, prompt profiles for reusable LLM configurations, and support for OpenAI's new Responses API.

How to utilize SKILL.md files to teach AI coding assistants like Claude Code about how to use Oracle APEX-specific concepts.

uc-local-apex-dev lets you run Oracle APEX and Database 26ai locally with minimal setup.

The current UC AI release adds support for xAI (Grok) and OpenRouter (almost all models).

How I migrated my blog from a custom React setup to Astro, improving performance and maintainability.

Toon is a data representation format that is optimized for usage for LLMs.

Display rich Markdown in Oracle APEX that reacts to changes of referenced page items.

Learn how data engineers can leverage AI for Oracle automation using PL/SQL.

How to integrate OpenAI's new open GPT models locally with Ollama and UC AI into an Oracle APEX app.

A local Oracle APEX environment eliminates friction through safe experimentation, administrative access, and instant performance.

A deep dive into Oracle's SQLcl MCP Server: understanding its capabilities, testing its tools, and examining the security implications for database access through AI.

How to use the Oracle APEX Data Generator/Blueprints feature purely from SQL and how to make it convenient with SQL Macros.

Since a year, I don't use PowerPoint anymore.

Unwanted changes, bugs, but a jump-start.

Getting JavaScript working in SQLcl in 2025 is not straightforward.

From changing jobs to international conferences to discovering 3D printing and more.

When trying out the Free Oracle 23ai Database Docker Image I always encountered the same issue.

Quickly access the APEX documentation, icons, CSS, and more from your spotlight search.

Find out what's behind the region-only type, Slots and selection support.

AppleScript to quickly minimize every window on my macOS.

My upgrade journey from dockerized Oracle 23c FREE to 23ai

Learn how to add a global search to your Oracle APEX app that searches through all your data and navigation entries.

Give back to the community by contributing to open-source Oracle APEX Plug-ins with Git and GitHub.

Advent of Code 2023 in Oracle SQL and PL/SQL.

Advent of Code 2023 in Oracle SQL and PL/SQL.

A preview version of Oracle APEX 23.2 just got released on apex.oracle.com.

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.

Learn step-by-step how Web Components work and how to use them.

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.

I released the third beta release of the AG-Grid plug-in for Oracle APEX.

In this series, we develop an offline-capable SvelteKit application utilizing SQLite as a client-side storage solution.

The most exciting feature in APEX 23.1 for me is Template Components.

In this series, we develop an offline-capable SvelteKit application utilizing SQLite as a client-side storage solution.

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.

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.

My solution for the seventh day of the Advent of Code 2022 challenge "No Space Left On Device" with Oracle.

My solution for the fifth day of the Advent of Code 2022 challenge "Supply Stacks" with Oracle.

My solution for the third day of the Advent of Code 2022 challenge "Rucksack Reorganization" with Oracle.