detj

#!/usr/bin/env bash

git describe --tags --abbrev=0

detj

rclone mount <remote-name>:<bucket-name> <local-dir> \
    --daemon \
    --devname <device-name> \
    --allow-other \
    --vfs-cache-mode full \
    --vfs-cache-max-size 10G \
    --log-level INFO \
    --log-file /tmp/rclone-vfs-remote-mount.log

detj

# "test" is the input
printf "test" | openssl dgst -sha256 -binary | openssl base64

# output - n4bQgYhMfWWaL+qgxVrQFaO/TxsrC4Is0V1sFbDwCgg=

detj

brew list --installed-on-request

detj

# syntax
# gh repo view <repo> --json createdAt

# example
gh repo view measure-sh/measure --json createdAt

detj

--------------
-- query cache
--------------

-- see full details of query cache entries
SELECT
    substring(query, 1, 30),
    result_size,
    tag,
    stale,

detj

# syntax - assuming a `docker-compose.yml` file is present at $(PWD)
docker compose logs --no-log-prefix -f <compose-service-name> | agrind '(*) AND NOT ("string-one" OR "string-two")'

# example
docker compose logs --no-log-prefix -f my-compose-service | agrind '(*) AND NOT ("ping" OR "traces export")'

# combine angle grinder with tailspin
docker compose logs --no-log-prefix -f my-compose-service | agrind '(*) AND NOT ("ping" OR "traces export")' | tspin -ce

detj

# Manipulating data by combining various modern terminal utilities like fd, dasel, rg and so on.

# Working with single files. Let's assume there is a `data.json` file with the following contents.
# [
#   {
#     "id": "some-id-1",
#     "attribute": {
#       "some-key-1": "some-value-1",
#       "some-key-2": "some-value-2",
#       "some-key-3": "some-value-3"

detj

Backup:
docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

Restore:
cat your_dump.sql | docker exec -i your-db-container psql -Upostgres

detj

#!/usr/bin/env bash

# Syntax
# awk '{gsub("\\n", "\n"}; print' <file>

# Example
awk '{gsub("\\n", "\n"}; print' some-file.txt