akaak

MongoDB → PostgreSQL Data Migration Plan (v2)

Context

The existing eRegs production app stores data in MongoDB (5 collections: users, employers, usersubscriptions, transactions, employees). The new eRegs app uses PostgreSQL via Prisma. This plan migrates all paid subscriber data — users, organizations, subscriptions, transactions, and drivers — into the new schema. Scripts must be idempotent (safe to run multiple times) to support staging validation before production execution.

---

Phase 1: Schema Additions (Prisma)

akaak

MongoDB → PostgreSQL Data Migration Plan

Context

The existing eRegs production app stores data in MongoDB (5 collections: users, employers, usersubscriptions, transactions, employees). The new eRegs app uses PostgreSQL via Prisma. This plan migrates all paid subscriber data — users, organizations, subscriptions, transactions, and drivers — into the new schema. The scripts must be idempotent (safe to run multiple times) to support staging validation and production execution.

---

Phase 1: Schema Additions (Prisma)

akaak

Development workflow and orchestration

via @stasbel based on @bcherny tweet https://x.com/bcherny/status/2017742741636321619?s=20

1. Plan Node Default

• Enter plan mode for ANY non-trivial task (3+ steps or architectural decisions)
• If something goes sideways, STOP and re-plan immediately — don't keep pushing
• Use plan mode for verification steps, not just building
• Write detailed specs upfront to reduce ambiguity

akaak

"""
Gmail cleanup helper.

Searches your Gmail account for messages matching `query` and batch-moves them to
Trash via the Gmail API (requires `credentials.json`; creates/uses `token.json`).

Last updated Jan 30, 2026 by @akaak to be used for cleaning up the gmailinbox.
"""
import os.path
from google.auth.transport.requests import Request

akaak

Policies, standards and procedures for Manufacturing Organizations by Kiran Adapa

How do policies, standards and procedures look for manufacturing organizations that are in regulated industries such as the automotive sector? Anyone focused on safety reporting such as regulatory experts, security managers, and compliance experts should review the following:

• Principles: Fundamental beliefs that guide all organizational decisions and culture.

• Policies: Formal statements of intent that establish direction and boundaries for business conduct and compliance. Sets a broad rule to guide decisions and ensure security or participation.

• Standards: Specific, measurable requirements that ensure policies are consistently implemented across operations. Specifies exact technical requirements needed to uphold the policy. Baseline defines the minimum acceptable level or criteria to comply with the policy.

akaak

marp	theme	paginate
true	default	true

Understanding Toil in Software Engineering

Insights from Google SRE

• Toil is repetitive, manual work that scales with system growth

akaak

akaak

akaak

If you are a developer and use Visual Studio Code (VSCode), then I recommend that you use GistPad

https://aka.ms/gistpad

Super helpful to view and work with your gists right within VSCode

Does automatic sync with your github and use VSCode interface to view, write and udpate your gists.

Build your own workflow to take notes, build knowledge base that is your own!

akaak

How to run http server on your local?

as of Jan 2025, Option (1) still is my preferred way of running http server on my macbook!

1) Using Python

Python comes pre-installed on macOS and provides a simple way to start a local server:

1. For Python 3: