Tobias Burger toburger

C++ and Qt

General advice

[C++] prefer expressions over statements
[C++] prefer immutability over mutability
[C++] prefer composition over inheritance
[Qt] prefer STL over QTL containers

Libraries

To convert a JSON array to be used as generated text[] column follow the steps below:

Define the following (immutable) function:

create or replace function json_array_to_pg_array(jsonarray jsonb) returns text[]
	as $$
		begin
			return (select array(select jsonb_array_elements_text(jsonarray)));
 end;

A very annoying behaviour is that Excel opens an Excel file on the virtual Desktop of an existing Excel Instance and switches to that Desktop.
If you want to avoid this behaviour you can do the following to fix it:

The fix is to call Excel with the /X parameter:

$ assoc .xlsx
.xlsx=Excel.Sheet.12

$ ftype Excel.Sheet.12

	Windows Registry Editor Version 5.00

	[HKEY_CURRENT_USER\Control Panel\Accessibility\Keyboard Response]
	"AutoRepeatDelay"="250"
	"AutoRepeatRate"="13"
	"BounceTime"="0"
	"DelayBeforeAcceptance"="0"
	"Flags"="59"
	"Last BounceKey Setting"=dword:00000000
	"Last Valid Delay"=dword:00000000

	//...

	let fscToolPath = findToolFolderInSubPath "fsc.exe" "packages"
	let msbuildProps = [ "FscToolPath", fscToolPath ]

	Target "Build" (fun _ ->
	!! projectFile
	\|> MSBuildReleaseExt releaseDir msbuildProps "Build"
	\|> Log "AppBuild-Output")

	namespace Newtonsoft.Json.Converters

	open Microsoft.FSharp.Reflection
	open Newtonsoft.Json
	open System

	type IdiomaticDuConverter() =
	inherit JsonConverter()

	[<Literal>]

	$script:bg = [Console]::BackgroundColor;
	$script:first = $true;
	$script:last = 0;

	function Write-PromptFancyEnd {
	Write-Host  -NoNewline -ForegroundColor $script:bg

	$script:bg = [System.ConsoleColor]::Black
	}

	module private BusinessLogic =
	let switchAt pos (str: string) =
	let str = Seq.toArray str

	let oldpos = (pos + str.Length - 1) % str.Length
	let newpos = pos % str.Length

	let tmp = str.[newpos]
	str.[newpos] <- str.[oldpos]
	str.[oldpos] <- tmp

	module Recharts

	open Fable.Core.JsInterop
	open Fable.Recharts
	open Fable.Recharts.Props
	open Fable.React
	open Elmish
	open Elmish.React
	module R = Fable.React.Standard
	module P = Fable.React.Props