bruth

Postgres push triggers

Watch a table for changes and push a notification with a payload describing the change.

Example

In the Postgres shell:

-- Create the functions

bruth

SQLite Update Hook Example

This is an example usage of registering an update_hook to a SQLite connection. The motivation for exploring this feature is to test out various implementations of data monitoring interfaces.

A few notable properties of the implementation:

• The hook must be registered on the connection being used which requires clients to manually integrate this code.
• Each INSERT and UPDATE operation requires a subsequent SELECT to get the row data.
• When registering the hook, increasing the bufsize under heavy workloads will improve throughput, but the SQLite library is single-threaded by design.

bruth

Subcommander

Managment commands are assumed to be unique across all apps in a Django project. This can lead to long or obscure command names in attempt to namespace those commands.

Subcommander acts as a proxy command giving the real commands a namespace. The subcommander module can be named after the app name or some derivation. The structure looks as follows:

myapp/
    management/
        commands/

bruth

import string
from random import SystemRandom
from django.db import connections

key_chars = string.ascii_letters
random = SystemRandom()

class adhoc_db(object):
    """Context manager that temporarily adds a database connection.

bruth

package main

import (
	"reflect"
	"testing"
)

type myint int64

type Inccer interface {

bruth

NATS-RPC Generator

go generate command for creating a client interface, CLI, and serve function for a service interface.

Usage

//go:generate nats-rpc -type=Service -client=client.go -cli=./cmd/cli/main.go
package main

bruth

import inspect
from django.conf import settings
from django.utils.importlib import import_module
from django.core.exceptions import ImproperlyConfigured


class AlreadyRegistered(Exception):
    pass

bruth

from datetime import datetime
from django.db import models
from django.core.cache import cache

class ModifiedModel(models.Model):
    modified = models.DateTimeField()

    class Meta(object):
        abstract = True

bruth

Markdown version of Seth Godin's ShipIt Journal

Project:

Ship Date:

You may have already figured out these reasons for not shipping:

• You might not know enough...
• You might not see clearly enough...

bruth

#!/bin/bash
/usr/sbin/usermod -aG docker <user>