Book Review – SQL Antipatterns
Imagine having a tool that can automatically detect if you are using JPA and Hibernate properly. Hypersistence Optimizer is that tool!
Introduction
I’ve just finished the wonderful SQL Antipatterns book by Bill Karwin. The book is a must-have reference for any developer that has to interact with a relational database system.
As a #Hibernate Developer Advocate, I want to sharpen my #SQL skills pic.twitter.com/1bAmzzb4Cg
— Vlad Mihalcea (@vlad_mihalcea) December 22, 2016
This post is a review of what this book is all about and why you should be interested in reading it.
Author
Bill Karwin is a distinguished software engineer, having a huge reputation on StackOverflow with gold badges for MySQL, SQL, Database or Database Design.
As I previously explained, contributing to StackOverflow is a great way to become an expert on various programming-related topics, and Bill Karwin is definitely an expert in this field.
Audience
If you are a backend developer, a team leader or a software architect, this book is definitely for you. Especially if you are a junior developer, this book is going to unravel a lot of anti-patterns which are unfortunately way too common in enterprise systems.
Content
The book covers 25 anti-patterns which are grouped into four categories:
- Logical database design anti-patterns
- Physical database design anti-patterns
- Query anti-patterns
- Application development anti-patterns
While I’ve bumped into some of these anti-patterns while developing enterprise systems, I really liked the way they were explained, and especially that we get to see a proper solution to the original problem.
Why you should buy it?
The book is very easy to read, that’s why I think it’s very relevant for junior developers as well.
Designing a database schema is not a trivial task, and it’s much cheaper to take as many good decisions as possible from the very beginning.
After reading SQL Antipatterns, you will be better prepared for designing a relational database system and the data access layer that’s needed for reading and writing to the database server.
All in all, I’m glad I read this book, and I wished I have known all these tricks back when I was a junior developer myself.
Glad you liked my book Vlad! https://t.co/2mQcxkktaa
— Bill Karwin (@billkarwin) January 6, 2017
Download free ebook sample
If you subscribe to my newsletter, you'll get:
- A free sample of my Video Course about running Integration tests at warp-speed using Docker and tmpfs
- 3 chapters from my book, High-Performance Java Persistence,
- a 10% discount coupon for my book.
