The Art of PostgreSQL
I&#x27;m a web developer (React &#x2F; Node.js) and I bought the first edition of this book (it was called Mastering PostgreSQL in Application Development then).  I can say that it really changed the way I approach building apps.  I definitely lean on the database <i>a lot</i> more now.  No more &quot;models&quot;, ORMs &#x2F; query builders, and crunching data in app code.  Just build your schema, write plain sql queries, and you&#x27;re off to the races.  As a bonus, I&#x27;m also much more comfortable with Postgres&#x27; built in command line tool, psql.<p>The scope of the book is pretty broad.  You&#x27;ll cover psql setup, a little relational theory, some nuts and bolts about the inner workings of Postgres, indexing strategy, data types, aggregates, window functions, common table expressions, etc.  Given the scope, it&#x27;s difficult to cover everything in depth, so I&#x27;d treat this book as more of an introduction to what&#x27;s possible.<p>Highly recommended.