> For the complete documentation index, see [llms.txt](https://til.yulrizka.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://til.yulrizka.com/readme.md).

# README

## analytics

[convert json perline to panads data frame](https://til.yulrizka.com/analytics/convert-json-perline-to-panads-data-frame.md)\
[hierarchical data format](https://til.yulrizka.com/analytics/hierarchical-data-format.md)\
[pandas format custom date in data frame](https://til.yulrizka.com/analytics/pandas-format-custom-date-in-data-frame.md)

## bash

[bash forloop](https://til.yulrizka.com/bash/bash-forloop.md)\
[parameter expansion](https://til.yulrizka.com/bash/parameter-expansion.md)\
[prompt confirmation in bash](https://til.yulrizka.com/bash/prompt-confirmation-in-bash.md)

## db

[disabling foreign key when importing dump](https://til.yulrizka.com/db/disabling-foreign-key-when-importing-dump.md)\
[postgres add object to jsonb array from the same column](https://til.yulrizka.com/db/postgres-add-object-to-jsonb-array-from-the-same-column.md)\
[postgres audit log trigger](https://til.yulrizka.com/db/postgres-audit-log-trigger.md)\
[postgres naming trigger](https://til.yulrizka.com/db/postgres-naming-trigger.md)\
[postgres rename enum](https://til.yulrizka.com/db/postgres-rename-enum.md)\
[postgres reset sequence after import](https://til.yulrizka.com/db/postgres-reset-sequence-after-import.md)\
[postgres skip table from restore](https://til.yulrizka.com/db/postgres-skip-table-from-restore.md)\
[set a column with value from different table](https://til.yulrizka.com/db/set-a-column-with-value-from-different-table.md)

## dgraph

[dgraph docker compose whitelist ip](https://til.yulrizka.com/dgraph/dgraph-docker-compose-whitelist-ip.md)

## docker

[docker compose make sure postgres is ready before starting other service](https://til.yulrizka.com/docker/docker-compose-make-sure-postgres-is-ready-before-starting-other-service.md)

## fish

[edit last command in editor](https://til.yulrizka.com/fish/edit-last-command-in-editor.md)

## git

[checkout last branch](https://til.yulrizka.com/git/checkout-last-branch.md)\
[different between two dots and three](https://til.yulrizka.com/git/different-between-two-dots-and-three.md)\
[force fail commit on master](https://til.yulrizka.com/git/force-fail-commit-on-master.md)\
[git finish helper script delete current branch and update master](https://til.yulrizka.com/git/git-finish-helper-script-delete-current-branch-and-update-master.md)\
[git mergetool and diff with p4merge](https://til.yulrizka.com/git/git-mergetool-and-diff-with-p4merge.md)\
[global gitignore file](https://til.yulrizka.com/git/global-gitignore-file.md)\
[intellij as diff and mergetool](https://til.yulrizka.com/git/intellij-as-diff-and-mergetool.md)\
[push only current branch](https://til.yulrizka.com/git/push-only-current-branch.md)\
[reset email multiple commit](https://til.yulrizka.com/git/reset-email-multiple-commit.md)\
[sign commit with pgp](https://til.yulrizka.com/git/sign-commit-with-pgp.md)\
[worktree switching branch without stash](https://til.yulrizka.com/git/worktree-switching-branch-without-stash.md)

## go

[default math.rand.source is thread save while rand.new source is not](https://til.yulrizka.com/go/default-math.rand.source-is-thread-save-while-rand.new-source-is-not.md)\
[deploying go to a vpn ubuntu server with github and ssl](https://til.yulrizka.com/go/deploying-go-to-a-vpn-ubuntu-server-with-github-and-ssl.md)

## k8s

[copy file to pod](https://til.yulrizka.com/k8s/copy-file-to-pod.md)\
[getting cpu and memory usage for container](https://til.yulrizka.com/k8s/getting-cpu-and-memory-usage-for-container.md)\
[how cert manager and letsencrypt challenge works](https://til.yulrizka.com/k8s/how-cert-manager-and-letsencrypt-challenge-works.md)\
[kubernetes resource short name](https://til.yulrizka.com/k8s/kubernetes-resource-short-name.md)\
[scale deployment](https://til.yulrizka.com/k8s/scale-deployment.md)\
[view secret](https://til.yulrizka.com/k8s/view-secret.md)

## linux

[boot zfs root filesystem on grub](https://til.yulrizka.com/linux/boot-zfs-root-filesystem-on-grub.md)\
[clearing up swap space](https://til.yulrizka.com/linux/clearing-up-swap-space.md)\
[connect bluetooth device from cli](https://til.yulrizka.com/linux/connect-bluetooth-device-from-cli.md)\
[free and vmstat command](https://til.yulrizka.com/linux/free-and-vmstat-command.md)\
[get full argument from a process](https://til.yulrizka.com/linux/get-full-argument-from-a-process.md)\
[merge multiple pdf into a single file](https://til.yulrizka.com/linux/merge-multiple-pdf-into-a-single-file.md)\
[removing old kernel](https://til.yulrizka.com/linux/removing-old-kernel.md)\
[symbolic vs hard link](https://til.yulrizka.com/linux/symbolic-vs-hard-link.md)\
[zfs auto snapshot](https://til.yulrizka.com/linux/zfs-auto-snapshot.md)\
[zfs external backup drive with snapshot and encryption](https://til.yulrizka.com/linux/zfs-external-backup-drive-with-snapshot-and-encryption.md)

## net

[dnssec](https://til.yulrizka.com/net/dnssec.md)\
[html form submit to different action depending on properties](https://til.yulrizka.com/net/html-form-submit-to-different-action-depending-on-properties.md)\
[ldap list users](https://til.yulrizka.com/net/ldap-list-users.md)

## osx

[checksum a file from a url](https://til.yulrizka.com/osx/checksum-a-file-from-a-url.md)\
[cluster ssh in iterm2 with i2cssh](https://til.yulrizka.com/osx/cluster-ssh-in-iterm2-with-i2cssh.md)\
[list open port](https://til.yulrizka.com/osx/list-open-port.md)\
[manage clipboard easily with jumpcut](https://til.yulrizka.com/osx/manage-clipboard-easily-with-jumpcut.md)\
[pipe output to clipboard with pbcopy and pbpaste](https://til.yulrizka.com/osx/pipe-output-to-clipboard-with-pbcopy-and-pbpaste.md)\
[show hidden file](https://til.yulrizka.com/osx/show-hidden-file.md)\
[sign application with self certificate](https://til.yulrizka.com/osx/sign-application-with-self-certificate.md)\
[starting program on startup with login items](https://til.yulrizka.com/osx/starting-program-on-startup-with-login-items.md)

## python

[count frequency with lambda](https://til.yulrizka.com/python/count-frequency-with-lambda.md)\
[dijkstra algorithm shortest path](https://til.yulrizka.com/python/dijkstra-algorithm-shortest-path.md)\
[double slash arithmetic operator](https://til.yulrizka.com/python/double-slash-arithmetic-operator.md)\
[min and max of dict values](https://til.yulrizka.com/python/min-and-max-of-dict-values.md)\
[python3 match case](https://til.yulrizka.com/python/python3-match-case.md)\
[reduce and opeator](https://til.yulrizka.com/python/reduce-and-opeator.md)

## react

[react named export vs default export](https://til.yulrizka.com/react/react-named-export-vs-default-export.md)\
[react useeffect](https://til.yulrizka.com/react/react-useeffect.md)\
[react.useref](https://til.yulrizka.com/react/react.useref.md)

## unix

[bulk renaming multiple file](https://til.yulrizka.com/unix/bulk-renaming-multiple-file.md)\
[convert pdf to text using ocr](https://til.yulrizka.com/unix/convert-pdf-to-text-using-ocr.md)\
[diff output of 2 command](https://til.yulrizka.com/unix/diff-output-of-2-command.md)\
[encryption with gpg](https://til.yulrizka.com/unix/encryption-with-gpg.md)\
[extend letsencrypt certificate with dns challenge](https://til.yulrizka.com/unix/extend-letsencrypt-certificate-with-dns-challenge.md)\
[ffmpeg monitor and restart stream when it hung or stall](https://til.yulrizka.com/unix/ffmpeg-monitor-and-restart-stream-when-it-hung-or-stall.md)\
[file size older than x days](https://til.yulrizka.com/unix/file-size-older-than-x-days.md)\
[filtering json with jq](https://til.yulrizka.com/unix/filtering-json-with-jq.md)\
[find lines that matches on 2 different sorted file](https://til.yulrizka.com/unix/find-lines-that-matches-on-2-different-sorted-file.md)\
[find out what is using swap](https://til.yulrizka.com/unix/find-out-what-is-using-swap.md)\
[fish environment variables from 1password](https://til.yulrizka.com/unix/fish-environment-variables-from-1password.md)\
[fix gpg warning unsafe permissions on homedir](https://til.yulrizka.com/unix/fix-gpg-warning-unsafe-permissions-on-homedir.md)\
[formatting or parse json in command line](https://til.yulrizka.com/unix/formatting-or-parse-json-in-command-line.md)\
[get all line except n last one](https://til.yulrizka.com/unix/get-all-line-except-n-last-one.md)\
[grep print only matched](https://til.yulrizka.com/unix/grep-print-only-matched.md)\
[grep using input file as pattern to search other file](https://til.yulrizka.com/unix/grep-using-input-file-as-pattern-to-search-other-file.md)\
[jq counting lenght of an array](https://til.yulrizka.com/unix/jq-counting-lenght-of-an-array.md)\
[jq extracting properties to arrays from json row line](https://til.yulrizka.com/unix/jq-extracting-properties-to-arrays-from-json-row-line.md)\
[keep n recent item in folder](https://til.yulrizka.com/unix/keep-n-recent-item-in-folder.md)\
[open last command in the editor with fc](https://til.yulrizka.com/unix/open-last-command-in-the-editor-with-fc.md)\
[parsing epoch timestamp to date](https://til.yulrizka.com/unix/parsing-epoch-timestamp-to-date.md)\
[pbcopy alternative for copying to clipboard](https://til.yulrizka.com/unix/pbcopy-alternative-for-copying-to-clipboard.md)\
[process pipe operator](https://til.yulrizka.com/unix/process-pipe-operator.md)\
[record a web stream to youtube](https://til.yulrizka.com/unix/record-a-web-stream-to-youtube.md)\
[regex for validating password](https://til.yulrizka.com/unix/regex-for-validating-password.md)\
[rename tmux window](https://til.yulrizka.com/unix/rename-tmux-window.md)\
[repeat content of text x time](https://til.yulrizka.com/unix/repeat-content-of-text-x-time.md)\
[replacing last command and execute it](https://til.yulrizka.com/unix/replacing-last-command-and-execute-it.md)\
[reusing last command argument](https://til.yulrizka.com/unix/reusing-last-command-argument.md)\
[sending curl post with file](https://til.yulrizka.com/unix/sending-curl-post-with-file.md)\
[send slack message from command line](https://til.yulrizka.com/unix/send-slack-message-from-command-line.md)\
[sort file inline](https://til.yulrizka.com/unix/sort-file-inline.md)\
[specify compression level in tar gzip](https://til.yulrizka.com/unix/specify-compression-level-in-tar-gzip.md)\
[zsh ctrl p same behavior as up arrow](https://til.yulrizka.com/unix/zsh-ctrl-p-same-behavior-as-up-arrow.md)

## vim

[paste yanked text on command buffer](https://til.yulrizka.com/vim/paste-yanked-text-on-command-buffer.md)

## web

[this article is published to dev to with github action](https://til.yulrizka.com/web/this-article-is-published-to-dev-to-with-github-action.md)
