SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming (Paperback)
暫譯: SQL 反模式，第 1 卷：避免資料庫程式設計的陷阱 (平裝本)

Karwin, Bill

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming (Paperback)
  • 出版商: Pragmatic Bookshelf
  • 出版日期: 2022-11-29
  • 定價: $1,680
  • 售價: 8.8 折 $1,478
  • 語言: 英文
  • 頁數: 340
  • 裝訂: Quality Paper - also called trade paper
  • ISBN: 1680508989
  • ISBN-13: 9781680508987
  • 相關分類: SQL、Design Pattern 、資料庫

    • 立即出貨 (庫存=1)

買這商品的人也買了...

相關主題

商品描述

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.

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+.

商品描述(中文翻譯)

SQL 是軟體開發人員處理結構化數據的普遍語言。大多數依賴 SQL 的開發人員在他們喜愛的語言（如 Java、Python 或 Go）方面是專家，但他們並不是 SQL 的專家。他們經常依賴反模式——看似正確但隨著揭露其隱藏成本而變得越來越痛苦的解決方案。學會識別並避免這些常見的失誤。將繼承的噩夢重構為真正有效的數據模型。本書針對當前版本的 MySQL 和 Python 進行了更新，新增了十幾個全新的迷你反模式，以便快速獲得成果。

無論您使用哪個平台、框架或語言，數據庫都是您應用程序的基礎，而 SQL 數據庫語言則是與之交互的標準。反模式是表面上看起來簡單的解決方案，但很快會讓您陷入不必要的工作中。學會識別這些陷阱，並為本書中經常被詢問的問題設計更好的解決方案。避免導致性能和質量不佳的錯誤，掌握使 SQL 成為處理數據和邏輯的強大且靈活工具的原則。

深入了解 SQL 和數據庫設計，學會識別軟體開發人員在數據庫建模、SQL 查詢邏輯和數據驅動應用程序的代碼設計中最常見的失誤。查看有關 SQL 的誤解的實際範例，這些誤解可能會使軟體專案偏離正軌。從每組數據中找到最大的價值。了解為什麼交集表可能是您新的最佳夥伴。安全地存儲密碼，並且不要重複造輪子。像專業人士一樣處理 NULL 值。保護您的網頁應用程序免受 SQL 注入的安全弱點。

正確使用 SQL——它可以幫助您避免頭痛和不必要的工作，讓您的應用程序真正閃耀！

您需要的內容：

SQL 範例使用 MySQL 8.0 版本，但也提到其他流行的 RDBMS 品牌。其他代碼範例使用 Python 3.9+ 或 Ruby 2.7+。

作者簡介

Bill Karwin has been a software engineer for over thirty years, developing and supporting applications, libraries, and servers, and consulting for leading technology companies. Throughout his career, Bill has shared his knowledge to help other programmers achieve success and productivity. Bill has answered thousands of questions, giving him a unique perspective on SQL mistakes that most commonly cause problems.

作者簡介(中文翻譯)

比爾·卡爾溫擁有超過三十年的軟體工程師經驗，開發和支援應用程式、函式庫和伺服器，並為領先的科技公司提供諮詢服務。在他的職業生涯中，比爾分享了他的知識，幫助其他程式設計師實現成功和提高生產力。比爾回答了數千個問題，使他對最常引起問題的 SQL 錯誤有了獨特的見解。

類似商品