Having trouble reading this email? View it in your browser.
New This Week

SQL Antipatterns, Vol. 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. This shortcut to wisdom shows you how to avoid “easy” solutions that don’t work, and how to be a better database developer in any language. Updated for the current versions of MySQL and Python, this new edition adds a dozen brand-new mini-antipatterns for quick wins.

Hero's Journey Podcast »

Tim and Tammy are back with the final episode of the first season of the Pragmatic Hero's Journey podcast. This month, our hosts chat with Ken Kousen, author of Help Your Boss Help You.

Recently Released:

 

Best Sellers:

Make sure you haven't missed anything!

  1. Concurrent Data Processing in Elixir
  2. Hands-on Rust
  3. Programming Phoenix LiveView
  4. Testing Elixir
  5. Become an Effective Software Engineering Manager

See all best sellers...

SQL Antipatterns, Volume 1; Podcast
August 18, 2021

SQL Antipatterns, Volume 1: Avoiding the Pitfalls of Database Programming

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 on 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!

Now available in beta from pragprog.com/titles/bksap1.

The Pragmatic Hero’s Journey Podcast: Ken Kousen

Ken Kousen is a Java Champion and Oracle Developer Champion. He's also the author of Help Your Boss Help You and co-host of the Groovy Podcast.

On this episode, Ken talks about how he got interested in writing books and how his latest book, Help Your Boss Help You, got its start. He also explains the concept of the prisoner's dilemma, and how it relates to managing people.

Listen to the rest of Ken's story on this episode of the Pragmatic Hero's Journey podcast.

You can stream the episode here: https://pragprog.libsyn.com/ or subscribe to the RSS feed at https://pragprog.libsyn.com/rss.

You Could Be a Published Author

Is there a tech topic you are deeply passionate about and want to share with the rest of us? You could become a published Pragmatic Bookshelf author! Take a look at our pragprog.com/become-an-author page for details, including our 50% royalty (yes, for real!) and world-class development editors.

Remember, the best way to tell the future is to create it.

Upcoming Author Appearances

  • 2021-08-25 Johanna Rothman, Product Management Today
  • 2021-09-21 Kenneth Kousen, ApacheCon 2021, online
  • 2021-09-24 Kenneth Kousen, New England Software Symposium, Boston, MA
  • Don't Get Left Out

    Are your friends jealous that you get these spiffy email newsletters and they don't? Clue them in that all they need to do is sign up at pragprog.com.

    Tell your friends! Tweet this

    Follow us on Twitter for the latest news, commentary, and occasional discounts: @pragprog, Andy Hunt @PragmaticAndy.

    By Professional Developers, for Professional Developers
    PragProg.com

    Sent by the Pragmatic Programmers, LLC. • 9650 Strickland Rd Ste 103-255• Raleigh NC 27615