BestHub
Sign in
Tagged articles
10 articles
Page 1 of 1
360 Zhihui Cloud Developer
360 Zhihui Cloud Developer
Apr 22, 2026 · Databases

Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice

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 AGEFull‑Text SearchJSONB
0 likes · 39 min read
Unlock PostgreSQL’s Multi‑Model Power: Graph, Vector, Full‑Text, JSONB & GIS in Practice
Dunmao Tech Hub
Dunmao Tech Hub
Jan 30, 2026 · Databases

How to Add PostGIS Extension to Kingbase: A Step‑by‑Step Docker Guide

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.

DockerKingbasePostGIS
0 likes · 6 min read
How to Add PostGIS Extension to Kingbase: A Step‑by‑Step Docker Guide
The Dominant Programmer
The Dominant Programmer
Oct 18, 2024 · Databases

Deploy PostgreSQL with PostGIS on CentOS using Docker Compose

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.

CentOSDatabase DeploymentDocker
0 likes · 5 min read
Deploy PostgreSQL with PostGIS on CentOS using Docker Compose
The Dominant Programmer
The Dominant Programmer
Mar 14, 2021 · Databases

How to Create a PostGIS Spatial Database and Import Shapefile Data

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
How to Create a PostGIS Spatial Database and Import Shapefile Data
Suning Technology
Suning Technology
Sep 29, 2020 · Databases

How SuNing’s O2O System Uses PostGIS & Citus for Scalable Geospatial Retail

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
How SuNing’s O2O System Uses PostGIS & Citus for Scalable Geospatial Retail
dbaplus Community
dbaplus Community
Jul 22, 2020 · Databases

How to Optimize Real‑Time Vector Tile Services for Millions of Features with PostgreSQL & PostGIS

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.

Big DataData DilutionGIS
0 likes · 8 min read
How to Optimize Real‑Time Vector Tile Services for Millions of Features with PostgreSQL & PostGIS
Didi Tech
Didi Tech
Apr 23, 2019 · Big Data

Travel Time Index (TTI): Evaluation Methods, Calculation, and Validation Using Didi Trajectory Data

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.

Big DataGISPostGIS
0 likes · 9 min read
Travel Time Index (TTI): Evaluation Methods, Calculation, and Validation Using Didi Trajectory Data
Didi Tech
Didi Tech
Aug 14, 2018 · Databases

Recap of the Open Source Salon: Latest Developments in Open Source Databases and Streaming Processing

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.

PostGISStreamingdatabase
0 likes · 4 min read
Recap of the Open Source Salon: Latest Developments in Open Source Databases and Streaming Processing