mihow

SELECT c.category_name, i.image_id FROM categories c
CROSS JOIN LATERAL (
  SELECT image_id
  FROM image_hashes v
  WHERE v.category_id = c.category_id
  LIMIT 5
) i;

mihow

import requests
from PIL import Image

image = Image.open(requests.get(url, stream=True).raw)

mihow

# Submit a "GET" request via POST so we can send
# more data than fits in a URL

resp = requests.post(
    url,
    headers = {'X-HTTP-Method-Override': 'GET'},
    data=params)

mihow

#!/bin/bash

# USAGE
# bash ./parallel_download.sh url_list.txt

set -o nounset
set -o errexit

FILELIST=$1

mihow

SELECT *, pg_size_pretty(total_bytes) AS total
    , pg_size_pretty(index_bytes) AS index
    , pg_size_pretty(toast_bytes) AS toast
    , pg_size_pretty(table_bytes) AS table
  FROM (
  SELECT *, total_bytes-index_bytes-coalesce(toast_bytes,0) AS table_bytes FROM (
      SELECT c.oid,nspname AS table_schema, relname AS table_name
              , c.reltuples AS row_estimate
              , pg_total_relation_size(c.oid) AS total_bytes
              , pg_indexes_size(c.oid) AS index_bytes

mihow

"""
This works when running code as script, module and with doctests. 
Also sets the log level for imported packages like requests.

python -m mymodule.myfile
python mymodule/myfile.py
python -m unittest mymodule/myfile.py
"""

import logging

mihow

#! /bin/bash

set -o errexit
set -o nounset
set -o xtrace

curl -fsSL https://download.docker.com/linux/ubuntu/gpg | sudo gpg --dearmor -o /usr/share/keyrings/docker-archive-keyring.gpg
echo "deb [arch=$(dpkg --print-architecture) signed-by=/usr/share/keyrings/docker-archive-keyring.gpg] https://download.docker.com/linux/ubuntu \
  $(lsb_release -cs) stable" | sudo tee /etc/apt/sources.list.d/docker.list
sudo apt update

mihow

# Start SSH agent
eval $(ssh-agent)

# Add specific key
ssh-add ~/.ssh/butterfly.pem

# Add default key (if needed for GitHub, etc)
ssh-add

# SSH config entries

mihow

import os
import time
import pathlib
import tarfile
import tempfile

import torch

PROJECT_PATH = pathlib.Path(os.environ.get("PROJECT_PATH", "."))

mihow

worker_processes auto;
rtmp_auto_push on;
events {}
rtmp {
    server {
        listen 1935;
        listen [::]:1935 ipv6only=on;

        application live {
            live on;