Databases

I treat the database as an active part of the architecture, not just storage. I model for the read and write patterns that actually occur, watch indexes, transactions and query cost, and optimise only where the data and the execution plan point me.

PostgreSQL, MySQL, MongoDB, SQL, Prisma, TypeORM, Mongoose, Data Modeling, Indexes, Transactions, Query Optimization, Migrations, Constraints, EXPLAIN, Replication