Skip to content

Instantly share code, notes, and snippets.

View detj's full-sized avatar
🖥️
deep into work

Debjeet Biswas detj

🖥️
deep into work
View GitHub Profile
@detj
detj / caddy-certs.txt
Created October 24, 2025 12:35
caddy certificates location
Where caddy on ubuntu stores the actual certificates
/var/lib/caddy/.local/share/caddy/certificates/acme-v02.api.letsencrypt.org-directory/domain/domain.key
/var/lib/caddy/.local/share/caddy/certificates/acme-v02.api.letsencrypt.org-directory/domain/domain.crt
@detj
detj / list-tables-postgresh.sql
Last active October 18, 2025 13:17
List tables in postgres with custom schema
# List tables when using a custom schema other than 'public' in postgres
# 'BASE TABLE' table_type filter ensures only tables are listed and not views
#
# Replace <schema-name> with your schema name
select table_name from information_schema.tables where table_schema = '<schema-name>' and table_type = 'BASE TABLE';
@detj
detj / clear-dns.sh
Created October 18, 2025 11:24
clear DNS cache on macOS Tahoe
# need admin password
sudo dscacheutil -flushcache; sudo killall -HUP mDNSResponder
@detj
detj / homebrew-package-disk-usage.sh
Last active October 11, 2025 13:26
List disk usage by homebrew packages
# Usage by formulae
echo "=== Formulae ==="
du -sh $(brew --cellar)/* 2>/dev/null | sort -h
# Usage by casks
echo "=== Casks ==="
du -sh /opt/homebrew/Caskroom/* 2>/dev/null | sort -h
@detj
detj / list-roles-predefined-role.sh
Last active October 8, 2025 19:52
List IAM roles for a predefined role
# List all the roles for a predefined role
#
# gcloud iam roles describe [PREDEFINED_ROLE]
gcloud iam roles describe roles/owner
gcloud iam roles describe roles/editor
gcloud iam roles describe roles/viewer
@detj
detj / read-x509.sh
Created October 8, 2025 12:32
Read an x509 certificate
# assuming the certificate is in a file at /tmp/cert.txt
cat /tmp/cert.txt | openssl x509 -text -noout
@detj
detj / isObject.js
Created October 2, 2025 09:57
isObject(something)
// Check if 'something' is just a plain JavaScript object
// like a map of keys and values.
function isObject(something) {
const type = Object.prototype.toString.call(something);
return something === Object(something) && type !== "[object Array]" && type !== "[object Function]" && type !== "[object Date]" && type !== "[object RegExp]" && type !== "[object Set]" && type !== "[object Map]";
}
// truthy
console.log("{}", isObject({}));
console.log("Object.create(null)", isObject(Object.create(null)))
@detj
detj / manage-gcloud-regions.sh
Last active September 29, 2025 06:26
Google Cloud Regions and Zones
# List all Google Cloud regions and zones
#
# It may ask to enable the [compute.googleapis.com] API if it has not been enabled earlier.
gcloud compute zones list
# List all Google Cloud zones of a region
gcloud compute zones list | rg us-central
# Set the default region for a configuration
gcloud config set compute/region REGION_NAME
@detj
detj / gcloud-configurations.sh
Created September 29, 2025 05:55
Manage Google Cloud CLI Configurations
# List all configurations
gcloud config configurations list
# Activate a configuration
gcloud config configurations activate CONFIGURATION_NAME
# Rename a configuration
gcloud config configurations rename CONFIGURATION_NAME --new-name=NEW_NAME
@detj
detj / list-gcloud-enabled-services.sh
Last active October 8, 2025 19:50
List Enabled Google Cloud Services
# List all the enabled Google Cloud APIs
gcloud services list --enabled