PostgreSQL4 min read
A Practical Guide to PostgreSQL Indexing
B-tree, GIN, partial and composite indexes — how PostgreSQL actually uses them, when each earns its disk, and the questions to ask before adding another index.
Tag
#database-design
2 articles
Architecture5 min read
Multi-Tenant Database Strategies: Row-Level Security vs. Schema-per-Tenant
Shared schema, schema-per-tenant and a hybrid mix of both — how to choose a multi-tenant database model from day one, with real trade-offs for PostgreSQL, row-level security and analytics.
Work together
Building something similar?
I design and build production-ready web applications, SaaS platforms and backend APIs — from data modelling to deployment. If a project or technical challenge is on your roadmap, let's talk it through.