Skip to content

Project

PostGIS

PostGIS is an open-source extension that adds geospatial objects, indexing, and query functions to the PostgreSQL database.

Known aliases

  • PostGIS JDBC data store
  • Postgres/PostGIS
  • spatial_ref_sys

Current stories

buildOne report1 publisher

ParkEase puts its no-double-booking rule inside a GiST exclusion constraint

ParkEase puts slot exclusivity in PostgreSQL 18, where no write path can skip it. The mechanism is a GiST exclusion constraint, and the cost lands on whichever booking request loses the race at insert time.

Publishers:dev.to

Reality

Evidence62
Adoption12
Hype gap0
Incentives30
Confidence55
buildOne report1 publisher

Skipping SET nile.tenant_id returns every tenant's rows from a tenant-aware table

A tester on Nile's free tier made two tenants, then ran the same SELECT on a connection that never set nile.tenant_id and got every row back. Nile's docs describe that open read as deliberate, so the guarantee sits in application code.

Publishers:dev.to

Reality

Evidence66
Adoption10
Hype gap−8
Incentives24
Confidence60
buildOne report1 publisher

A tenant-installable PostGIS extension carried the same out-of-bounds bug onto Lakebase and Neon

Databricks says an ordinary customer role could reach the unchecked array index. The repair went upstream into the open-source extension rather than into either fleet. That is the only version that helps anyone else.

Publishers:databricks.com

Reality

Evidence42
Adoption34
Hype gap−14
Incentives78
Confidence45
buildOne report1 publisher

The empty layer called 1: a generic GIS schema moved SQL injection into the view builder

Storing 2.7 million features in three tables was the right call. Handing the tile server one view per layer put a user-editable string into DDL, and an empty layer was the only alarm.

Publishers:dev.to

Reality

Evidence62
Adoption22
Hype gap−8
Incentives24
Confidence58
buildOne report1 publisher

Same Gauss-Kruger zone, two datums, 427 metres: read the proj4text, not the label

A survey ingest form offered two EPSG codes for one zone. One lands in Rajasthan and is caught in seconds. The other lands 427 metres away and is not.

Publishers:dev.to

Reality

Evidence62
Adoption12
Hype gap−8
Incentives34
Confidence58
buildOne report1 publisher

A Tile Cache With No Invalidation Hook Belongs at Zero, With a Comment Saying Why

A vector tile server has run in production for months with its cache deliberately set to 0 MB. The stale-tile bug that got it there is a lesson in reading what a config option actually refreshes.

Publishers:dev.to

Reality

Evidence58
Adoption24
Hype gap−6
Incentives22
Confidence55
buildOne report1 publisher

Eleven terabytes of rasters, no raster database: the two decisions doing the work

DailyMeteo serves 11 TB of GeoTIFFs from a Django app reading files off a disk. The load-bearing choices are a dedicated production box and a pull-based rsync every 30 minutes.

Publishers:dev.to

Reality

Evidence45
Adoption28
Hype gap−15
Incentives38
Confidence52
buildOne report1 publisher

GeoServer's jsonArrayContains filter is being probed at scale, with no patch and no CVE

Hundreds of exploit attempts landed within hours of public disclosure, according to WatchTowr. With nothing to install, the controls available are network isolation, filter-layer blocking and least privilege.

Publishers:dev.to

Reality

Evidence40
Adoption42
Hype gap+18
Incentives55
Confidence38