> 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](/analytics/convert-json-perline-to-panads-data-frame.md)\
[hierarchical data format](/analytics/hierarchical-data-format.md)\
[pandas format custom date in data frame](/analytics/pandas-format-custom-date-in-data-frame.md)

## bash

[bash forloop](/bash/bash-forloop.md)\
[parameter expansion](/bash/parameter-expansion.md)\
[prompt confirmation in bash](/bash/prompt-confirmation-in-bash.md)

## db

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

## dgraph

[dgraph docker compose whitelist ip](/dgraph/dgraph-docker-compose-whitelist-ip.md)

## docker

[docker compose make sure postgres is ready before starting other service](/docker/docker-compose-make-sure-postgres-is-ready-before-starting-other-service.md)

## fish

[edit last command in editor](/fish/edit-last-command-in-editor.md)

## git

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

## go

[default math.rand.source is thread save while rand.new source is not](/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](/go/deploying-go-to-a-vpn-ubuntu-server-with-github-and-ssl.md)

## k8s

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

## linux

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

## net

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

## osx

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

## python

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

## react

[react named export vs default export](/react/react-named-export-vs-default-export.md)\
[react useeffect](/react/react-useeffect.md)\
[react.useref](/react/react.useref.md)

## unix

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

## vim

[paste yanked text on command buffer](/vim/paste-yanked-text-on-command-buffer.md)

## web

[this article is published to dev to with github action](/web/this-article-is-published-to-dev-to-with-github-action.md)