Vector tiles with PostGIS, PHP and OpenLayers

This is an example about how to create vector tiles with PostGIS 3.3 (and PostgreSQL 15.3), serve them with PHP 8.1 and use them in OpenLayers 7.5. In contrast to the few tutorials available on the internet, it not only uses the latest PostGIS version 3.3, which further simplified the generation of vector tiles by …

How to copy EXIF tags from XMP to NEF with ExifTool

Adobe Lightroom only writes changes to Metadata such as geolocation into the XMP sidecar files and not directly into the EXIF tags of the image. If you add coordinates via the map module, then you will need to copy that information from the sidecar files back into your raw files (in my case Nikon NEF). …

Nikon D800 questions

Google has a new experimental feature that proposes content for your website based on search queries that might not have good enough results. For this website and the category photography, it suggests to answer the following questions:

Multiple OCI8 and PHP versions in parallel

You can easily switch between multiple versions of PHP with: But if you installed the Oracle oci8 extension, you will probably run into the error, that it can not be loaded when switching to the older php version: Unable to load dynamic library ‘oci8.so’ This happens, because pecl uninstalls the previous oci8 version automatically unless …

Black screen after updating nvidia driver

Updating the nvidia-driver on Linux (Mint) can lead to a black screen after boot. Here is how you can quickly revert to the previous working version: Press Ctrl + Alt + F1 and log into a the virtual console with your username and password (If that does not work, boot first into recovery mode, then …

How to use a YubiKey for two-factor autenthication on Linux Mint

This post will show you how to setup and use a YubiKey and the Yubico Authenticator application to sign in to a Microsoft Azure Cloud Account using Linux Mint 20 without the need for the Microsoft Authenticator being installed on your mobile phone: Yubico Authenticator desktop installation 1. Download and install the Yubico Authenticator AppImage:

Docker: How to install the php enchant extension

If I try to install the php enchant extension in the docker image php:8.1-fpm with RUN docker-php-ext-install enchant I get the following error: E: Unable to locate package libenchant-2 You need to install the missing enchant library in the dockerfile yourself (along with your wanted spellcheck language, in my case Swiss German): RUN apt-get install …

How to get the version of a module from its package.json

node.js < 12 VERSION=$(node -p “require(‘some-module/package.json’).version”) node.js 12+ In Node.js 12+ you can no longer get the version of a module dependency with the version property unless the path is explicitly exported in the module with: { “exports”: { “./package.json”: “./package.json” } } What you can do instead, is to use a regular expression to …

How to Install the CnCNet Client on Linux

If you want to play the classic Games Red Alert 2 and Red Alert Yuri’s Revenge with multiplayer support on Linux (or other old Command and Conquer Games), you need to download and install the CnCNet Client. Here are the instructions on how to get CnCNet 5 working under Linux using Wine.

How to install SpectraView II on Linux (Mint 20)

NEC (now Sharp) provides a Linux Version of SpectraView II and a corresponding installation guide. Unfortunately, both are pretty outdated. They reference Ubuntu 14 as the latest version 🙁 . Even worse, the application depends on some Qt4 packages which are no longer available in a current Ubuntu/Mint installation. After digging around the internet I …