marcelmaatkamp

---
from sqlalchemy import create_engine
engine = create_engine('postgresql://postgres:postgres@postgres:5432/postgres', echo=False)

---
import pandas as pd

with engine.connect() as connection:
    df = pd.read_sql('ais', connection)
df

marcelmaatkamp

$ \
 sudo apt-get install -y \
  apt-transport-https \
  ca-certificates \
  curl \
 &&\
 curl -fsSL https://apt.releases.hashicorp.com/gpg | \
  sudo apt-key add - &&\
 sudo apt-add-repository \
  "deb [arch=$(dpkg --print-architecture)] https://apt.releases.hashicorp.com $(lsb_release -cs) main" &&\

marcelmaatkamp

$ \
 sudo apt-get remove \
  docker docker-engine docker.io containerd runc &&\
 sudo apt-get update &&\
 sudo apt-get install \
    ca-certificates \
    curl \
    gnupg \
    lsb-release &&\
 curl -fsSL https://download.docker.com/linux/ubuntu/gpg | \

marcelmaatkamp

#!/bin/bash
wget -qO - https://packagecloud.io/shiftkey/desktop/gpgkey | sudo tee /etc/apt/trusted.gpg.d/shiftkey-desktop.asc > /dev/null
sudo sh -c 'echo "deb [arch=amd64] https://packagecloud.io/shiftkey/desktop/any/ any main" > /etc/apt/sources.list.d/packagecloud-shiftkey-desktop.list'
sudo apt-get update
sudo apt install github-desktop 

marcelmaatkamp

#!/bin/bash
sqlite3 files.db 'CREATE TABLE files( id INTEGER PRIMARY KEY AUTOINCREMENT, sum TEXT NOT NULL, size INT NOT NULL, date DATE NOT NULL, directory TEXT NOT NULL, filename TEXT NOT NULL, extension TEXT NOT NULL);'

id=0
find . -type f | while read file; do
 IFS=$'\n'

 sum=$(sha256sum $file | awk '{print $1}')
 stat=$(stat -c %y,%s $file)
 date=$(echo $stat | awk -F"," '{ print $1 }')

marcelmaatkamp

find . -type f -name \*.txt -printf '%s|%p\n'

marcelmaatkamp

$ kubectl apply -f https://raw.githubusercontent.com/kubernetes/ingress-nginx/master/deploy/static/provider/kind/deploy.yaml
$ kubectl port-forward --address 0.0.0.0 -n ingress-nginx service/ingress-nginx-controller 8443:443

marcelmaatkamp

version: '3'

services:
  reverse-proxy:
    image: traefik:v2.3.4
    command:
      # Docker swarm configuration
      - "--providers.docker.endpoint=unix:///var/run/docker.sock"
      - "--providers.docker.swarmMode=true"
      - "--providers.docker.exposedbydefault=false"

marcelmaatkamp

traefik

$ \
  kubectl create namespace traefik &&\
  kubectl apply -f - <<EOF
---
apiVersion: v1
kind: Secret
metadata:
  name: cloudflare-api-credentials

marcelmaatkamp

traefik

$ \
  kubectl create namespace traefik &&\
  kubectl apply -f - <<EOF
---
apiVersion: v1
kind: Secret
metadata:
  name: cloudflare-api-credentials