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. We will store and hash user credentials, create sessions with Cookies, and make the session info available to the app through hooks and locals.
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. We simulate a CPU and a Pixel-Screen in pure SQL!
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)...
My solution for the fifth day of the Advent of Code 2022 challenge "Supply Stacks" with Oracle. Its starting to get complex...
My solution for the third day of the Advent of Code 2022 challenge "Rucksack Reorganization" with Oracle. Its starting to get complex...
My solution for the second day of the Advent of Code 2022 challenge "Rock Paper Scissors" with Oracle. This time in pure SQL.
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. They offer a nice UX for quick data input.
Second beta release of the AG-Grid plug-in for Oracle APEX. Find out what's new and how to get it.
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.
I created a workflow to open VSCode workspaces for the macOS search tool Alfred quickly. It supports local and remote repositories.
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. In Oracle PL/SQL they are available too under the name Associative Arrays.
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. Here is my journey to make it work with a preexisting one.
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. With some JS you can still trigger them. Additionally use the read-only functionality where possible.
Chrome on mobile has a default accessibility feature that automatically shows a blue overlay when a touchscreen user taps on a clickable element. This post shows how to change the color or disable it completely.
Great News: APEX 20.2 is finally out and adds a Dropzone component. For me, it does not look as intuitive as the Plug-In did, so I tried to improve the UX of it with a few lines of CSS.
If you use sequences to generate primary key values make sure you use the checksum feature of APEX. Otherwise, users can easily discover data they should not be able to see by raising or lowering the numeric ID in the URL.
HTML 5 added a set of new HTML tags known as "semantic" tags to better structure websites. You should use them to avoid sinking in chaos with many levels of nested divs. They also have the benefit to make your website more accessible.
Tables make it hard to give hierarchy to data. To underline the importance of certain values in a table you can use chips that highlight the values with colors.
I want to share a little script I wrote which generates a DML scripts for blob values like images. The output script can be used in your schema install script with your other master data.
