# Find the 20 largest files under the current directory
find . -type f -printf '%s\t%p\n' 2>/dev/null \
  | sort -nr \
  | head -n 20 \
  | awk '{ $1 = sprintf("%.1fMB", $1/1024/1024); print }'

Find the 20 largest files

-- Insert a row, or update it if the unique key already exists
INSERT INTO settings (user_id, key, value)
VALUES ($1, $2, $3)
ON CONFLICT (user_id, key)
DO UPDATE SET value = EXCLUDED.value, updated_at = now()
RETURNING *;

Postgres upsert with ON CONFLICT

func main() {
    srv := &http.Server{Addr: ":8080", Handler: routes()}

    go func() {
        if err := srv.ListenAndServe(); err != nil && err != http.ErrServerClosed {
            log.Fatalf("listen: %v", err)
        }
    }()

    quit := make(chan os.Signal, 1)
    signal.Notify(quit, syscall.SIGINT, syscall.SIGTERM)
    <-quit

    ctx, cancel := context.WithTimeout(context.Background(), 10*time.Second)
    defer cancel()
    if err := srv.Shutdown(ctx); err != nil {
        log.Fatalf("forced shutdown: %v", err)
    }
}

@linuxgnu

Public snippets

Find the 20 largest files

Postgres upsert with ON CONFLICT

Graceful HTTP shutdown in Go