Название: SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming
Автор: Bill Karwin
Издательство: Pragmatic Bookshelf
Год: November 2022 (Version: P1.0)
Страниц: 379
Язык: английский
Формат: pdf (true), epub, mobi
Размер: 10.2 MB, 10.2 MB

SQL is the ubiquitous language for software developers working with structured data. Most developers who rely on SQL are experts in their favorite language (such as Java, Python, or Go), but they're not experts in SQL. They often depend on antipatterns - solutions that look right but become increasingly painful to work with as you uncover their hidden costs. Learn to identify and avoid many of these common blunders. Refactor an inherited nightmare into a data model that really works. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand new mini-antipatterns for quick wins.

No matter which platform, framework, or language you use, the database is the foundation of your application, and the SQL database language is the standard for working with it. Antipatterns are solutions that look simple at the surface, but soon mire you down with needless work. Learn to identify these traps, and craft better solutions for the often-asked questions in this book. Avoid the mistakes that lead to poor performance and quality, and master the principles that make SQL a powerful and flexible tool for handling data and logic.

Dive deep into SQL and database design, and learn to recognize the most common missteps made by software developers in database modeling, SQL query logic, and code design of data-driven applications. See practical examples of misconceptions about SQL that can lure software projects astray. Find the greatest value in each group of data. Understand why an intersection table may be your new best friend. Store passwords securely and don't reinvent the wheel. Handle NULL values like a pro. Defend your web applications against the security weakness of SQL injection.

The second edition of SQL Antipatterns is updated with the latest observations about common mistakes of SQL and data-driven application development. Feedback about the first edition has been addressed. Internet resources are updated to reference current sites and the latest information.
A number of all-new “mini-antipatterns” appear in between the existing chapters. These briefly cover all-new types of blunders and describe “quick wins” you can use to avoid them.

The code examples are updated to be compatible with the latest versions of MySQL and Python, the most popular open source database and dynamic programming language in today’s technology market.

Use SQL the right way - it can save you from headaches and needless work, and let your application really shine!

What You Need:
The SQL examples use the MySQL 8.0 flavor, but other popular brands of RDBMS are mentioned. Other code examples use Python 3.9+ or Ruby 2.7+.

Who This Book Is For:
SQL Antipatterns is for any software developer who needs to use SQL—which is virtually all software developers. It doesn’t matter whether you’re a beginner or a seasoned professional. People at all levels of experience will benefit from the subjects in this book. You may have read a reference on SQL syntax. Now you know all the clauses of a SELECT statement, and you can get some work done. Gradually, you increase your SQL skills by reading code, books, and blogs. In spite of this, it’s hard to tell if you’re learning best practices, or another way to paint yourself into a corner.

You may find some topics in SQL Antipatterns that are well known to you. You’ll see new ways of looking at the problems, even if you’re already aware of the solutions. It’s good to reinforce your good practices by reviewing widespread programmer misconceptions, and the reasons we avoid them.
It’s not uncommon for the relationship between developers and database administrators to be contentious. If you’re a DBA, this book can help you explain good practices to the software developers you work with and the consequences of straying from that path.