Coding with Titans

so breaking things happens constantly, but never on purpose

HowTo: migrate PostgreSQL 9.6 to 11.5

Recently I have created a post on how to upgrade OS on Raspberry Pi. It worked pretty well until I figured out there is something wired with my PostgreSQL installation. And it turned out I ended up with two instances installed one next to the other. So I had the 9.6 version running with my existing databases and as well a cluster for version 11.5. Let me try then to rephrase the other guide, I found here, explaining, how to upgrade PostgreSQL to latest and migrate the databases. Read more →

HowTo: OS upgrade on Raspberry Pi 4

The process of system upgrade is very easy and was already described here. This is a really great guide. I just want to add few comments, that affected my installation. The main actions to perform to install latest version of Raspbian are: Go to and check the latest OS codename. Verify, if this version is not already installed on the Raspberry using cat /etc/os-release command. Read more →

HowTo: Enable video 4k@60Hz on Raspberry Pi 4

Here I wish to present a quick guide, how to enable 4k video output on Raspberry Pi 4 with 60Hz refresh rate. It’s not hard at all. It just requires to know some facts before, to avoid unnecessary frustration. Let me briefly summarize it: 4k@60Hz is disabled by default on Raspberry Pi 4 (due to a fact of increased memory consumption and device temperature - check docs - that is not needed by most of Pi users). Read more →

Convert Miniblog to Hugo

For a very long time I was using the MiniBlog as a backend solution for my blogs. I liked its speed and the minimalistic style. But one thing that drove me crazy was the need of having Live Writer aka Open Live Writer installed to write a simplest post. 5 years ago this tool looked amazing. Although time has passed quickly, and meanwhile OLW seemed to be also abandoned by Microsoft. Read more →

Enable Android Emulator on Windows 10 Hyper-V

During installation of Android Studio we usually end-up with Android Emulator using Intel HAXM. This is still pretty good virtualization platform. Unfortunately might lead to a clash, since only one virtualization technology could be used at a time. And if you continue using Docker for Windows or any other Hyper-V based virtual machine with Linux system, something will not work (depending, what was launched first). Fortunately Microsoft solved this problem with 1803 release for Windows 10. Read more →

Raspberry Pi 3 and QEMU

At first glance, it seemed to me to be a really easy task. Install QEMU for Windows, download latest Raspbian and run! Unfortunately after whole evening of tries I still fail to have it usable anyhow. Maybe it’s not totally not running, but still it’s pretty useless in terms of any further development of application without a device. Simply, at current state (as of 2018-02-18) of QEMU, it doesn’t support emulation of the USB controller, and since the whole network relays on it, there are huge connectivity issues (no network interface at all, so no SSH, no tools installation, no file transfers neither). Read more →

Wake-on-LAN from Raspberry Pi and Synology NAS

Some time ago I have written a post about, how to setup Windows 10 to wake it up remotely via network using magic packet. The question that remained unanswered is: how to actually send this packet to the PC to trigger it running. In the first example I will use Raspberry Pi with Rasbpian Stretch Lite installed: First make sure a tool etherwake is available. If not, this could be fixed with following command, otherwise skip this step: sudo apt-get install etherwake Then simply invoke it with proper arguments: sudo etherwake –i <ethernet-interface-name> <PC MAC-address> Some explanations: Read more →

HowTo: Split web.config file

Among all the features of ASP.NET framework, there is one I love the most: moving parts of the configuration (i.e. Web.config) into separate files! It’s just it, a little something, that makes life so much easier by: less effort while working with GiT (conflicts are subtle and with better context, changing braches mostly let you move also your local changes, or reset parts of it) quicker navigation, as they are files with my custom naming convention (via R# hit Ctrl+T and start typing the name using only first uppercase letters of the file to open it) custom sections can also be put in an another file. Read more →

HowTo: Setup SSIS project to build via TeamCity

It should be simple, it should be quick. And as usual it turned out to be hard, painful and forced me to install Visual Studio 2017 back on a build machine. I’ve cried a lot that hour. Now I am just waiting, what will fail next, once I see this comment in TC build logs, even though I logged-in and obtained permanent license. [13:05:08][Step 3/3] Starting: C:\TeamCity\buildAgent\temp\agentTmp\custom_script5352870621326270693.cmd [13:05:08][Step 3/3] in directory: C:\TeamCity\buildAgent\work\2906b7d01f979ef5[13:05:12][Step 3/3] [13:05:12][Step 3/3] Microsoft Visual Studio 2017 Version 15. Read more →

HowTo: Custom fields in ApplicationInsights

Recently, I have shown, how to enable Application Insights within own WCF server application (look here). It might similarly work in other kinds of apps, so we won’t bother with further demystification of this procedure. But as you might suspect (or already stepped on), you will quickly require more metadata transmitted than it is done by default. My scenario is pretty simple. The WCF server is installed multiple times, in multiple physical locations across the whole country. Read more →