Paul SerbanSoftware Engineer
  • PORTFOLIO
  • BLOG

#Database Indexing

Posts

  • SQL Patterns, Anti-Patterns, and Pitfalls: A Practical Guide for EngineersHow to write SQL that scales, stays correct, and doesn't quietly rot your database

    A practical guide to SQL design patterns, common anti-patterns, and performance pitfalls, with concrete examples for engineers who work with relational databases daily.

    • #Database Engineering
    • #Software Architecture
    • #SQL
    • #Query Optimization
    • #Database Indexing
  • Using PostgreSQL to Replace DynamoDB: A Practical Migration GuideHow to model DynamoDB-style access patterns in PostgreSQL without losing the flexibility that made NoSQL appealing in the first place

    A practical, engineering-focused guide to replacing DynamoDB with PostgreSQL: schema design, indexing, transactions, and where the tradeoffs really bite.

    • #Database Engineering
    • #Software Architecture
    • #PostgreSQL
    • #DynamoDB
    • #JSONB
View all posts
  • LinkedInLinkedIn
  • GitHubGitHub
  • HackerRankHackerRank
  • LeetCodeLeetCode
  • EmailEmail
  • Portfolio
  • My Projects
  • Coursework
  • Blog
  • Posts
  • Snippets
  • Book Notes
  • Cookie Settings
  • Cookie Policy
2026 © Paul Serban. All rights reserved.www.paulserban.eu | Sitemap