materro

Perl References

Simple Perl variables are called scalars. Examples of scalar values are

   $number      = 123;
   $string      = "String";
   $file_handle = open "<filename";
   $null_value  = undef;
 $instance = MyClass-&gt;new;

materro

Install Python 3.11 in local directory on Ubuntu Precise

I needed to install the latest version of Python on an old version of Ubuntu. I succeeded 😊 Below I've written out the instructions on how I realized it.

Dependencies

Run every command as root 🔥

Install required dependencies

apt-get install libffi-dev libgdbm-dev libreadline6-dev liblzma-dev

materro

Google Python Style Guide

Forked from https://github.com/google/styleguide/blob/gh-pages/pyguide.md ⚡

materro

Step by step guide for installing newer version of Git on Ubuntu Focal 20.04

1. Check current version

$ git --version
git version 2.25.1

2. Add git-core repository to package manager

materro

/**
 * Returns a time-ordered UUID (UUIDv6).
 * 
 * Tags: uuid guid uuid-generator guid-generator generator time order rfc4122 rfc-4122 postgres postgres8
 */

CREATE OR REPLACE FUNCTION generate_uuid_v6() RETURNS VARCHAR(36) AS
$$
DECLARE
	v_time TIMESTAMP WITH TIME ZONE;

materro

Create Consolas Nerd Font using Font Pather

1. Download Font Patcher and extract it. You will need font-patcher script.
2. Copy Consolas font from C:\Windows\Fonts.

   You will get (probably) 4 files: consola.ttf, consolab.ttf, consolai.ttf, consolaz.ttf.

3. Install required dependencies (Ubuntu):

apt-get install python3-fontforge

4. If You will get ValueError: not enough values to unpack (expected 3, got 2) edit font-patcher to fix it.

materro

This instruction provide steps to install and configure 64-bit ODBC driver for old version of PostgreSQL, setup a linked server connection in Microsoft SQL Server Management Studio, and run a sample SQL query. It includes downloading and installing the ODBC driver, configuring a new connection, setting advanced options, setting up the provider, creating a linked server connection, and running a SQL query to retrieve data from PostgreSQL.

1. Install ODBC

Download and install psqlodbc_09_05_0400-x64.zip from PostgreSQL ODBC drivers.

2. Configure ODBC

2.1 Add new connection

1. Open ODBC Data Source Administrator (64-bit) %windir%\system32\odbcad32.exe

materro

# Configure the MS SQL Server
$backupRootFolder = "C:\Backup"
$mainDbName = "DATABASE-NAME"
$serverName = "SERVER-NAME"
$daysOfBackup = 7
$queryTimeout = 120
$dayOfFullBackup = 'Friday'

# Main script
$dayOfWeek = (Get-Date).DayOfWeek

materro

param([switch]$elevated)

# 💡 Enter your VPN and KMS server addresses:
$VPN_ADDRESS = 'vpn.address.com'
$KMS_ADDRESS = 'kms.address.com'
$OFFICE_DIR = 'C:\Program files\Microsoft Office\Office16\'

# 👏 Based on:
# https://gist.github.com/ALiangLiang/b66bc6eaeab420a5ff0c2b934c15451e
# https://superuser.com/questions/108207/how-to-run-a-powershell-script-as-administrator

materro

function handleGit {
    param (
        [Parameter(
            Mandatory=$true,
            ValueFromRemainingArguments=$true)] 
        [string[]]$args
    )
    git $args
}
Set-Alias g handleGit