ekreutz

Reset SERIAL counter for a PostgreSQL database table

For the table my_table with a SERIAL column my_id.

SELECT SETVAL(
  pg_get_serial_sequence('my_table', 'my_id'),
  (SELECT COALESCE(MAX(my_id), 0) FROM my_table)
);

ekreutz

from math import log10, floor
from decimal import Decimal as Dec

# Note: the method spec uses a union type float | Dec introduced in Python 3.10
# Remove the type definitions to make it work with earlier versions.

def round_sd(x: float | Dec, sd: int = 3):
    """Round a value to a specified amount of significant digits `sd`.
    """
    return round(x, sd - int(floor(log10(abs(x)))) - 1)

ekreutz

Update conda

Or, how to update miniconda or Anaconda.

Simply run the following command:

conda update -n base conda

ekreutz

Pixel aspect ratios - a potential issue in object detection?

Updated: Jan 25, 2021

Quick write-up about pixel aspect ratios in video files, and how they might affect performance in an object detection pipeline. I found very little good information about this online, so I decided to write this to summarize my findings.

Tl;dr: scroll down to the "final solution" code, for how to deal with this issue, using Python/OpenCV.

---

ekreutz

Dot-product and Multi-head attention

Dot-product and Multi-head attention from the paper "Attention is all you need" (2017). Implementation in modern Tensorflow 2 using the Keras API.

Example use of the implementations below:

batch_size = 10
n_vectors = 150
d_model = 512

ekreutz

Fix tmux messing with conda

Problem: When running a conda environment and opening tmux on macOS, a utility called path_helper is run again. Essentially, the shell is initialized twice which messes up the ${PATH} so that the wrong Python version shows up within tmux.

Solution

If using bash, edit /etc/profile and add one line. (For zsh, edit /etc/zprofile)

...

ekreutz

Ansible variable precedence

Source: http://docs.ansible.com/ansible/latest/playbooks_variables.html#variable-precedence-where-should-i-put-a-variable

From least to most important

• command line values (for example, -u my_user, these are not variables)
• role defaults (defined in role/defaults/main.yml)
• inventory file or script group vars
• inventory group_vars/all

ekreutz

#!/bin/bash

#
# curl -O https://gist.githubusercontent.com/ekreutz/b245da335cc10b0d270136b35eb22d1f/raw/43c6d07b0b3d3165af9c10cef18e8709a07ce680/resetXcode.sh && bash ./resetXcode.sh ; rm ./resetXcode.sh
#

if [[ $(whoami) != jenkins ]]; then
  echo "Run as jenkins"
  exit 1
fi