What is pgRouting? It's a PostgreSQL extension for developing network routing applications and doing graph analysis.
Interested in pgRouting? If so, chances are you already use PostGIS, the spatial extender for the PostgreSQL database management system. So when you've got PostGIS, why do you need pgRouting? PostGIS is a great tool for molding geometries and doing proximity analysis, however, it falls short when your proximity analysis involves constrained paths such as driving along a road or biking along defined paths.
PostGIS alone can't help you apply costs and resource constraints to your travels, such as traffic congestion, mileage restrictions, or allocating resources like vehicles. pgRouting is a complement to PostGIS that allows you to incorporate costs and path restrictions to your proximity analysis.
pgRouting is well suited to building travel navigation systems and computing driving distance polygons for places of interest. While the main focus of pgRouting is GIS applications, it can be used for non-GIS resource management and routing applications.
This book will give you all the tools and information you need to get started with pgRouting, as well as complete code examples and even how to deploy your project to the web.

pgRouting: A Practical Guide

Computers & Technology

Obe, Regina O.

Hsu, Leo S.

Programming Languages

Locate Press

If you're thinking about migrating to the PostgreSQL open source database system, this guide provides a concise overview to help you quickly understand and use PostgreSQL's unique features. Not only will you learn about the enterprise class features in the 9.2 release, you'll also discover that PostgeSQL is more than just a database system--it's also an impressive application platform. With numerous examples throughout this book, you'll learn how to achieve tasks that are difficult or impossible in other databases. If you're an existing PostgreSQL user, you'll pick up gems you may have missed along the way.

PostgreSQL: Up and Running

O'Reilly Media

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.2, 9.3, and 9.4, you'll also discover that PostgeSQL is more than a database system--it's also an impressive application platform. With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This second edition covers LATERAL queries, augmented JSON support, materialized views, and other key topics. If you're a current PostgreSQL user, you'll pick up gems you may have missed before. 
<ul>
<li>Learn basic administration tasks such as role management, database creation, backup, and restore</li>
<li>Apply the psql command-line utility and the pgAdmin graphical administration tool</li>
<li>Explore PostgreSQL tables, constraints, and indexes</li>
<li>Learn powerful SQL constructs not generally found in other databases</li>
<li>Use several different languages to write database functions</li>
<li>Tune your queries to run as fast as your hardware will allow</li>
<li>Query external and variegated data sources with foreign data wrappers</li>
<li>Learn how to use built-in replication features to replicate data</li>
</ul>

Networking & Cloud Computing

Thinking of migrating to PostgreSQL? This clear, fast-paced introduction helps you understand and use this open source database system. Not only will you learn about the enterprise class features in versions 9.5 to 10, you’ll also discover that PostgeSQL is more than a database system—it’s an impressive application platform as well.
With examples throughout, this book shows you how to achieve tasks that are difficult or impossible in other databases. This third edition covers new features, such as ANSI-SQL constructs found only in proprietary databases until now: foreign data wrapper (FDW) enhancements; new full text functions and operator syntax introduced in version 9.6; XML constructs new in version 10; query parallelization features introduced in 9.6 and enhanced in 10; built-in logical replication introduced in Version 10.e.
If you’re a current PostgreSQL user, you’ll pick up gems you may have missed before.
<ul>
<li>Learn basic administration tasks such as role management, database creation, backup, and restore</li>
<li>Apply the psql command-line utility and the pgAdmin graphical administration tool</li>
<li>Explore PostgreSQL tables, constraints, and indexes</li>
<li>Learn powerful SQL constructs not generally found in other databases</li>
<li>Use several different languages to write database functions</li>
<li>Tune your queries to run as fast as your hardware will allow</li>
<li>Query external and variegated data sources with foreign data wrappers</li>
<li>Learn how to use built-in replication to replicate data</li>
</ul>

PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database

For programmers, analysts, and database administrators, this Nutshell guide is the essential reference for the SQL language used in today's most popular database products. This new fourth edition clearly documents SQL commands according to the latest ANSI/ISO standard and details how those commands are implemented in Microsoft SQL Server 2019 and Oracle 19c, as well as in the MySQL 8, MariaDB 10.5, and PostgreSQL 14 open source database products. 
You'll also get a concise overview of the relational database management system (RDBMS) model and a clear-cut explanation of foundational RDBMS concepts--all packed into a succinct, comprehensive, and easy-to-use format. 
Sections include: Background on the relational database model, including current and previous SQL standards Fundamental concepts necessary for understanding relational databases and SQL commands An alphabetical command reference to SQL statements, according to the SQL:2016 ANSI standard The implementation of each command by MySQL, Oracle, PostgreSQL, and SQL Server An alphabetical reference of the ANSI SQL:2016 functions and constructs as well as the vendor implementations Platform-specific functions unique to each implementation

SQL in a Nutshell: A Desktop Quick Reference

Kline, Kevin

Programming

See the best price to sell, buy, or rent books by Obe, Regina O.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Obe, Regina O.

See the best price to sell, buy, or rent books by Obe, Regina O.. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

pgRouting: A Practical Guide

PostgreSQL: Up and Running

PostgreSQL: Up and Running

PostgreSQL: Up and Running: A Practical Guide to the Advanced Open Source Database

SQL in a Nutshell: A Desktop Quick Reference