These are a couple of tools that are commonly used with PostGIS for building mapping applications. Some of these we demonstrate in PostGIS in Action and PostGIS in Action 2ed.
We are working on second edition of PostGIS in Action 2ed for availability sometime in Early 2015. Early purchase review (MEAP) is now available for Second Edition: All 17 chapters now available on MEAP with code and data download on PostGIS In Action Edition 2 Chapters. With MEAP you can get chapter updates as we write/update them and get the final polished copy at release time in both E-Book and Hard-copy form. Each purchase includes all E-Book versions including E-book version of 1st edition.
PostgreSQL: Up and Running, 1st Edition is out in both E-book and hard-copy. You can order hard-copy now from Amazon or Kindle
or hard-copy or e-Book from O'Reilly. We are hard at work on the second edition of PostgreSQL: Up and Running, 2nd addition as well. The 2nd edition is feature complete and E-book draft version is available now direct from O'reilly. Hard copy will be out 4th quarter 2014 and with focus on PostgreSQL 9.3-9.4.