Ilya Evseev ilyaevseev

ilyaevseev / rocket1.bas

Created February 21, 2023 17:38

First sample for Sofa on QB64

	Screen 12

	Let StepX = 100
	Let StepY = 100
	Let ScreenWidth = _Width
	Let ScreenHeight = _Height - 20

	For X = 0 To ScreenWidth Step StepX
	Line (X, 0)-(X, ScreenHeight), 7
	Next

ilyaevseev / clickhouse-backup

Created May 8, 2024 03:54

Quick and dirty Clickhouse database daily backup script

	#!/bin/sh -e

	T="$(date +%Y-%m-%d-%H%M)"

	BASEDIR=/opt/backups/clickhouse
	DESTDIR="$BASEDIR/$T"

	. ~/.env.clickhouse # ..CLICKHOUSE_HOST,USERNAME,PASSWORD,DATABASE

	Query() {

ilyaevseev / postgres-backup.sh

Created December 31, 2024 12:08

pg_basebackup cron.daily wrapper script.

	#!/bin/sh -e

	BASE="/mnt/backups/postgres"
	DEST="$BASE/$(date +%Y-%m-%d-%H%M)"
	AGE="2"

	Echo() { date +"%Y-%m-%d %H:%M:%S -- $@"; }

	Echo "Mkdir1..." ; mkdir -pm710 "$BASE" && chown root:postgres "$BASE"
	Echo "Mkdir2..." ; mkdir -pm700 "$DEST" && chown postgres "$DEST"