Mastering PostgreSQL in Application Development is the full title of the book I am currently writing. Running the PostgreSQL is YeSQL series of blog posts has shown me developers need a PostgreSQL book for developers. A book with the same properties as the YeSQL series articles in this blog:
- we use real world data sets to put every query and SQL technique we learn in the context of a user story or business case,
- we include practical ideas about daily developer’s concerns on how to actually integrate SQL in your application’s code base, code review processes, versioning, testing and deployment,
- we explain and teach basic and advanced SQL concepts, with a progression, and hints on use cases when you might need to use the same technics,
- we provide best practices and alternative ideas for advanced topics where there’s no one size fits all solution possible,
- we include sample code in different programming languages, code that you can actually run, and which solves a simple but real use case.
In Mastering PostgreSQL in Application Development every query uses a real world dataset that is available for download and easy to load into your local PostgreSQL instance. Scripts to load the data are provided, including clean-up and reformating scripts when necessary. It means that you can actually run and edit every single query used in the book against the same data set!
