| # 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 |
Do you really need Elastic Search?
| -- 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( |
| /* | |
| Replace "your_schema" with whatever schema is appropriate in your environment. | |
| It is possible to use "public"... but you shouldn't! | |
| */ | |
| /* | |
| Function to stamp a "modified" timestamp. Adjust the name to suit your environment, | |
| but that name is hard-coded so it is assumed that you only use _one_ such name. |
| -- DateDiff function that returns the difference between two timestamps in the given date_part (weeks, months, etc) as an integer | |
| -- This behaves like the DateDiff function in warehouses like Redshift and Snowflake, which count the boundaries between date_parts | |
| CREATE OR REPLACE FUNCTION datediff (date_part VARCHAR(30), start_t TIMESTAMP, end_t TIMESTAMP) | |
| RETURNS INT AS $diff$ | |
| DECLARE | |
| years INT = 0; | |
| days INT = 0; | |
| hours INT = 0; | |
| minutes INT = 0; |
| <!DOCTYPE html> | |
| <html lang="en"> | |
| <head> | |
| <meta charset="utf-8" /> | |
| <meta name="viewport" content="width=device-width, initial-scale=1" /> | |
| <title>Fisher-Yates</title> | |
| </head> | |
| <body> | |
| <h1>Fisher-Yates Shuffling in Javascript</h1> | |
| <p>Open the console, ensure that the accompanying javascript file is also available, then click the button below.</p> |
| CREATE FUNCTION uuid_time_nextval(interval_length int default 60, interval_count int default 65536) | |
| RETURNS uuid | |
| LANGUAGE plpgsql | |
| AS $$ | |
| DECLARE | |
| v_i int; | |
| v_prefix_bytes int = 0; | |
| v_time bigint; | |
| v_bytes int[16] = '{}'; | |
| v_hex text[16] = '{}'; |
| #!/usr/bin/env bash | |
| set -Eeuo pipefail | |
| trap cleanup SIGINT SIGTERM ERR EXIT | |
| script_dir=$(cd "$(dirname "${BASH_SOURCE[0]}")" &>/dev/null && pwd -P) | |
| usage() { | |
| cat <<EOF | |
| Usage: $(basename "${BASH_SOURCE[0]}") [-h] [-v] [-f] -p param_value arg1 [arg2...] |