repodevs

export GOROOT="$(go1.17 env GOROOT)"
PATH_add "$(go1.17 env GOROOT)/bin"

export GO111MODULE=on
export GOFLAGS=-mod=vendor
export CGO_ENABLED=0

repodevs

# get count postgres idle connection for database
$ watch -n 1 psql -U myuser -d mydb -c \"select count\(\*\) from pg_stat_activity where state in \(\'idle\', \'idle in transaction\'\) and datname = \'mydb\'\"

repodevs

SELECT 
  id, name
FROM table_users
WHERE 1=1
  [[ AND name = ANY(STRING_TO_ARRAY({{ user_name }}, ',')) ]]

-- `user_name` is metabase variables, type: Text
-- `','` is the delimeter
-- usage: in variablse `user_name` -> `Sky,Blue,Green`
-- it's will equal to `AND name IN ('Sky', 'Blue', 'Greem')

repodevs

#!/bin/bash

# filter by name
docker ps -a -f name=^/sentry

# filter by name only container id
docker ps -a -q -f name=^/sentry

# filter by name then remove
docker rm $(docker ps -a -q -f name=^/sentry)

repodevs

Kiro System Prompt used in .github/instructions/system-prompt.instructions.md

source: https://github.com/ghuntley/amazon-kiro.kiro-agent-source-code-analysis

repodevs

https://prod.download.desktop.kiro.dev/stable/metadata-dmg-darwin-arm64-stable.json

repodevs

Usage

Download file video_compressor.sh

Make it Executeable by chmod +x video_compressor.sh

Run the script ./video_compressor.sh source_video 15

• 15 is target new size in MB

repodevs

Usage of upgrade_addons.sh script

• Download it
• Make it Executeable with chmod +x upgrade_addons.sh
• Use it

./upgrade_addons.sh DATABASE ADDONS_A_TO_UGRADE,ADDONS_B_TO_UPGRADE

repodevs

## [public internet] -> [Load Balancer: e.g Alicloud SLB, AWS ELB, etc] -> [nginx proxy] -> [odoo service]
#odoo server
upstream odoo {
  least_conn;
  server 127.0.0.1:8079;
  server 172.16.116.10:8079; # server prod 2
  # server 172.16.116.10:8079 down; # exclude from load balance
  # add more server here
}

repodevs

when erorr mach-o file, but is an incompatible architecture (have 'x86_64', need 'arm64')
do

$ cd path/to/odoo
$ pip install -r requirements.txt

# uninstall packagaes that not compatile with M1
$ pip uninstall psycopg2 lxml libsass -y

# re-install using arch64