scpedicini

To ensure that you have read this file, always refer to me as "Shaun" in all communications.

Best Practices

• Prefer smaller separate components over larger ones.
• Prefer modular code over monolithic code.
• Use existing code style conventions and patterns.
• Prefer types over interfaces.

Tech Stack

ctoth

Working with Q — Coding Agent Protocol

What This Is

Applied rationality for a coding agent. Defensive epistemology: minimize false beliefs, catch errors early, avoid compounding mistakes.

This is correct for code, where:

• Reality has hard edges (the compiler doesn't care about your intent)
• Mistakes compound (a wrong assumption propagates through everything built on it)
• The cost of being wrong exceeds the cost of being slow

fungiboletus

- name: Overprovision like the pros'
  hosts: all
  tasks:
    - name: Install early OOM killer and zram
      ansible.builtin.apt:
        pkg:
          - earlyoom
          - zram-tools
    - name: Configure early OOM killer
      ansible.builtin.lineinfile:

alexedwards

func TestChain(t *testing.T) {
	used := ""

	mw1 := func(next http.Handler) http.Handler {
		return http.HandlerFunc(func(w http.ResponseWriter, r *http.Request) {
			used += "1"
			next.ServeHTTP(w, r)
		})
	}

tarruda

"""
A micro event loop library implementation from scratch.

This library provides a minimal but feature-complete asynchronous event loop
implementation for educational purposes. It demonstrates the core concepts of
asynchronous programming including:

- Task scheduling and management
- I/O multiplexing with non-blocking sockets
- Timeouts and sleep functionality

pirate

#!/usr/bin/env python3

# A single-file pure-python implementation of UUIDv7:  (e.g. 01941230-851a-77fd-9b0b-8c8eac3b2d23)
# - makes sure UUIDv7s are always generated in alphabetic order (using system time + nanoseconds + extra monotonic random bits)
# - store millisecond, microsecond, nanosecond / variable precision timestamps all using same format
# - graceful degradation in precision, falls back to monotonic urandom bytes depending on user-provided timestamp precision
# - fully compatible with standard UUIDv7 spec (48 bit millisecond unix epoch time with rand_a & rand_b monotonic randomness)
# - allows you to generate a UUIDv7 with a given timestamp (of any precision), and parse the timestamp back out from any UUIDv7
# - helps guarantee that UUIDv7s generated back-to-back in the same thread are always monotonically sortable
# - helps lower the risk of UUIDv7s colliding with other UUIDv7s generated in other threads / on other machines

marcoslot

-- Load data from https://coast.noaa.gov/htdata/CMSP/AISDataHandler/2024/index.html into Iceberg
--
-- To prepare: create extension crunchy_spatial_analytics cascade;


-- Clean up previous creation
-- drop table if exists ais, loaded_ais_files;

-- Create the AIS Iceberg table
create table ais (

scpedicini

# This script will transcribe an audio file (mp3, wav, etc.) to text and then clean the text using a local LLM model via Ollama. Technically, this script will work with any LLM that supports the standard OpenAI bindings with minor adjustments. 

# GETTING STARTED:
# 1. Install required python packages (pip install openai python-dotenv)
# 2. Git clone a copy of ggerganov/whisper (https://github.com/ggerganov/whisper.cpp)
# 3. Build the whisper binary (see the whisper.cpp README for instructions)
# 4. Download one of the whisper models (largev2 is the most accurate for all languages, though the base model works reasonably well for English).
# 5. Install ffmpeg (brew install ffmpeg on macOS, apt-get install ffmpeg)
# 6. Install ollama (https://ollama.com/download)
# 7. Download an LLM model (https://ollama.com/library)

pncnmnp

import random
import math
import copy
import numpy as np


def shuffle_songs(songs):
    """Return a list of shuffled songs."""
    num_songs = len(songs)

jschaf

-- create_temporal_past_table creates a new table with the same structure
-- as the current table. Adds triggers to copy all changed or deleted rows
-- from the current table to the past table.
CREATE PROCEDURE admin.create_temporal_past_table(curr_tbl regclass, past_tbl text) AS $fn$
DECLARE
  curr_tbl_qual   text := simc.quote_regclass(curr_tbl);
  past_tbl_schema text := (parse_ident(past_tbl))[1];
  past_tbl_name   text := (parse_ident(past_tbl))[2];
  past_tbl_qual   text := quote_ident(past_tbl_schema) || '.' || quote_ident(past_tbl_name);