DB

Aws Dynamodb Notes

QUERY aws dynamodb scan --table-name "orders"

Postgres Notes

postgres in docker https://github.com/wubigo/docker-compose/blob/main/docker-compose-psql.yml 启用pg_stat_statements docker volume inspect root_postgresql_data |grep "Mountpoint" echo "shared_preload_libraries = 'pg_stat_statements'" > /var/lib/docker/volumes/root_postgresql_data/_data/pgdata/postgresql.conf INSTALL sudo apt-get install -y postgresql-client psql --version TEST psql -h cmp.clv6a9yh.ap-northeast-1.rds.amazonaws.com -U postgres postgres=> \list List of databases Name | Owner | Encoding | Collate | Ctype | Access privileges -----------+----------+----------+-------------+-------------+----------------------- postgres | postgres | UTF8 | en_US.UTF-8 | en_US.UTF-8 | rdsadmin | rdsadmin | UTF8 | en_US.UTF-8 | en_US.