Book
失敗から学ぶRDBの正しい歩き方
曽根壮大
Summary
N+1問題、不適切なインデックス、コネクションプールの枯渇など、 バックエンド開発者が陥りやすいDB起因のアンチパターンと解決策を網羅。
Target Readers
- RDBのパフォーマンス問題に悩むエンジニア
- ORMを安全に使いこなしたい開発者
Tags
Colophon
- Publisher
- 技術評論社
- ISBN
- 978-4297104085
- Published
- Mar 2019
- List price
- ¥3,014incl. taxMay differ from the actual selling price on Amazon
Get this book
* The link above is an advertisement via Amazon Associates.Related Books
Prerequisites
- Recommended
Spring徹底入門
株式会社NTTデータ
Reason: Once you handle databases with Spring, the quality of the SQL and table design running behind the ORM starts to govern performance and maintainability. This book teaches the principles of relational design from a practitioner's angle, framed around the antipatterns people commonly fall into.
Sources
- Recommended
SQL実践入門
ミック
Reason: Once you study query tuning and index design, you see that many performance problems trace back to early schema and operational decisions. This Japanese book on RDB pitfalls (失敗から学ぶRDBの正しい歩き方) covers operational anti-patterns—soft deletes, caching, idempotency—lifting your view above optimizing individual SQL statements.
Sources
- Recommended
SQL Antipatterns, Volume 1
Bill Karwin
Reason: Where Karwin's 'SQL Antipatterns' addresses failures at the logical-design and SQL level, the Japanese book '失敗から学ぶRDBの正しい歩き方' addresses RDB pitfalls that surface in production operation. Extending from design-time anti-patterns to operation-time ones gives a full panorama of failure patterns from design through operation.
Sources
- Related
Clean Architecture
Robert C. Martin
Reason: Architecturally, the database sits on the outside as a 'detail,' but neglecting that detail—relational design—breaks down in practice. Learning the antipatterns sharpens your instincts for schema design, reconciling the ideal of abstraction with the reality of implementation.
Sources
- Related
達人に学ぶSQL徹底指南書 第2版
ミック
Reason: Even when you can write applied SQL fluently, the RDB-specific pitfalls you meet in production are a separate body of knowledge. Adding the operational perspective from this Japanese book (失敗から学ぶRDBの正しい歩き方) balances the ability to write SQL with the ability to operate the database.
Sources
Next Books
- Recommended
Designing Data-Intensive Applications
Martin Kleppmann
Reason: Having understood the design of a single relational database, you broaden your view to the big picture of large-scale systems involving multiple data stores. Designing Data-Intensive Applications systematizes the fundamentals of data systems—replication, partitioning, consistency, faults—without being swayed by passing trends.