Discover gists

Upgrading PostgreSQL in Windows

The official documentation for PostgreSQL provides a guide to upgrading using pg_upgrade. However, it can be a bit like a treasure hunt with hidden traps. This gist will walk you through a clear and robust method for upgrading PostgreSQL on Windows, using the upgrade from version 14 to 16 as an example.

1. Install the New Version of PostgreSQL

Before you embark on the upgrade journey, make sure you have the new version installed. This is because the pg_upgrade utility used during the upgrade process belongs to the newer version.

To get started, visit the official download page, download the installer, and run it. A word of caution: do not overwrite the old installation, as you'll need its binaries and data for the upgrade.

Build a Raspberry Pi WiFi AP

TUTES

Find chipset

Magento 2: UI Components Debug Reference Sheet

Here are some examples of how to debug UI Components in Magento 2.

Get all UI Components registered on the page

require('uiRegistry').get(ui => console.log(ui.name));

Inspect a single given component

if you can access to the GUI environment, It is very easy using "disks" application.

or might be easy with gdisk/fdisk ? I'm not sure about this.

------------------------------------------------------------------------

see the reference for more detail, if you want.
https://richardstechnotes.wordpress.com/2015/12/18/setting-up-an-nvme-ssd-on-ubuntu-14-04-lts/ http://takatakamanbou.hatenablog.com/entry/2015/10/25/235600 : Japanese website

	import pyaudio
	import wave
	import numpy as np
	from datetime import datetime
	from scipy.io.wavfile import write
	import tempfile
	import os
	from lightning_whisper_mlx import LightningWhisperMLX

	# Constants

	//audio visualizer on glsl-livecoder ( https://atom.io/packages/glsl-livecoder )
	precision mediump float;
	uniform float time;
	uniform vec2 resolution;
	uniform sampler2D spectrum;
	uniform sampler2D samples;
	uniform float volume;
	uniform sampler2D backbuffer;

	float PI = 3.14159265359;

	// Lines
	float hash( float n ) {
	return fract(sin(n)*753.5453123);
	}

	// Slight modification of iq's noise function.
	float noise(vector_float2 x )
	{
	vector_float2 p = floor(x);
	vector_float2 f = fract(x);

	/**
	Exercise 1

	Rewrite the code below to use array destructuring instead of assigning each value to a variable.
	*/
	{
	console.log("EXERCISE 1");

	let item = ["Egg", 0.25, 12];

	@echo off
	title Microsoft Office 2019 versions are supported!&cls&echo
	============================================================================&echo
	#Project: Activating Microsoft software products for FREE without software&echo
	============================================================================&echo.&echo
	#Supported products:&echo - Microsoft Office Standard 2019&echo - Microsoft Office Professional Plus 2019&echo.&echo.&(if exist
	"%ProgramFiles%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles%\Microsoft Office\Office16")&(if exist
	"%ProgramFiles(x86)%\Microsoft Office\Office16\ospp.vbs" cd /d "%ProgramFiles(x86)%\Microsoft Office\Office16")&(for /f %%x in ('dir /b
	..\root\Licenses16\ProPlus2019VL*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&(for /f %%x in ('dir /b
	..\root\Licenses16\ProPlus2019VL*.xrm-ms') do cscript ospp.vbs /inslic:"..\root\Licenses16\%%x" >nul)&echo.&echo