dhermes

WITH raw_relation_sizes AS (
  SELECT
    n.nspname || '.' || c.relname as table_name,
    pg_relation_size(n.nspname || '.' || c.relname) AS relation_size
  FROM
    pg_catalog.pg_class AS c
  LEFT OUTER JOIN
    pg_catalog.pg_namespace AS n
  ON
    n.oid = c.relnamespace

dhermes

package main

import (
	"fmt"
)

type Interface interface {
	Foo() int
	Bar() string
}

dhermes

package main

import (
	"fmt"
	"math"
)

type EmbeddedType struct {
	X int
	Y int

dhermes

package main

import (
	"encoding/json"
	"fmt"
)

type T struct {
	X float64 `json:"x"`
	Y float64 `json:"y"`

dhermes

{
    "source": "https://stripe.com/docs/api/events/types",
    "length": 194,
    "names": [
        "account.updated",
        "account.application.authorized",
        "account.application.deauthorized",
        "account.external_account.created",
        "account.external_account.deleted",
        "account.external_account.updated",

dhermes

FYI, nanoid is lossy

I was scratching my head trying to understand where some of the bits went in a Nano ID. A Nano ID is 16 characters from the [Crockford base 32 alphabet][1]. Since 2**5 == 32, this means each character comes with 5 bits, for a total of 80 bits (5 * 16).

However a UUID has 128 bits, so 3 out of every 8 bits are missing.

dhermes

Use filenames to generate a sequence

Happy Path

$ mkdir files/
$ touch files/j.sql files/j-to-a.sql files/a-to-z.sql files/z-to-c.sql
$
$
$ go run ./main.go --target ./files/

dhermes

PostgreSQL Soft Deletes and Foreign Keys

Showing a simple example for how to preserve referential integrity in the presence of soft deletes. Here we'll implement soft deletion by setting a nullable deleted_at column.

toolshop=> CREATE SCHEMA foo;
CREATE SCHEMA
toolshop=> CREATE TABLE foo.bar (

dhermes

Concurrent but not really

An experiment in serializing work items spawned concurrently in goroutines.

$ go run ./main.go
 Enter 00-03: 2022-03-22 18:55:16.7311542 +0000 UTC
Middle 00-03: 2022-03-22 18:55:16.7312627 +0000 UTC
 Enter 03-02: 2022-03-22 18:55:16.7312777 +0000 UTC

dhermes

/main.wasm