Database DevPro

This site focuses on database performance and reliability from an architect’s perspective:
reasoning about execution plans, trade-offs, and operational reality.

Practical database engineering, with evidence

#

I publish reproducible labs and clear guides on databases—focused on what actually matters in production:

• Query planning and diagnostics (EXPLAIN / EXPLAIN ANALYZE)
• Index design and performance tuning
• Reliability patterns (HA/DR, backups, recovery)
• Cloud database operations (AWS RDS/Aurora notes where relevant)
• Decision-making frameworks for architects (trade-offs, triggers, checklists)

Start here

#

Hands-on Labs (reproducible evidence)

#

• Labs — reproducible experiments with real execution plans and metrics
  
  • PostgreSQL Index vs Full Scan: EXPLAIN ANALYZE on 100k / 1M / 5M Rows (Filter + ORDER BY + LIMIT)

Structured Guides (principles & playbooks)

#

• Guides — concepts, patterns, and decision frameworks
• PostgreSQL Guides
• MySQL Guides

Database-specific entry points

#

• PostgreSQL Labs
• MySQL Labs (coming next)

What I value

#

• Clarity over buzzwords
• Plan + evidence over opinions
• Incremental, measurable improvements
• Operational readiness (monitoring, runbooks, drills)

About the author

#

I’m a software engineer (21+ years) preparing for Enterprise Architect / Cloud Architect roles in Ireland, with a strong focus on databases, reliability, and pragmatic architecture.

If you want to discuss a topic or point out an issue, feel free to reach out via the links in the footer.

Network note:
DatabaseDevPro.com is part of the DevPro network of technical sites, with DevProPortal.com serving as the central directory and navigation hub.

Each DevPro site focuses on a specific technical domain and publishes independent, in‑depth content within that scope.