StackShareStackShare
Follow on
StackShare

Discover and share technology stacks from companies around the world.

Follow on

© 2025 StackShare. All rights reserved.

Product

  • Stacks
  • Tools
  • Feed

Company

  • About
  • Contact

Legal

  • Privacy Policy
  • Terms of Service
pgRouting
ByDanielDaniel

pgRouting

#237in Databases
Discussions1
Followers24
OverviewDiscussions1AdoptionAlternativesIntegrations
Try It

What is pgRouting?

It is an extension of PostGIS and PostgreSQL geospatial database and adds routing and other network analysis functionality.

pgRouting is a tool in the Databases category of a tech stack.

Key Features

All Pairs Shortest Path, Johnson’s AlgorithmAll Pairs Shortest Path, Floyd-Warshall AlgorithmShortest Path A*Bi-directional Dijkstra Shortest PathBi-directional A* Shortest PathShortest Path DijkstraDriving DistanceK-Shortest Path, Multiple Alternative PathsK-Dijkstra, One to Many Shortest PathTraveling Sales PersonTurn Restriction Shortest Path (TRSP)

pgRouting Pros & Cons

Pros of pgRouting

  • ✓Dynamic routing
  • ✓Data changes are reflected instantaneously
  • ✓Geospatial network analysis
  • ✓Open Source
  • ✓QGIS plugin
  • ✓Routing in the database

Cons of pgRouting

No cons listed yet.

pgRouting Alternatives & Comparisons

What are some alternatives to pgRouting?

Slick

Slick

It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred.

Spring Data

Spring Data

It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database.

Dataform

Dataform

Dataform helps you manage all data processes in your cloud data warehouse. Publish tables, write data tests and automate complex SQL workflows in a few minutes, so you can spend more time on analytics and less time managing infrastructure.

DB

DB

With DB you can very easily save, restore, and archive snapshots of your database from the command line. It supports connecting to different database servers (for example a local development server and a staging or production server) and allows you to load a database dump from one environment into another environment.

Liquibase

Liquibase

Liquibase is th leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process.

DataGrip

DataGrip

A cross-platform IDE that is aimed at DBAs and developers working with SQL databases.

Try It

Visit Website

Adoption

On StackShare

pgRouting Integrations

PostgreSQL, PostGIS are some of the popular tools that integrate with pgRouting. Here's a list of all 2 tools that integrate with pgRouting.

PostgreSQL
PostgreSQL
PostGIS
PostGIS

pgRouting Discussions

Discover why developers choose pgRouting. Read real-world technical decisions and stack choices from the StackShare community.

Stephen Gheysens
Stephen Gheysens

Lead Solutions Engineer

Oct 13, 2022

Needs adviceonArcGISArcGISMapboxMapboxNeo4jNeo4j

Google Maps lets "property owners and their authorized representatives" upload indoor maps, but this appears to lack navigation ("wayfinding").

MappedIn is a platform and has SDKs for building indoor mapping experiences (https://www.mappedin.com/) and ESRI ArcGIS also offers some indoor mapping tools (https://www.esri.com/en-us/arcgis/indoor-gis/overview). Finally, there used to be a company called LocusLabs that is now a part of Atrius and they were often integrated into airlines' apps to provide airport maps with wayfinding (https://atrius.com/solutions/personal-experiences/personal-wayfinder/).

I previously worked at Mapbox and while I believe that it's a great platform for building map-based experiences, they don't have any simple solutions for indoor wayfinding. If I were doing this for fun as a side-project and prioritized saving money over saving time, here is what I would do:

  • Create a graph-based dataset representing the walking paths around your university, where nodes/vertexes represent the intersections of paths, and edges represent paths (literally paths outside, hallways, short path segments that represent entering rooms). You could store this in a hosted graph-based database like Neo4j, Amazon Neptune , or Azure Cosmos DB (with its Gremlin API) and use built-in "shortest path" queries, or deploy a PostgreSQL service with pgRouting.

  • Add two properties to each edge: one property for the distance between its nodes (libraries like @turf/helpers will have a distance function if you have the latitude & longitude of each node), and another property estimating the walking time (based on the distance). Once you have these values saved in a graph-based format, you should be able to easily query and find the data representation of paths between two points.

  • At this point, you'd have the routing problem solved and it would come down to building a UI. Mapbox arguably leads the industry in developer tools for custom map experiences. You could convert your nodes/edges to GeoJSON, then either upload to Mapbox and create a Tileset to visualize the paths, or add the GeoJSON to the map on the fly.

*You might be able to use open source routing tools like OSRM (https://github.com/Project-OSRM/osrm-backend/issues/6257) or Graphhopper (instead of a custom graph database implementation), but it would likely be more involved to maintain these services.

0 views0
Comments
Companies
2
MJ
Developers
8
GSDLAP+2