PostGIS data models
Stops, legs and geofences stored where the questions get asked.
Database
PostgreSQL development services for location data that drives decisions
PostgreSQL with PostGIS holds the stops, legs and geofences behind our fleet platform. One route fell from 112 km to 97 km once the order was computed from that data.
1Published build on PostgreSQL
5 yearsSupport for each major version
12 Nov 2026PostgreSQL 14 final release
14 Nov 2030PostgreSQL 18 final release
What we build
What we build with PostgreSQL
Route sequencing data
Stops reordered and the saving stated in kilometres.
Queues beside the database
Redis carries the sync queue while PostgreSQL holds the record.
Major version upgrades
Databases moved off PostgreSQL 14 before its support ends.
Architecture
What PostgreSQL holds in a build
The data model behind a fleet platform
In PostGIS
StopsWhere a truck must go
LegsTrips between stops
GeofencesBoundaries on the map
Database
PostgreSQLWith the PostGIS extension
Used by
Route sequencingSaving shown in km
Dispatch consoleSixteen live screens
Driver appNative iOS
From TruckFleet Labs, a dispatch console and driver app for a 42-truck operator.
Versions
Which PostgreSQL release is supported
Each major version gets five years, then a final minor release. Version 14 ends on 12 November 2026.
Support windows, 2021 to 2031
Supported
Source: PostgreSQL versioning policy, postgresql.org/support/versioning, checked 30 October 2026.
Builds
The PostgreSQL build we can show you
Logistics, fleet operations
TruckFleet Labs
PostgreSQL with PostGIS behind a FastAPI back end, a React console and an iOS driver app. One route fell from 112 km to 97 km.
112 to 97 kmOne route after route sequencing
Fit check
When PostgreSQL is the right call
Pick PostgreSQL when
- The data has places, routes or boundaries
- You want one open-source database for records and geometry
- Your back end is Python
Look elsewhere when
- Your team runs .NET and Azure and wants one vendor, where we used Azure SQL
- The data is a local queue on a phone, where we used SQLite
- You need a published PostgreSQL build beyond one to inspect
Explore
Same job, other tools
Where we used it
Stack
What PostgreSQL usually ships with
PythonReactiOS
DockerFAQs
What buyers ask first
Which PostgreSQL version should we run?
PostgreSQL 18, released on 25 September 2025 and supported to 14 November 2030. PostgreSQL 14 gets its final release on 12 November 2026, so plan that upgrade now.
How long is a PostgreSQL version supported?
Five years after its initial release, followed by a final minor release. After that the community ships no more fixes.
PostgreSQL or SQL Server?
We have one published build on each. PostgreSQL with PostGIS runs TruckFleet, and Azure SQL runs the Digital Testing Platform. The choice follows your data and your team.
Who owns the code and the cloud accounts?
You do, from the first commit. Repositories and cloud accounts stay in your name.
Tell us what your data has to answer
Thirty minutes on your data model, your version and your location needs. No sales pitch.