mowings

Install pandoc, basic-tex and mermaid-filter

# brew install pandoc
# brew install --cask basictex
# npm i -g mermaid-filter

# Be sure to run the path_helper in an existing shell. Otherwise pdf-latex won't be found
# eval "$(/usr/libexec/path_helper)"

Convert an markdown to pdf

mowings

https://dev.to/aws-builders/how-to-run-a-shell-on-ecs-fargate-containers-eo1

Install session manager plugin locally

NOTE: It looks like the task default policy ALSO needs the ssm permissions as well. This CDK construct appears to copy those in; pulumi or other providers may not do the same.

Be sure that exec-command is set in the service definition. Via CDK:

mowings

Diagrams as python code. Supports cloud infra as well as c4

https://diagrams.mingrammer.com/

Structerizr -- best for C4, UML. More for software arch.

https://github.com/structurizr/dsl/blob/master/docs/language-reference.md

C4 Home

https://c4model.com/

mowings

Sometimes you may need to manually request a certificate from Let's Encrypt. The easiest wat to do this is to run certbot manually from the most current Docker image:

docker run -v `pwd`/cert:/etc/letsencrypt/archive -it certbot/certbot certonly --preferred-challenges dns --manual

Answer the prompts. You will be asked to create TWO acme challenge TXT records named _acme-challenge.fubar.com (where fubar.com is your domain name).

Note that if you use AWS route53 for DNS management, you will add two lines, one for each TXT value, in the dialog data field for the _acme-challenge dns record create, instead of creating two TXT records with the same name (this is just how the route53 UI works).

mowings

This applications runs entirely local in your browser and can be used to convert any AWS resource into IaC (CloudFront, Terraform, CDK, Puumi, etc):

Convert AWS Resources to IaC via API

mowings

# nim c -d:FLAGS tensorflow.nim
#
# FLAGS
# -d:capiDL
# -d:capiSetVer=

import os

import nimterop/[build, cimport]

mowings

SELECT
    sum(heap_blks_read) as heap_read,
    sum(heap_blks_hit) as heap_hit,
    sum(heap_blks_hit) / (sum(heap_blks_hit) + sum(heap_blks_read)) as cache_hit_ratio
FROM pg_statio_user_tables;

mowings

Montioring postgres replication status

Use the following query at the source cluster to check status and lag (lag is in bytes):

select   application_name, pid, client_addr, state, sync_state,
         pg_wal_lsn_diff(sent_lsn, write_lsn) as write_lag,
         pg_wal_lsn_diff(sent_lsn, flush_lsn) as flush_lag,
         pg_wal_lsn_diff(sent_lsn, replay_lsn) as replay_lag
from pg_stat_replication;

mowings

aws --profile turbosquid-research rds describe-orderable-db-instance-options --engine aurora-postgresql \
   --engine-version 13.4 --db-instance-class db.r6g.xlarge \
   --region us-east-1

mowings

https://www.reddit.com/r/PostgreSQL/comments/dqg8qs/some_tips_on_optimizing_postgres_on_amazon/

https://explain.depesz.com/