View gist:de1b3c9c332a20d5c9ec3d1715c13e37
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 |
View gist:5a36cfce7219384bd16a79aee7cec6bb
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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: |
View password.js
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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'); | |
} |
View quickstart-postgresql-cert.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
View encrypt_password.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
# Copyright 2019-2022 Jonathan S. Katz | |
# | |
# MIT License | |
# | |
# Permission is hereby granted, free of charge, to any person obtaining a copy | |
# of this software and associated documentation files (the "Software"), to deal | |
# in the Software without restriction, including without limitation the rights | |
# to use, copy, modify, merge, publish, distribute, sublicense, and/or sell | |
# copies of the Software, and to permit persons to whom the Software is | |
# furnished to do so, subject to the following conditions: |
View scram_poc.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
import base64 | |
import hashlib | |
import hmac | |
import re | |
import secrets | |
import socket | |
class SCRAMAuthentication(object): | |
AUTHENTICATION_METHOD = b"SCRAM-SHA-256" | |
DIGEST = hashlib.sha256 |
View setup.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
View setup.sh
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
#!/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 |
View gist:ca333b411831833ef2d089097448f6da
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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 @@ | |
View models.py
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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") |
NewerOlder