darknoon

-- This function is based on this description:
-- https://docs.aws.amazon.com/AmazonS3/latest/API/sigv4-query-string-auth.html

CREATE OR REPLACE FUNCTION
sign_s3_url(
  m_host text,
  m_verb text,
  m_resource text,
  m_region text,
  m_key text,

loilo

Vue: Pass Slots through from Parent to Child Components

The Situation

• We've got some components A, B and C which provide different slots.

  const A = {
    template: `<div><slot name="a">Default A Content</slot></div>`
  }

const B = {

SagiMedina

import EXIF from 'exif-js';

const hasBlobConstructor = typeof (Blob) !== 'undefined' && (function checkBlobConstructor() {
    try {
        return Boolean(new Blob());
    } catch (error) {
        return false;
    }
}());

gurix

DROP TABLE IF EXISTS survey_sessions;
-- Imagine a table with survey sessions
-- token: some id or token to access a survey
-- answers: a key value store for answers
CREATE TABLE survey_sessions (
  token text,
  answers hstore);

-- We need some data to play with
INSERT INTO survey_sessions (token, answers) VALUES ('9IaxxP', 'a=>1, b=>2');

jeaneric

"""
SMTP->SES Relay Server
Author: Brian Humphrey, Loku.com
E-mail: bhump@loku.com
Date:   August 17, 2011

A Lightweight SMTP server that accepts all messages and relays them to SES

Credit to http://www.doughellmann.com/PyMOTW/smtpd/ for a tutorial on smtpd with asyncore

gist:5814504

 WITH
  -- write the new values
 n(ip,visits,clicks) AS (
    VALUES ('192.168.1.1',2,12),
           ('192.168.1.2',6,18),
           ('192.168.1.3',3,4)
 ),
  -- update existing rows
 upsert AS (
    UPDATE page_views o

gist:5814404

 UPDATE election_results o
 SET votes=n.votes, pro=n.pro
 FROM ( VALUES (1,11,9),
               (2,44,28),
               (3,25,4)
      ) n(county_id,votes,pro)
 WHERE o.county_id = n.county_id;