bioquro

i PostgreSQL Performance Tuning in 2026: The 5 Queries That Killed Our Database PostgreSQL Performance 2026 Guide May 18, 2026  · 15 min read PostgreSQL Performance Tuning in 2026: The 5 Queries That Killed Our Database 👤 Tahar Maqawil — Senior Application Developer & Database Architect Informaticien d'Application · Performance Engineer · Bioquro 10+ years optimizing PostgreSQL — from single-instance deployments to multi-terabyte clusters There is a particular sound a database makes when it is dying. It is not a sound in the server room — it is the sound of your phone vibrating at 2:47am with a PagerDuty alert. The dashboard is red. The application is timing out. And somewhere deep in the PostgreSQL logs, a query is running that should take 50 milliseconds and is currently taking 47 seconds. I have debugged this scenario more times than I want to admit. And in almost every case, the ...

OAuth 2.1 vs OAuth 2.0 in 2026: The Migration Guide That Prevents a Security Audit Failure OAuth 2.1 Security Migration Guide May 16, 2026  · 14 min read OAuth 2.1 vs OAuth 2.0 in 2026: The Migration Guide That Prevents a Security Audit Failure 👤 Tahar Maqawil — Senior Application Developer & Systems Architect Informaticien d'Application · Security Engineer · Bioquro 10+ years implementing, auditing, and migrating OAuth in production systems I still remember the subject line: "Urgent — Security Audit Finding: OAuth implicit grant." It arrived on a Thursday afternoon. The auditor had flagged our authentication service for supporting the implicit grant, which OAuth 2.1 formally deprecates. We had 14 days to respond with a remediation plan, or the finding would escalate to a compliance violation. The implicit grant had been in our codebase for six years. Nobody had touched it. It still...

PostgreSQL Performance Tuning in 2026: The 5 Production Disasters That Taught Me Everything PostgreSQL Production 2026 Guide May 11, 2026  · 13 min read PostgreSQL Performance Tuning in 2026: The 5 Production Disasters That Taught Me Everything 👤 Tahar Maqawil — Senior Application Developer & Database Engineer Informaticien d'Application · Systems Architect · Bioquro 10+ years tuning PostgreSQL databases from 50MB hobby projects to 2TB production systems I want to be upfront about something: every PostgreSQL tuning guide you have ever read — including ones from people much smarter than me — gives you the right answers to the wrong question. They tell you what to set shared_buffers to. They tell you to enable pg_stat_statements . They give you a list of 20 parameters and a general formula. What they do not tell you is what it looks and feels like when your database is actively on f...