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);

jszym

from base64 import urlsafe_b64encode

from blake3 import blake3
import krock32
from time import time
import secrets
import math

def generate_token(namespace: str) -> str:
    """

benperiton

FROM python:3.6-slim

ARG UID
ARG GID

RUN groupadd -g "${GID}" app \
    && useradd --create-home --no-log-init -u "${UID}" -g "${GID}" app

RUN apt-get update && \
    apt-get -y install python3-pip && \

brandur

module github.com/brandur/prequire

go 1.19

require github.com/stretchr/testify v1.8.1

require (
	github.com/davecgh/go-spew v1.1.1 // indirect
	github.com/pmezard/go-difflib v1.0.0 // indirect
	gopkg.in/yaml.v3 v3.0.1 // indirect

func25

package main

import (
	"fmt"
	"reflect"
	"strconv"
	"strings"
)

type Student struct {

Sytten

CREATE EXTENSION IF NOT EXISTS pgcrypto;

CREATE OR REPLACE FUNCTION uuid_generate_ulid ()
  RETURNS uuid
  AS $$
DECLARE
  timestamp bytea = E'\\000\\000\\000\\000\\000\\000';
  unix_time bigint;
BEGIN
  unix_time = (EXTRACT(EPOCH FROM clock_timestamp()) * 1000)::bigint;

nepalez

# Clean the database
DROP TABLE IF EXISTS _orders CASCADE;
DROP TABLE IF EXISTS _users CASCADE;
DROP TABLE IF EXISTS orders CASCADE;
DROP TABLE IF EXISTS users CASCADE;

# Build the database (for hard deletion)
CREATE TABLE users (
  id integer PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
  name text NOT NULL

cpursley

Postgres Full Text Search

Do you really need Elastic Search?

• https://www.postgresql.org/docs/current/pgtrgm.html
• https://scoutapm.com/blog/how-to-make-text-searches-in-postgresql-faster-with-trigram-similarity
• https://about.gitlab.com/blog/2016/03/18/fast-search-using-postgresql-trigram-indexes/
• https://mazeez.dev/posts/pg-trgm-similarity-search-and-fast-like
• https://alexklibisz.com/2022/02/18/optimizing-postgres-trigram-search.html
• https://www.freecodecamp.org/news/fuzzy-string-matching-with-postgresql/

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(