cloverink

du -h /path/to/directory | sort -h

cloverink

SELECT * FROM information_schema.tables
WHERE table_schema = '[schema_name]'

cloverink

git branch | grep -v "master" | xargs git branch -D

git branch | grep -v "development" | xargs git branch -D

cloverink

import dayjs from 'src/common/day';

const k = 'abcdefghijklmnopqustuvwxyz0123456789';

const generateBit = (word: number[], index: number) =>
  word[0] + index >= k.length
    ? k[(word[0] + index) % k.length]
    : k[word[0] + index];

const generateKey = (n: number, word: number[] = []) => {

cloverink

const crypto = require('crypto')

const checksum = (str, algorithm = 'md5', encoding = 'hex') => {
  return crypto
    .createHash(algorithm)
    .update(str, 'utf8')
    .digest(encoding)
}

module.exports = {

cloverink

docker run -d \
  --name redis-local \
  -p 6379:6379 redis:alpine redis-server \
  --appendonly yes \
  --requirepass xxxxx 

cloverink

# place this after nvm initialization!
autoload -U add-zsh-hook
load-nvmrc() {
  local nvmrc_path="$(nvm_find_nvmrc)"

  if [ -n "$nvmrc_path" ]; then
    local nvmrc_node_version=$(nvm version "$(cat "${nvmrc_path}")")

    if [ "$nvmrc_node_version" = "N/A" ]; then
      nvm install

cloverink

du -d 1 -h node_modules/ | grep prisma

cloverink

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'db-name-1'
AND pid <> pg_backend_pid();
CREATE DATABASE "db-name-2"
WITH TEMPLATE "db-name-1"
OWNER produsr;

cloverink

select
  date_trunc('minute', created_at), -- or hour, day, week, month, year
  count(1)
from users
group by 1;