Sand Fox @sandfox@qoto.org

Just a required follow up for the previous post: JSON5 sucks too, like any other possible format. Just look at this: { certificate: "\ -----BEGIN PRIVATE KEY-----\n\ MIIBVQIBADANBgkqhkiG9w0BAQEFAA

Very useful when you are developing anything WebAuthn related. google-chrome --ignore-certificate-errors --user-data-dir=$HOME/tmp/chrome-dev --ignore-certificate-errors will disable any SSL warnings

But what about Postgres? We can do it too. Hopefully generators for new UUID versions will be added to uuid-ossp but it is not yet the case. The easiest way for now is to use pgcrypto, so let's start

A quick way to generate UUIDv7 in MySQL 8 and MariaDB 11: SELECT CONCAT( -- Use NOW(3) to get milliseconds LPAD(HEX(UNIX_TIMESTAMP(NOW(3)) * 1000), 12, '0'), '7', -- versio

A feature that may be desired for some anti-V2 trackers. While I would like to see the torrent community going the other way around, some trackers choose not to allow version 2 torrents and sometimes

A followup for the previous post: the minimum required PHP versions in packages on the Packagist. PHP version: number of packages. 5.3: 31'400 7.1: 28'522 7.0: 26'223 5.4: 25'239 7.4: 23'736 7.2: 22

As a library developer I often face a problem what should be a minimum PHP requirement. Here are some of my principles. 1. Review what interpreter versions are suitable Not all PHP versions are crea

A thing that was not obvious to me and relatively hard to google was a way to run a 32-bit docker image in the GitLab CI. Docker itself has --platform param but it is not exposed to the .gitlab-ci.yml

I created a UUID and ULID library with Doctrine support. Well, who didn't :D The main scenario for myself was a possible migration for a project from ULIDs to UUIDs since UUIDs got a little bit of sup

This is a short howto for people who already know how to compile PHP. TL;DR: CFLAGS='-m32' PKG_CONFIG_PATH=/usr/lib/pkgconfig ./configure --host=i886 --prefix=$HOME/Software/php32 --exec-prefix=$HOME/

It started with the firmware failing to update because the EFI partition was low on free space. (Dell, why do you need 70 MB on the EFI while also making it as small as 150 MB at the same time?) Well,

It started with the firmware failing to update because the EFI partition was low on free space. (Dell, why do you need 70 MB on the EFI while also making it as small as 150 MB at the same time?) Well,

I'm continuing to publish useless nih junk on the Packagist: arokettu/arithmetic-parser: A very configurable arithmetic parser and calculator. You can define your own set of functions and operators.

"GPL incompatibility" of a FOSS license is not a problem of the incompatible license, it's the problem of the GPL. Most permissive licenses and file-based copyleft licenses can be used together in a p

Just finished moving my old composer packages from sandfoxme/* to arokettu/*. Full list: composer-viz (old, new): the only one I moved a year ago bencode (old, new) monsterid (old, new) phpstorm-meta

While the original way is still valid, in Docker it's now easier to copy the Composer executable from its Docker image. COPY --from=composer:latest /usr/bin/composer /usr/local/bin/composer or for PH