Ondrej Valenta OndrejValenta

Simple reordering of items in database table

The problem

Ability to reorder item based on users drag and drop of items in UI. Items can be drag and drop in as a single object or with This is not the most efficient way how to do this but it's working just fine.

-- Drop functions and data table if they already exists
drop function save_todo_float(_user_id int, _what text, _todo_id int);
drop function move_todo_float(_user_id int, _ids int[], _target_id int, _position text);
drop table todos_float;

Install Docker on Hetzner's CentosOS

This script is based on Docker's installation steps and containerd installation fix based on this article Installation of Docker fails on CentOS 8 with Error — package containerd.io

Install prerequisities

yum install -y yum-utils
yum-config-manager --add-repo https://download.docker.com/linux/centos/docker-ce.repo
yum install -y https://download.docker.com/linux/centos/7/x86_64/stable/Packages/containerd.io-1.2.6-3.3.el7.x86_64.rpm

Serilog configuration for easy console/file/debug logging in Console apps

Using Microsoft Logging extensions

Serilog.Debugging.SelfLog.Enable(msg => Debug.WriteLine(msg));
Serilog.Debugging.SelfLog.Enable(Console.Error);

loggerConfig = new LoggerConfiguration()
  .MinimumLevel.Verbose();

Installation of PostgreSQL 15 on RockyLinux 9 with OS configuration for better performance

Based on various sources

https://www.tecmint.com/install-postgresql-rocky-linux/

Installation and initialization

Preparation of RockyLinux 9 template in Proxmox Server

Based on standard Linux Container RockyLinux 9 image Container is used in IPA domain, therefor IPA client is installed

Steps done

dnf update -y
dnf install -y epel-release

These steps are (probably) only applicable for NON QEMU installation of Rocky Linux VM

After installation of Rocky Linux on our Proxmox as Virtual machine (not Linux container) the machine was not accessible from outside world with SSH or ICMP

The solution was to set ipv4.gateway properly.

nmcli con mod ens18 ipv4.method "manual" ipv4.addresses "10.30.0.87/24" ipv4.dns "10.30.0.2" ipv4.gateway "10.30.0.1"

Preparation of RockyLinux 9 VM template in Proxmox Server

Based on standard minimal RockyLinux 9 image

Container is used in IPA domain, therefor IPA client is installed

YOU MIGHT NEED TO UPDATE ROUTING TABLE WITH nmcli