Philipp Hartenfeller Blog RSS Feed

My solution for the second day of the Advent of Code 2022 challenge "Rock Paper Scissors" with Oracle.

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.

Second beta release of the AG-Grid plug-in for Oracle APEX.

APEX_T_VARCHAR2 is a database type that comes with an Oracle APEX installation.

I created a workflow to open VSCode workspaces for the macOS search tool Alfred quickly.

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.

With two lines in your zsh config file, Oracle SQLcl will still work after an upgrade with Homebrew.

I created a GitHub Actions Plugin for calling jobs on your Cronicle server.

I made made my website IPv6 ready on Linux in a few simple steps.

Out of the box self-hosting plausible expects you to create a new separate Postgres database.

The loading speed of my site improved dramatically in unideal conditions by not loading fonts from Google Fonts but self hosting them instead.

I made an Oracle APEX Plug-In that allows creating Slideover regions which slide in content from the side when opened.

Don't just hide Buttons when only some privileged users should be able to execute processes in Oracle APEX.

Chrome on mobile has a default accessibility feature that automatically shows a blue overlay when a touchscreen user taps on a clickable element.

Great News: APEX 20.2 is finally out and adds a Dropzone component.

If you use sequences to generate primary key values make sure you use the checksum feature of APEX.

HTML 5 added a set of new HTML tags known as "semantic" tags to better structure websites.

Tables make it hard to give hierarchy to data.

I want to share a little script I wrote which generates a DML scripts for blob values like images.