emiel

Publish ports on all interfaces. The ports are then accessible from "outside" unless the firewall blocks traffic.

$ docker run -p 80:80 nginx

CONTAINER ID   IMAGE     COMMAND                  CREATED          STATUS         PORTS                               NAMES
16f16f77fc90   nginx     "/docker-entrypoint.…"   10 seconds ago   Up 9 seconds   0.0.0.0:80->80/tcp, :::80->80/tcp   dreamy_neumann

$ ss -t -n state listening 'sport :80'

emiel

# syntax=docker/dockerfile:1

FROM busybox as parent
ARG FOO=123

FROM parent as child
RUN echo "FOO=${FOO}" # "FOO=123"

FROM busybox as final
RUN echo "FOO=${FOO}" # "FOO="

emiel

{
  description = "A very basic flake";

  inputs = {
    nixpkgs.url = "github:nixos/nixpkgs";
    flake-utils.url = "github:numtide/flake-utils";
  };

  outputs = { self, nixpkgs, flake-utils }:
    flake-utils.lib.eachDefaultSystem (system:

emiel

import pandas as pd

import dbconn

engine = dbconn.get_engine_by_name("foo")

result = engine.execute("""
    select table_name, column_name, referenced_table_name, referenced_column_name
    from information_schema.key_column_usage
    where constraint_schema = 'smartpr_api'

emiel

decode_argb = function(argb_val)
{
    /*
    - https://en.wikipedia.org/wiki/RGBA_color_space
    - ARGB (word-order)
    - https://developer.mozilla.org/en-US/docs/Web/CSS/color_value
    */

    return {
        a: (argb_val & 0xff000000) >>> 24,

emiel

create table queue
(
    id integer,
    diff integer
);

create table cache
(
    id integer primary key,
    count integer not null,

emiel

create or replace function sendgrid_eid24_to_uuid(eid text)
returns uuid language sql immutable strict parallel safe
as $function$
    select encode(decode(translate(eid, '-_', '+/'), 'base64'), 'hex')::uuid;
$function$;


create or replace function sendgrid_eid48_to_uuid(eid text)
returns uuid language sql immutable strict parallel safe
as $function$

emiel

def decode_eid(eid):
    """
    Decodes a SendGrid event id (sg_event_id) and returns as uuid
    """
    eid_len = len(eid)

    if eid_len == 22:
        res = uuid.UUID(bytes=base64.urlsafe_b64decode(eid + "=="))
    elif eid_len == 48:
        res = uuid.UUID(base64.urlsafe_b64decode(eid).decode("ascii"))

emiel

--
-- Coming in PostgreSQL 10
-- https://www.postgresql.org/docs/10/static/functions-json.html
--
create or replace function jsonb_delete_array(data jsonb, keys text[])
returns jsonb immutable language sql
as $function$
    select coalesce((
        select jsonb_object_agg(key, value)
        from jsonb_each(data)

emiel

import timeit

t1 = timeit.Timer("doit()", """
def doit():
    def foo(l):
        return [x**2 for x in l]

    def bar(l):
        return [x**2 for x in l]