SQL: Query after GUID field
This tiny code snippet demonstrates how to query for GUID fields in SQL by using string values, contrasting it with the MySQL approach.
Find and shorten file and folder names with a certain length
Recently, I restructured my Synology NAS and encrypted all backup shared folders using AES-256 encryption. Therefore I had to find and shorten all files and folders with a certain character length. In general the activation of shared folder encryption is straightforward: Once encrypted, your data will be protected. However, there is a limitation on the […]
Flush DNS Cache for PowerShell and WSL
When using Windows 10+ in combination with WLS(2) (Window Subsystem for Linux), you probably will stumble over some DNS resolution issues. For example: when you’ve changed the A-record for an IP and you try to ping or dig the targeted domain. If you still get old IPs there, it could be caused by cached DNS […]
Render PDF
If filename is the absolute path to pdf file:
Run Gitlab behind ISPConfig
Before a while I had the idea to setup my own Gitlab instance to manage my git repositories on my own server. In order to install Gitlab, I ran into a few problems, because I’m already using ISPConfig as administration panel for my root server. Hence I am slightly going to migrate my whole hosting […]
Override classes and constructor arguments
As for Magento 1 it is possible to override classes in Magento 2 as well. Don’t get me wrong. It is not recommended to override classes or methods. It should be the really last resort. Use a plugin or an observer whenever possible. But sometimes the code you’re working against isn’t suitable for one of […]
Create Symlinks in Windows 10
This short tutorial shows how to create Symlinks in Windows 10 using the standard command prompt (cmd) or the Microsoft PowerShell as well.
Set static IP on LibreELEC
Today I stumbled upon the fact that my KODI based media box (Raspberry Pi 4) is still using a dynamic IPv4 address. Hence I want to connect via ssh regularly, I had to set a static IP on LibreElec (former OpenELEC) which my KODI mediacenter is running on. To achieve that, I had to connect […]
Find and reference standard attribute types in Akeneo code
All standard attribute types available in Akeneo are listed in “\Akeneo\Pim\Structure\Component\AttributeTypes” (File: src/Akeneo/Pim/Structure/Component/AttributeTypes.php). <?php namespace Akeneo\Pim\Structure\Component; /** * Attribute types dictionary * * @author Willy Mesnage <willy.mesnage@akeneo.com> * @copyright 2015 Akeneo SAS (http://www.akeneo.com) * @license http://opensource.org/licenses/osl-3.0.php Open Software License (OSL 3.0) */ final class AttributeTypes { const BOOLEAN = ‘pim_catalog_boolean’; const DATE = ‘pim_catalog_date’; const […]
FloppyDisk Pen Holder for Desktop
Recently I realised, that my girlfriend had some Floppy Disk left over, which are relics of my childhood and youth. Hence there is no real use for this historic storage media anymore, I decided to recycle / upcycle those Floppy Disks. The result where these FloppyDisk Pen Holder. How I designed the FloppyDisk Pen Holder […]