Joao C Costa joaocc

PostgreSQL is Enough

Background and Cron Jobs

This is a simple background script to kill git-credential-manager when it hits the 100% cpu bug

Because cross-compiling binaries for Windows is easier than building natively

I want Microsoft to do better, want Windows to be a decent development platform-and yet, I constantly see Microsoft playing the open source game: advertising how open-source and developer friendly they are - only to crush developers under the heel of the corporate behemoth's boot.

The people who work at Microsoft are amazing, kind, talented individuals. This is aimed at the company's leadership, who I feel has on many occassions crushed myself and other developers under. It's a plea for help.

The source of truth for the 'open source' C#, C++, Rust, and other Windows SDKs is proprietary

You probably haven't heard of it before, but if you've ever used win32 API bindings in C#, C++, Rust, or other languages, odds are they were generated from a repository called microsoft/win32metadata.

🗺🐘 1000+ PostgreSQL EXTENSIONs

This is a list of URLs to PostgreSQL EXTENSION repos, listed in alphabetical order of parent repo, with active forks listed under each parent.

⭐️ >= 10 stars
⭐️⭐️ >= 100 stars
⭐️⭐️⭐️ >= 1000 stars
Numbers of stars might not be up-to-date.

API

awesome-api - A curated list of awesome resources for design and implement RESTful API's

public-apis - A collective list of free APIs for use in software and web development

graphql-apis - A collective list of public GraphQL APIs

Google APIs - clients for Google APIs and tools that help produce them

	#!/usr/bin/env -S bash -c "docker run -p 8080:8080 -it --rm \$(docker build --progress plain -f \$0 . 2>&1 \| tee /dev/stderr \| grep -oP 'sha256:[0-9a-f]*')"

	# syntax = docker/dockerfile:1.4.0

	FROM node:20

	WORKDIR /root

	RUN npm install sqlite3

	#!/bin/bash

	usage() {
	cat << EOF

	This script detects TLS secrets which refer to certificates that don't exist (anymore).

	This is the case when error "unable to fetch certificate that owns the secret" occurs in cert-manager (cainjector) logs.
	The reason is that a certificate has been removed without the secret being deleted.
	The solution is to clean up by deleting any secret which belonged to a certificate that no longer exists.

	-- Based off IETF draft, https://datatracker.ietf.org/doc/draft-peabody-dispatch-new-uuid-format/

	create or replace function uuid_generate_v7()
	returns uuid
	as $$
	begin
	-- use random v4 uuid as starting point (which has the same variant we need)
	-- then overlay timestamp
	-- then set version 7 by flipping the 2 and 1 bit in the version 4 string
	return encode(

	<# Convert a VM to a Spot VM
	Based on sample script at https://docs.microsoft.com/en-us/azure/virtual-machines/windows/change-availability-set
	NOTE: Extensions will not be copied to new instance!!
	#>

	# Set variables to your specifics
	$resourceGroup = "myRG"
	$vmName = "myVM"

	# Get the details of the VM to be moved to the Availability Set

	# Starter pipeline
	# Start with a minimal pipeline that you can customize to build and deploy your code.
	# Add steps that build, run tests, deploy, and more:
	# https://aka.ms/yaml

	trigger:
	- master

	pool:
	vmImage: 'windows-latest'