cpursley

PostgreSQL is Enough

• Simplify: move code into database functions
• Just Use Postgres for Everything
• Just use Postgres
• PostgreSQL is the worlds’ best database
• Postgres is eating the database world
• Hacker News discussion

Background and Cron Jobs

hyperupcall

// I'm tired of extensions that automatically:
// - show welcome pages / walkthroughs
// - show release notes
// - send telemetry
// - recommend things
//
// This disables all of that stuff.
// If you have more config, leave a comment so I can add it!!

{

kconner

macOS Internals

Understand your Mac and iPhone more deeply by tracing the evolution of Mac OS X from prelease to Swift. John Siracusa delivers the details.

Starting Points

How to use this gist

You've got two main options:

kjmph

-- 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(

jarppe

--
-- Helper function to produce a diff of two jsonb values.
--
-- Accepts:
--   val1: original jsonb value
--   val2: updated jsonb value
--
-- Returns:
--   jsonb of changed values
--

devnoname120

ℹ️ Enable iCloud end-to-end encryption:

• Nobody knows that, but iCloud actually supports end-to-end encryption (see “Advanced Data Protection for iCloud”) but it's disabled by default. If you care about data privacy, you should turn it on.
  • System settings → Apple ID → iCloud → Set Advanced Data Protection to On.
  • System settings → Apple ID → iCloud → Disable Access iCloud Data on the Web.
• It supports almost all the native Apple apps, with the notable exceptions of iCloud Mail, Contacts, and Calendars. See official data protection matrix for more info.

Table of Contents

• Quality of life improvements

enricofoltran

package main

import (
	"context"
	"flag"
	"fmt"
	"log"
	"net/http"
	"os"
	"os/signal"

imjasonh

* {
    font-size: 12pt;
    font-family: monospace;
    font-weight: normal;
    font-style: normal;
    text-decoration: none;
    color: black;
    cursor: default;
}

asm0dey

function range(start, finish, step = 1) {
    if (step < 1) throw "Step must be ge 1"
    return {
        [Symbol.iterator]: function* () {
            let count = 1;
            yield start
            if (start !== finish) {
                let tmp = start;
                if (start < finish) {
                    while (tmp < finish) {

mitsuhiko

# Alternatively don't use slog but something else.  I just like that more.
[aliases]
	slog = log --pretty=format:"%C(auto,yellow)%h%C(auto)%d\\ %C(auto,reset)%s\\ \\ [%C(auto,blue)%cn%C(auto,reset),\\ %C(auto,cyan)%ar%C(auto,reset)]"
	addprx = "!f() { b=`git symbolic-ref -q --short HEAD` && \
		git fetch origin pull/$1/head:pr/$1 && \
		git fetch -f origin pull/$1/merge:PR_MERGE_HEAD && \
		git rebase --onto $b PR_MERGE_HEAD^ pr/$1 && \
		git branch -D PR_MERGE_HEAD && \
		git checkout $b && echo && \
		git diff --stat $b..pr/$1 && echo && \