Tagged articles
PostGIS
11 articles · Page 1 of 1
This article compares PostgreSQL and MySQL across complex query optimization, data types, MVCC implementation, transaction rollback capabilities, and cloud ecosystem support, explaining why PostgreSQL is increasingly preferred for complex analytics, vector search, and geospatial applications.
Cloud NativeJSONBMVCC
0 likes · 6 min read

PostgreSQL’s extensible architecture lets it evolve from a relational DB into a true multi‑model system supporting graphs, vectors, full‑text, time‑series, GIS and key‑value data, with detailed architecture explanations, practical code demos, cross‑model queries, extension selection, and production‑grade best‑practice tips.
Apache AGEJSONBPostGIS
0 likes · 39 min read

This guide explains how to integrate the PostGIS spatial extension into a Kingbase database running in Docker, covering prerequisite communication with support, extracting the extension files, copying necessary binaries, restarting the container, and verifying the installation with sample queries.
KingbasePostGISSpatial
0 likes · 6 min read

This guide walks through deploying a PostgreSQL instance with the PostGIS extension on a CentOS server using Docker Compose, covering image retrieval, docker‑compose configuration, environment variables, logging settings, container startup, and verification of PostGIS integration.
CentOSPostGISPostgreSQL
0 likes · 5 min read

This guide walks non‑specialist GIS developers through front‑end mapping with Vue, OpenLayers and Leaflet, back‑end processing with Java, GeoTools and PostGIS, and practical solutions for common GIS toolchain challenges.
GISGeoServerJava
0 likes · 6 min read

This article traces the evolution of open source GIS from its early roots in MOSS and GRASS through key projects like GeoTools, GDAL, PostGIS, and GeoServer, and then details the components and typical open‑source stack of a modern WebGIS solution.
GIS ArchitectureGeoServerGeospatial Data
0 likes · 11 min read

After installing PostgreSQL on Windows, this guide shows how to add the PostGIS extension via pgAdmin, create a new spatial database, verify the installation, and then use the PostGIS Shapefile and DBF Loader Exporter to import a shapefile (with accompanying DBF), handling encoding and path issues, and finally view the imported data.
GIS importPostGISPostgreSQL
0 likes · 4 min read

Facing the post‑pandemic slowdown of e‑commerce growth, SuNing pioneered an O2O “smart retail” strategy by integrating online and offline channels through its “Anytime Business System,” which combines PostGIS‑enabled geospatial analysis, PostgreSQL high‑availability clustering with Citus, and seamless data flow across front‑end, transaction, and support layers.
CitusGeospatialO2O
0 likes · 17 min read

This article explains how to efficiently browse and render millions of GIS features in real‑time vector tiles using PostgreSQL and PostGIS, covering background challenges, several thinning algorithms, their implementation steps, limitations, advantages, and a practical example with a 3‑million‑point dataset.
Data DilutionGISPostGIS
0 likes · 8 min read

The Travel Time Index (TTI) quantifies urban congestion by comparing actual travel time to free‑flow conditions, and this study details domestic and international evaluation methods, free‑flow speed estimation, weight calculation, link extraction via PostGIS, system architecture, and validation using massive Didi trajectory data to support city traffic management.
GISPostGISTransportation Analytics
0 likes · 9 min read

On August 4 2018, Didi Open Source and the Open Source Database Forum hosted a salon where five industry experts presented the latest advances in open‑source databases—covering Redis multi‑data‑center deployment, MySQL InnoDB Cluster, streaming‑processing architecture, PostGIS GIS solutions, and Redis 5.0 features—followed by a Q&A, a prize draw, and a showcase of Didi’s growing open‑source portfolio.
Open SourcePostGISdatabase
0 likes · 4 min read
