Coding with Titans

so breaking things happens constantly, but never on purpose

Secure access to PostgreSQL on Raspberry Pi

First time this month I thought about doing something right. It’s the end of the year and what about creation of really secured environment for my PostgreSQL database on a Raspberry Pi, that I could expose publicly. What could go wrong here :) ? The goals were clear: Setup a dedicated low-privileged system user, so I could proxy to the database over SSH. Create a new low-privileged PostgreSQL user, so it can access own database only (or ones created in the future). Read more →

Customized ZSH prompt with Git info

Probably first thing you noticed after installing macOS Catalina is that the default shell changed from bash to zsh. I decided to give it a try. Although there is an easy way to revert it back to bash (as its package is still part of the OS distribution) by invoking following command in terminal: chsh -s /bin/bash My hope was, maybe this small update will inevitably influence my usage comfort, performance and maybe, maybe improve my daily routines (as I spend most of the day working in command-line mode). Read more →

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 →

Gitea on Raspberry Pi with no heatmap refreshed

In the times before private repositories were available for free on GitHub.com I had my own git-server installed on a NAS using gitolite. But in a long run I stopped liking managing from console and also I don’t like, when some other corporation looks into my own hidden projects and could be able to cut me off. As a result I migrated again, this time installing Gitea on a Raspberry Pi following this marvelous guide. 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 raspberrypi.org and check the latest OS codename. Verify, if this version is not already installed on the Raspberry using cat /etc/os-release command. $ cat /etc/os-release PRETTY_NAME="Raspbian GNU/Linux 9 (stretch)" NAME="Raspbian GNU/Linux" VERSION_ID="9" VERSION="9 (stretch)" VERSION_CODENAME=stretch ID=raspbian ID_LIKE=debian HOME_URL="http://www. 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 →

SSD over USB 3.0 on Raspberry Pi 4

I wasn’t even surprised, when I plugged-in an SSD via USB 3.0 into Raspberry Pi 4 and it didn’t work at all. That became a killer for my idea of keeping data outside of the Pi’s microSD card. Observed suspicious symptoms were too obvious: booting time increased from 20 seconds to 3 minutes LED light of the drive was constantly blinking some commands took extremely long time to execute (sudo blkid, sudo fdisk -l) and even later mounting finished failing or partition formatting hanged indefinitely. 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 →

Install Ubuntu Server 19.04 on Windows 10 Hyper-V

I am a really trouble guy and having problems and spending sleepless nights seems quite often to me. But gee, it’s 2019! and still it’s not very obvious, why sometimes it’s so hard to do things that in theory should be so easy. You probably noticed, that I like TeamCity. Since I am going to participate in JetBrain’s latest TeamCity Plugin Contest 2019 I came up with idea of setting up virtual machine with a test instance of the CI, instead of messing up my production one to only test the plugin. 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 →