Insights · 8 articles
Notes on production debugging, PostgreSQL, secure SaaS, and applied AI, plus the occasional side quest. Some come with a companion video on YouTube.
8 articles
A step-by-step path from opening a new database connection on every request to running behind PgBouncer in transaction mode: what to measure, what breaks along the way, and how to keep tenant context safe when connections are shared.
Python
PostgreSQLPerformancePgBouncerWhat fan-out/fan-in actually promises, why it fails fast, and the principles for building batch pipelines that keep the good work, report the bad, and never delete on incomplete data.
AzurePythonHow NULL semantics can quietly weaken tenant isolation, and how to make PostgreSQL security checks fail closed.
PostgreSQL
SecurityBuild a personal AI assistant on Raspberry Pi with ZeroClaw, Telegram, and optional local models.
Linux
AIAn easy setup and quickstart guide for GraphQL
Node.js
GraphQLHow I built Stocktrix, a FastAPI and Next.js app that summarizes financial news and predicts stock sentiment.
Development
FastAPI
Next.jsHow to track location offline and without GPS?
DevelopmentPython
Harsis Yadav