Database Design and Modeling with PostgreSQL and MySQL
A guide to designing efficient, scalable relational databases in PostgreSQL and MySQL — data modeling, keys and constraints, transactions and concurrency, query optimization, and advanced features such as views, stored procedures, and triggers.
Database Design and Modeling with PostgreSQL and MySQL starts with the differences between SQL and NoSQL databases and hands-on setup of both engines, then works through core design concepts — keys, constraints, transactions, and concurrency — and on to query optimization, views, stored procedures, and triggers, ending with best practices and where database design is heading. Examples are shown for both PostgreSQL and MySQL, and the code is on GitHub.
The authors are Alkin Tezuysal, a long-time MySQL community figure, and Ibrar Ahmed, a PostgreSQL database architect. Published by Packt in 2024.
Community feedback
This space is for grounded, evaluable experience — versions used, environments, what you measured or observed, and how it behaves alongside other software. General impressions without supporting detail may be removed. Sign in to write one; posts are tied to a verified identity, not anonymous.