Articles

Notes, stories, and half-mad experiments.

Auto-Syncing PostgreSQL Sequences: The One-Query Fix You’ll Wish You Knew Sooner

If you’ve ever restored data, merged dumps, or manually inserted IDs in PostgreSQL, you may have noticed that your SERIAL or IDENTITY columns start throwing duplicate key errors. That’s because the sequence that generates new IDs no longer matches the table’s current maximum. This one-query DO block scans your entire schema, finds every sequence-backed column, and automatically resets each sequence to MAX(id)+1 — safely, cleanly, and in a single pass.

aiAssisted coding database postgres sql

Navigating Leadership in a Complex Engineering Landscape

This article, crafted with AI by summarising themes from the subreddit /r/EngineeringManagers and processed using ~~n8n~~ (moved to my own GenAI Python API setup) to upload to Contentful, explores crucial issues faced by engineering leaders today, including team dynamics, technical decisions, and career growth. Insights and experiences shared by managers uncover the nuances of effective leadership in engineering.

genAi

From Stalled to Strong: Real Weight Loss Journeys That Inspire

This article was written using AI by summarising themes from the subreddit /r/progresspics and built using n8n to automatically upload into Contentful as a pre-published (draft) article. It weaves the threads of discipline, setback, and community into a single narrative about lasting change. The piece highlights how sustainable nutrition, steady training, recovery, and mindset shifts intersect across diverse journeys.

aiAssisted genAi n8n

🇿🇦 Why South Africans Punch Above Their Weight in Global Business

South Africans stand out worldwide for their resilience, resourcefulness, and cultural fluency. Shaped by a diverse and often volatile environment, they bring grit, creativity, and a global mindset to business. From adaptability in uncertain markets to servant-leadership rooted in Ubuntu, South Africans excel at finding opportunity where others see risk — making them uniquely effective on the world stage.

aiAssisted