Partitioning PotgreSQL Database

Introduction In one of the projects I used to work on, we’ve employed CQRS approach with PostgreSQL as a write storage and NoSQL database as a read storage. As a safety measure, we had a special endpoint that allowed us to regenerate entire content of the read storage based on the write storage that is … Devamını oku

Best Database Monitoring Tools in 2026: A PostgreSQL DBA’s Guide

myDBA.dev dashboard showing health score, active connections, query performance, and replication status

Best Database Monitoring Tools in 2026: A Comprehensive Guide Your database is the one component in your stack where a monitoring gap turns into a production incident. Application bugs are annoying. Database problems are existential — data loss, cascading failures, hours of downtime that wipe out months of trust. A memory leak in your API … Devamını oku

Title Screen, Power-ups and Sound

Over the past week, I added a title screen and main menu. Sticking with my mostly-vibecoded theme, I just handed Chat GPT the 3 source images that I used for the 3d models and asked it to make a nice title screen background. I also wanted a fancier HUD, which took longer than I expected … Devamını oku

I’ve seen both sides of credential management — neither works

I’ve spent years in both federal IT and the private sector. Different budgets, different compliance regimes, different acronyms. Same problem. Nobody has a good answer for “what’s expiring and when?” The enterprise side On the federal side, there’s no shortage of tooling. CyberArk for privileged accounts. Venafi or AppViewX for certificate lifecycle. SailPoint for identity … Devamını oku

Claude Codeで冪等コンシューマーを設計する:重複メッセージ処理・処理済みID管理・at-least-once保証

はじめに 「メッセージブローカーの再配信で同じ注文が2回処理された」——at-least-once配信を前提とした冪等コンシューマーで、重複メッセージを安全に処理する設計をClaude Codeに生成させる。 CLAUDE.mdに冪等コンシューマー設計ルールを書く ## 冪等コンシューマー設計ルール ### メッセージID追跡 – 全メッセージにグローバルユニークID(ULID/UUID)を付与 – 処理済みIDをRedisに保存(TTL: 7日 = メッセージ再配信窓口の2倍) – 処理前にRedis SET NX でロック取得(二重処理防止) ### 処理結果キャッシュ – 成功した処理の結果をキャッシュ(同じIDが再来たら結果を返す) – 失敗した処理は未処理扱い(リトライを許可) – キャッシュミスかつロック取得できない場合は待機 ### データベース側の冪等性 – INSERT … ON CONFLICT DO NOTHING(重複挿入を無視) – UPDATE … WHERE processed_message_id != ‘id’(条件付き更新) 冪等コンシューマー実装の生成 冪等コンシューマーを設計してください。 要件: – Redis SET NX による重複排除 – 処理結果キャッシュ – … Devamını oku

Why finding where a product is made is an AI problem

The GS1 barcode prefix indicates where the brand is registered, not where the product is manufactured. It matches the actual manufacturing country about 40% of the time.

A barcode tells you where a product was registered. Not where it was made. Pick up any product at the grocery store. Flip it over. See that barcode? The first three digits tell you which country it was registered in. Starts with 300-379? France. 400-440? Germany. 890? India. Most people (including me, before I started … Devamını oku