1. 17
    The Art of PostgreSQL book databases theartofpostgresql.com
  1.  

  2. 12

    A bit expensive.

    1. 5

      I have the Full Edition, and in my opinion it is worth the price. The author literally added CREATE EXTENSION, in addition to many other contributions over the last couple of decades, and takes a clear, deliberate approach to walking the reader through a lot of the useful features and gotchas about Postgres. My knowledge is intermediate, so it fits the bill for me quite nicely - I’m learning new things and don’t feel patronized in either direction (beginner sections or advanced sections). The code samples that come with it are nice too.

      Most of the business logic at my company is written in Postgres functions, and this has proven quite a valuable resource.

      1. 3

        I agree. I’m intrigued, but the ebook price is around what I’d normally pay for a book in print, and I don’t know why I need to share my email address for the sample chapter instead of just downloading it.

        1. 2

          The book price is okay IMO (especially because the author knows his stuff), but the difference between the standard and full edition is insane. It’s twice as much just to get the queries as separate SQL files and a dump of some demo db.

        2. 7

          We’ve been reading this book as a team at work. Contains some interesting ideas that one can apply for their daily work. However, I don’t think the price is justified. It was too expensive.

          More so, there are annoyances like typographical errors, typesetting errors, content flow inefficiencies etc that I feel don’t really justify the price point of this book. I’m all for supporting developers who write compelling books but these are some absolutely simple wins that the author could’ve addressed before publishing

          1. 4

            We’ve been reading this book as a team at work. Contains some interesting ideas that one can apply for their daily work. However, I don’t think the price is justified. It was too expensive.

            It’s 229 for a team license. If it saves you two hours or work you already broke even. Doesn’t sound like a bad deal to me.

            1. 1

              Agreed. The team license isn’t as expensive especially if you can reimburse it.

              1. 1

                I wish I had a boss that counted expenses like that. Unfortunately, he is more of the “look how much your department has cost us this month” type of person.

            2. 3

              I wish the Postgres Internals was in a nice book format like the Design and Implementation of FreeBSD book. This style would probably be a bit more valuable than this book, but I ordered this anyway because it looks like a great general purpose reference.

              http://www.interdb.jp/pg/

              1. 1

                To join and aggregate in all your queries is not supreme excellence. True excellence consists in setting up your application code so it never has to hit the database.

                Wait, wrong Art of PostgreSQL?