jkatz

CREATE TABLE data (id int PRIMARY KEY);
INSERT INTO data SELECT * FROM generate_series(1,5000000);

----
EXPLAIN ANALYZE
WITH r AS (
  SELECT (random() * (SELECT count(*) FROM data))::int x
)
SELECT data.*
FROM r

jkatz

pgo create cluster postgres -n pgo --database=keycloak --username=admin --password=admin

# wait for startup

cat <<-EOF > kc-deploy.yaml
apiVersion: apps/v1
kind: Deployment
metadata:
  name: keycloak
  labels:

jkatz

const PASSWORD_CHARACTERS = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ'
                          + 'abcdefghijklmnopqrstuvwxyz'
                          + '01234567890'
                          + '!#$%&()*+,-./:;<=>?@[]^_`{|}~\/"\' ';

function generateRandomPassword(passwordLength=16) {
  // if crypto not defined, bail
  if (!window.crypto) {
    throw new Error('The "crypto" library is not available');
  }

jkatz

#!/bin/bash

# SET THIS TO BE YOUR DESIRED USERNAME
export MY_USER_NAME_FOR_CERT=`whoami`

# This directory is optional, but will use it to keep the CA root key safe
mkdir keys certs
chmod og-rwx keys certs

# Set up a directory that will serve as the pgconf mount

jkatz

"""
Generate the password hashes / verifiers for use in PostgreSQL

How to use this:

pw = EncryptPassword(
    user="username",
    password="securepassword",
    algorithm="scram-sha-256",
)

jkatz

import base64
import hashlib
import hmac
import re
import secrets
import socket

class SCRAMAuthentication(object):
    AUTHENTICATION_METHOD = b"SCRAM-SHA-256"
    DIGEST = hashlib.sha256

jkatz

#!/bin/bash

mkdir postgres
cd postgres

docker volume create --driver local --name=pgvolume
docker volume create --driver local --name=pga4volume

docker network create --driver bridge pgnetwork

jkatz

#!/bin/bash

mkdir postgres
cd postgres

docker volume create --driver local --name=pgvolume
docker volume create --driver local --name=pga4volume

docker network create --driver bridge pgnetwork

jkatz

diff --git a/media/img/docs/books/plpgsql_y_otros_lenguajes.jpg b/media/img/docs/books/plpgsql_y_otros_lenguajes.jpg
new file mode 100644
index 0000000..8c1e1ee
Binary files /dev/null and b/media/img/docs/books/plpgsql_y_otros_lenguajes.jpg differ
diff --git a/templates/pages/docs/books.html b/templates/pages/docs/books.html
index f798f8e..3bb4a49 100644
--- a/templates/pages/docs/books.html
+++ b/templates/pages/docs/books.html
@@ -12,6 +12,22 @@
 

jkatz

from django.conf import settings
from django.core.mail import send_mail
from django.db import models, transaction
from django.db.models.signals import post_save

from .tasks import *

class Contact(models.Model):
    """store contact information for emailing a user in the address book"""
    user = models.ForeignKey(settings.AUTH_USER_MODEL, help_text="A reference to the User for the purpose of his/her address book")