Reddit Reddit reviews SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)

We found 10 Reddit comments about SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers). Here are the top ones, ranked by their Reddit score.

Computers & Technology
Books
Databases & Big Data
Data Modeling & Design
SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers)
Used Book in Good Condition
Check price on Amazon

10 Reddit comments about SQL Antipatterns: Avoiding the Pitfalls of Database Programming (Pragmatic Programmers):

u/VanFailin · 23 pointsr/programming

I can totally believe that that code made it to production, especially while a site is still growing, but if they needed an expert to tell them not to use LIKE queries...

The book on SQL Antipatterns has my favorite cover ever, and it's a great presentation.

u/ircmaxell · 4 pointsr/PHP

I'd strongly suggest that you get the book SQL Antipatterns.

Specifically Polymorphic Associations starting on slide 32. It's detailed in the book, but the slide gives you some good information.

Basically, solution #3 where you use a base parent table. Store the content, title and date in a common "content" table, then store the content-specific information in sub-tables.

u/forgetfulcoder · 3 pointsr/learnphp

PHP The Right Way is good.

If you want something for SQL I strongly recommend SQL Antipatterns.

If you want something more abstract, Head First Design Patterns is good. It uses Java in its examples but it applies to PHP too.

u/Armorweave · 3 pointsr/learnprogramming

Fundamentals of Database Systems, it covers a broad range of topics about databases including database design theory, normalisation and data modeling.

SQL Antipatterns is a really great book.

u/mrmonkeyriding · 2 pointsr/webdev

I buy books because they go into a lot more details, or often are written really well, and easy to follow. Also, it's really nice to read paper. Often I keep books in the office as it's a quick and reliable way to research a topic in-depth without scrolling through hundreds of shit articles on a particular (and even controversial subject).

I really recommend these:

High Performance MySQL: Optimization, Backups, and Replication - I've read snippets, but it's recommended a lot and very good for more advanced readers.

SQL Antipatterns: Avoiding the Pitfalls of Database Programming - VERY beginner friendly, easy to read, follow, provides real and common scenarios and explains the anti-pattern, it's problems, the reasons to sometime excuse their use, and solutions. I love this book.

The Go Programming Language - Very good read, not TOO technical jargon, very nice to read, explains in depth and in an understandable way.

I've had plenty more over the years, but these are my current I have at home. Still more on order. :)

u/gram3000 · 2 pointsr/Database

I think it would depend on your data and how its being used. There's a great book 'SQL Anti patterns' that explains different approaches, pros and cons and suggests alternatives: https://www.amazon.co.uk/SQL-Antipatterns-Programming-Pragmatic-Programmers-x/dp/1934356557

u/rbatra · 2 pointsr/SQL
u/AQuietMan · 2 pointsr/DatabaseHelp

I think the best first book you can get is Bill Karwin's SQL Antipatterns. That book alone will keep you from making most of the mistakes that come back to bite new designers.

u/MeGustaDerp · 1 pointr/SQL

Ah... I was thinking about getting that book. What did you think about it overall?

Just a link for future reference