Building Multi-Tenant SaaS with SQLAlchemy Row-Level Security
Implement tenant isolation at the database layer using SQLAlchemy's session management and PostgreSQL policies to prevent data leaks in production SaaS applications.
Production notes on Python, FastAPI, React, security architecture and AI-augmented development. No tutorials — actual patterns from deployed systems.
Implement tenant isolation at the database layer using SQLAlchemy's session management and PostgreSQL policies to prevent data leaks in production SaaS applications.
How to design scalable, queryable audit logs in PostgreSQL without performance degradation using partitioning, JSON columns, and smart indexing.
Astro ships zero JavaScript by default and lets you opt in to interactivity exactly where you need it — through a pattern called Islands Architecture. Here's how it works, why it's fast, and when it's the right choice.
How I built the AI chat widget in CitizenApp — a floating React component that sends natural language questions to Claude, optionally executes safe live SQL queries, and renders the results inline. Architecture decisions, pitfalls, and patterns that generalize.
Not a productivity tips list. A concrete walkthrough of how I use Cursor and Claude API through an entire feature — from architecture decision to shipped code — on a real FastAPI + React project.
Running your React frontend on Vercel Edge and your FastAPI backend on Render Docker isn't just cost optimisation — it's an architecture decision with real production consequences. Here's the full breakdown.
AI tools don't write your architecture — they amplify it. Here's exactly how I use Claude, Cursor and GitHub Copilot across a real production project, and where human judgment is irreplaceable.
React 19 ships with new primitives — Actions, useOptimistic, use() — that change how you think about async state. Here's how they interact with TanStack Query v5, and which patterns I've settled on after shipping with both.
Most JWT implementations have a silent security flaw: refresh tokens that never expire. Here's how to implement proper rotation with reuse detection in FastAPI.
GDPR compliance isn't a checkbox — it's an architectural decision. Here's what needs to be in place at the infrastructure level before you write the first business logic line.
No posts for this tag yet.