sloev sloev

debug psql statements

when you get stuff like this:

5 UTC [1] LOG:  database system is ready to accept connections
db_1                | 2021-11-24 09:58:49.133 UTC [83] ERROR:  invalid input value for enum task_status: "ready" at character 339
db_1                | 2021-11-24 09:58:49.133 UTC [83] STATEMENT:  BEGIN;

its nice to be able to quickly figure out where the error is in the input sql file.

replace INPUT_RTSP_STREAMLINK and OUTPUT_RTSP_STREAMLINK with rtsp://yadayada
pip install opencv-python numpy tqdm
python process_rtsp_to_image.py
bash publish_image_to_rtsp.sh

Git pre-push hook

It will check if current branch is master, then ask a confirmation, in case of master branch

install

install a recent version of git (https://git-scm.com/download/mac) eg:

$ brew install git

why cors? https://stackoverflow.com/questions/59577407/uncaught-in-promise-domexception-failed-to-execute-teximage2d-on-webgl2ren

facemesh? https://blog.tensorflow.org/2020/11/iris-landmark-tracking-in-browser-with-MediaPipe-and-TensorFlowJS.html

	#!/bin/bash

	# append-only kv-store using jq as querying mechanism
	# author: sloev.github.io


	# declare kv store as string
	kv_store=""

	# append some json to

	from multiprocessing.dummy import Pool

	import subprocess
	import tempfile
	import logging
	import time
	import random
	import os
	from base64 import urlsafe_b64encode
	import uuid

	import cv2
	import csv
	import numpy as np

	img = cv2.imread("img.png")



	data_file = open("data.data", "wb")
	csv_file = open("data.csv", "w")

	#!/bin/bash

	# EXAMPLE:
	# $ cat production.env
	#
	# DB_HOST="foo=bar bas=10"
	# DB_PORT=5432
	# DB_PASSWORD=$DB_PASSWORD
	#
	# $ cat test.yaml

	import msgpack
	from typing import Optional

	from fastapi import FastAPI, Response
	from starlette.requests import Request
	from fastapi.responses import HTMLResponse
	import crypto
	import json
	import secrets
	app = FastAPI()


	<script>
	function beep() {
	var snd = new Audio("data:audio/wav;base64,//uQRAAAAWMSLwUIYAAsYkXgoQwAEaYLWfkWgAI0wWs/ItAAAGDgYtAgAyN+QWaAAihwMWm4G8QQRDiMcCBcH3Cc+CDv/7xA4Tvh9Rz/y8QADBwMWgQAZG/ILNAARQ4GLTcDeIIIhxGOBAuD7hOfBB3/94gcJ3w+o5/5eIAIAAAVwWgQAVQ2ORaIQwEMAJiDg95G4nQL7mQVWI6GwRcfsZAcsKkJvxgxEjzFUgfHoSQ9Qq7KNwqHwuB13MA4a1q/DmBrHgPcmjiGoh//EwC5nGPEmS4RcfkVKOhJf+WOgoxJclFz3kgn//dBA+ya1GhurNn8zb//9NNutNuhz31f////9vt///z+IdAEAAAK4LQIAKobHItEIYCGAExBwe8jcToF9zIKrEdDYIuP2MgOWFSE34wYiR5iqQPj0JIeoVdlG4VD4XA67mAcNa1fhzA1jwHuTRxDUQ//iYBczjHiTJcIuPyKlHQkv/LHQUYkuSi57yQT//uggfZNajQ3Vmz+Zt//+mm3Wm3Q576v////+32///5/EOgAAADVghQAAAAA//uQZAUAB1WI0PZugAAAAAoQwAAAEk3nRd2qAAAAACiDgAAAAAAABCqEEQRLCgwpBGMlJkIz8jKhGvj4k6jzRnqasNKIeoh5gI7BJaC1A1AoNBjJgbyApVS4IDlZgDU5WUAxEKDNmmALHzZp0Fkz1FMTmGFl1FMEyodIavcCAUHDWrKAIA4aa2oCgILEBupZgHvAhEBcZ6joQBxS76AgccrFlczBvKLC0QI2cBoCFvfTDAo7eoOQInqDPBtvrDEZBNYN5xwNwxQRfw8ZQ5wQVLvO8OYU+mHvFLlDh05Mdg7BT6YrRPpCBznMB2r//xKJjyyOh+cImr2/4doscwD6neZjuZR4AgAABYAAAABy1xcdQtxYBYYZdifkUDgzzXaXn98Z0oi9