As a developer, The Art of PostgreSQL is the book you need to read in order to get to the next level of proficiency 

After all, a developers job encompasses more than just writing code. Our job is to produce results, and for that we have many tools at our disposal. SOL is one  of them, and this book teaches vou all about it. 

PostgreSQL is used to manage data in a centralized fashion, and SQL is used to get exactly the result set needed from the application code. An SQL result set is generally used to fill in-memory data structures so that the application can then process the data. So, let's open this book with a quote about data structures and  application code: 

Data dominates. If you've chosen the right data structures and orga­nized things well, the algorithms will almost always be self-evident Data structures, not algorithms, are central to programming. 

-Rob Pike 

About the Book

About the Author

My name is Dimitri Fontaine and I have been using and contributing to Open Source Software for the best of the last 20 years. I am a PostgreSQL Major Contributor after having contributed Extensions and Event Triggers, among other things.

I have been writing code almost daily for a very long time now, both in a professional capacity and on my leisure time. I’ve also been a database architect and a DBA on-call. As a developer I enjoy using SQL. As a database architect, I like teaching advanced SQL techniques to my colleagues.