Goutham Pilla

Create User and Database Create user webapp, database webappdb and grant all privileges to user. To generate random passwords I use: https://passwordsgenerator.net/ CREATE DATABASE webappdb; CREATE USER 'webapp'@'%' identified by "LbAh52s6MnKQZasH"; GRANT ALL PRIVILEGES ON webappdb.* TO 'webapp'@'%' Grant read-only permission Grant read-only permission to user webapp_ro to database webappdb GRANT SELECT ON webappdb.* TO 'webapp_ro'@'%'; Export to CSV from mysql shell SELECT * FROM <> WHERE <> INTO OUTFILE '/tmp/output.csv' FIELDS TERMINATED BY ',' ENCLOSED BY '"' LINES TERMINATED BY '\n'; Load CSV from mysql shell LOAD DATA LOCAL INFILE '<path-to-csv-file>' INTO TABLE <table_name> enclosed by '"' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; Create index CREATE INDEX <index_name> ON <table_name>(<column_name>); Get size of tables SELECT TABLE_SCHEMA AS `Database`, TABLE_NAME AS `Table`, ROUND((DATA_LENGTH + INDEX_LENGTH) / 1024 / 1024) AS `Size (MB)` FROM information_schema. …

To list all jobs in Delayed Job queue Delayed::Job.all

\? - help \l - list databases \c <db name> - to connect to a database \d - to list tables Create database CREATE DATABASE <DB_NAME>; CREATE USER <DB_USER> WITH PASSWORD '<PASSWORD>'; GRANT ALL PRIVILEGES ON DATABASE "<DB_NAME>" TO "<DB_USER>"; Backups and Restoring pg_dump -U <DB_USER> -Fp <DB_NAME> > <DB_DUMP_FILENAME> psql -U <DB_USER> -d <DB_NAME> -f <DB_DUMP_FILENAME>

Notes Column numbering starts with $1 in print. $0 will print the entire line To read CSV awk -F "," '{print $6}' <file_name.csv>

To renew all certs kubectl cert-manager renew --all -n <namespace> Get all resources at once kubectl get <resource_name> | awk '{print $1}' | grep -vi name | xargs -I{} sh -c 'kubectl get <resource_name> {} -o yaml > {}.yaml' kubectl get deployments | awk '{print $1}' | grep -vi name | xargs -I{} sh -c 'kubectl get deployment {} -o yaml > {}.yaml' Apply all resources in a directory kubectl apply -f . kubectl apply -f <directory> --recursive

Postgres shell psql postgres Create User and Database Create user webapp, database webappdb and grant all privileges to user. To generate random passwords I use: https://passwordsgenerator.net/ CREATE DATABASE webappdb; CREATE USER webapp WITH PASSWORD 'DXw3BzFsNERfPwjg'; GRANT ALL PRIVILEGES ON DATABASE "webappdb" TO "webapp"; Grant read-only permission Grant read-only permission to user webapp_ro to database webappdb GRANT SELECT ON ALL TABLES IN SCHEMA webappdb TO webapp;

Cmd + J - Switch to a note or a notebook Cmd + n - Create a new note in the current notebook

Get all Helm Chart versions helm search repo <repo name>/<chart name> --versions helm search repo jenkins/jenkins --versions Installing a specific Helm Chart version helm install <release name> <repo name>/<chart name> -n <namespace> --version <version> helm install jenkins jenkins/jenkins -n jenkins -f jenkins_values.yaml --version 3.4.0

Capturing the list of podcasts I listened over the year. How to Get rich - Naval Ravikant Founders Talk (Changelog) - Leading Auth0 to a $6.5 billion acquisition Founders Talk (Changelog) - The journey to massive scale and ultra-resilience - Cockroach DB Changelog - Inside 2021’s infrastructure for Changelog.com Go Time (Changelog) - Event-driven systems Changelog - Curl is a full-time job (and turns 23) Go Time (Changelog) - Why writing is important Think Like a CEO - Season-5 Episode-1: Financial Wealth and Freedom Think Like a CEO - Season-5 Episode 2: The 8 MythUnderstandings Between You and Financial Wealth …

To apply a single resource terraform apply -target=<resource_type>.<local_name> eg: terraform apply -target=google_sql_database_instance.instance To get a single resource from the state file terraform state show '<resource_type>.<local_name>' eg: terraform state show 'kubernetes_secret.cloudsqlproxy-SA' To delete a single resource from the state file terraform state rm '<resource_type>.<local_name>' eg: terraform state rm 'kubernetes_secret.cloudsqlproxy-SA'