BestHub
Sign in
Tagged articles
50 articles
Page 1 of 1
Efficient Ops
Efficient Ops
Jan 6, 2026 · Databases

Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained

This article compiles a detailed comparison of PostgreSQL and MySQL, highlighting PostgreSQL's lack of text‑size limits, better NULL handling, native array and JSON support, built‑in optimistic locking, superior GIS types, MVCC, flexible indexing, robust replication, and overall stability, while also noting the few areas where MySQL still holds an edge.

GISJSONBdatabase comparison
0 likes · 9 min read
Why PostgreSQL Beats MySQL: 10 Technical Advantages Explained
Ray's Galactic Tech
Ray's Galactic Tech
Dec 16, 2025 · Databases

PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide

Choosing between PostgreSQL and MySQL isn’t just a feature checklist; it requires weighing business complexity, team expertise, and future uncertainty, with this guide offering core design philosophies, multi-dimensional capability comparisons, actionable decision paths, and real-world case studies to help you make a production-grade database choice.

GISJSONdatabase selection
0 likes · 12 min read
PostgreSQL vs MySQL: The Ultimate Production-Ready Database Selection Guide
php Courses
php Courses
Mar 21, 2025 · Backend Development

Generating Heatmaps with Baidu Map API in PHP

This article explains how to create and display heatmaps in a PHP project by integrating the Baidu Map API, covering prerequisite setup, library inclusion, data preparation, heatmap generation using the HeatMap class, and rendering the map with JavaScript on a web page.

BackendBaidu Map APIData visualization
0 likes · 5 min read
Generating Heatmaps with Baidu Map API in PHP
JD Tech
JD Tech
Mar 17, 2025 · Fundamentals

Fundamentals of Map Trajectory Technology and GIS Applications

This article provides a comprehensive overview of map trajectory technology, covering geographic coordinate systems, map projections, GIS software basics, data formats, GPS data processing, real‑time and historical trajectory analysis, and recent advances such as AI‑driven services and cross‑domain integrations.

GISGPSPython
0 likes · 21 min read
Fundamentals of Map Trajectory Technology and GIS Applications
JD Tech Talk
JD Tech Talk
Mar 17, 2025 · Fundamentals

Map Trajectory Technology: Fundamentals, Data Formats, GIS Operations, and Path Planning

This article provides a comprehensive overview of map trajectory technology, covering GIS fundamentals, coordinate systems, data formats, import/export methods, GPS processing, spatial analysis, path‑planning algorithms, real‑time and historical tracking, and recent advances such as AI‑driven services and high‑precision mapping.

GISGPSPython
0 likes · 30 min read
Map Trajectory Technology: Fundamentals, Data Formats, GIS Operations, and Path Planning
ByteDance Data Platform
ByteDance Data Platform
Jan 9, 2025 · Databases

Why ByteHouse’s GIS Engine Beats Traditional Spatial Databases in Real‑World Analytics

This article explains how ByteHouse integrates high‑performance GIS capabilities into its OLAP engine, describes its spatial indexing architecture, showcases benchmark results against ClickHouse, StarRocks, PostGIS and DuckDB using the NYC Taxi dataset, and outlines when to choose ByteHouse versus other spatial database solutions.

ByteHouseDatabase PerformanceGIS
0 likes · 11 min read
Why ByteHouse’s GIS Engine Beats Traditional Spatial Databases in Real‑World Analytics
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jan 8, 2025 · Databases

ByteHouse GIS: High‑Performance Geospatial Analytics and Benchmark Comparison with ClickHouse, StarRocks, PostGIS, and DuckDB

The article explains ByteHouse's GIS capabilities, describing its R‑Tree and Google S2 spatial index implementation, OGC‑compatible data types and functions, and presents benchmark results that show ByteHouse outperforming ClickHouse, StarRocks, PostGIS, and DuckDB on key geospatial queries.

ByteHouseGISGeospatial
0 likes · 13 min read
ByteHouse GIS: High‑Performance Geospatial Analytics and Benchmark Comparison with ClickHouse, StarRocks, PostGIS, and DuckDB
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Nov 28, 2024 · Frontend Development

Digital Agriculture Visualization: Technical Implementation with AMap, Three.js, GIS, and Vue

This article presents a comprehensive guide to building a digital agriculture visualization dashboard using AMap JSAPI, three.js, GIS tools, and Vue, covering requirement analysis, layer design, data processing, 3D model integration, animation, and interactive features for smart farming applications.

3D mappingAmapGIS
0 likes · 28 min read
Digital Agriculture Visualization: Technical Implementation with AMap, Three.js, GIS, and Vue
Aikesheng Open Source Community
Aikesheng Open Source Community
Jul 29, 2024 · Databases

Implementing the ST_PointN GIS Function in OceanBase ActionDB

This article explains how the ActionDB team extended OceanBase by designing, registering, and implementing the ST_PointN function to extract the N‑th point from geometry objects, covering registration metadata, code integration, algorithm details, and the advantages of a custom GIS function for enterprise databases.

ActionDBDatabase FunctionsGIS
0 likes · 11 min read
Implementing the ST_PointN GIS Function in OceanBase ActionDB
php Courses
php Courses
Feb 29, 2024 · Frontend Development

Implementing Vector Layers in AMap Using PHP

This tutorial explains how to integrate AMap's vector layer functionality into a PHP web project by setting up the API, creating a map container, initializing the map, and adding point, line, and polygon layers for rich geographic visualizations.

AmapGISPHP
0 likes · 5 min read
Implementing Vector Layers in AMap Using PHP
ELab Team
ELab Team
Jan 30, 2023 · Fundamentals

Understanding Map Projections: From Geographic to Web Mercator and Tile Services

This article explains the fundamentals of geographic and projected coordinate systems, details the Mercator and Web Mercator projections, introduces EPSG standards, discusses China's GCJ02 and BD09 offsets, and describes common GIS data services and tile‑based rendering techniques.

Coordinate SystemsGISMap Projections
0 likes · 19 min read
Understanding Map Projections: From Geographic to Web Mercator and Tile Services
MaGe Linux Operations
MaGe Linux Operations
Sep 28, 2022 · Big Data

Master TransBigData: Python Toolkit for Transportation Big Data

TransBigData is a Python library that streamlines the preprocessing, gridding, visualization, and OD extraction of transportation spatiotemporal datasets such as taxi GPS, bike sharing, and bus data, offering concise, efficient functions for data cleaning, rasterization, interactive mapping, and analytical workflows.

Big DataData visualizationGIS
0 likes · 13 min read
Master TransBigData: Python Toolkit for Transportation Big Data
Rare Earth Juejin Tech Community
Rare Earth Juejin Tech Community
Jul 11, 2022 · Frontend Development

Design and Implementation of a Generic Map Component with Real‑time Heatmap Rendering Using ThreeJS

This article explains the motivation, architecture, and implementation details of a generic map component that supports real‑time heatmap rendering using ThreeJS, covering GIS layer protocols, canvas limitations, WebGL advantages, and code examples for creating radial gradients, instanced meshes, and custom shaders.

GISMAPWebGL
0 likes · 14 min read
Design and Implementation of a Generic Map Component with Real‑time Heatmap Rendering Using ThreeJS
DataFunTalk
DataFunTalk
Sep 22, 2021 · Big Data

Distributed Storage and Application Solutions for Massive Spatiotemporal Data

This article explains the rapid growth of global spatiotemporal data, the limitations of traditional GIS, and presents SuperMap's distributed storage architecture, unified data access APIs, dynamic rendering techniques, and geographic processing modeling with real‑world case studies to address performance and scalability challenges.

GISbig data analyticsdistributed storage
0 likes · 16 min read
Distributed Storage and Application Solutions for Massive Spatiotemporal Data
Amap Tech
Amap Tech
Jun 25, 2021 · Frontend Development

Design and Implementation of the Eagle.gl Web 3D Engine for High-Definition Map Rendering

The Eagle.gl Web 3D engine, built atop Three.js, provides a unified 2D/3D GIS platform that efficiently loads, renders, and edits massive point‑cloud, vector, and model map data with real‑time LOD, GPU picking, DEM terrain integration, and configurable styling, supporting AMap’s HD‑map production and future autonomous‑driving simulation.

3D renderingGISThree.js
0 likes · 12 min read
Design and Implementation of the Eagle.gl Web 3D Engine for High-Definition Map Rendering
ByteFE
ByteFE
Jun 21, 2021 · Frontend Development

Introduction to Mapbox GL JS

Mapbox GL JS is an open-source JavaScript library using WebGL for rendering interactive 2D/3D maps, offering advantages over traditional 2D tile-based solutions like Leaflet through vector data support, customizable styles, and efficient data handling via WebGL.

GISMapbox GL JSWebGL
0 likes · 13 min read
Introduction to Mapbox GL JS
Amap Tech
Amap Tech
Feb 1, 2021 · Frontend Development

Design and Implementation of AMap GIS SDK for Smart Traffic Map Visualization

The AMap GIS SDK was engineered to simplify large‑scale smart‑traffic map visualizations by providing a reusable, extensible framework—featuring a MapContainer, configuration controller, source loader, framework adaptation layer, event‑queue mechanism, lifecycle hooks, plugins, instance caching, and multi‑instance isolation—to overcome AMap JSAPI’s development complexity and ensure stable, performant rendering across diverse data sets.

AmapGISevent queue
0 likes · 15 min read
Design and Implementation of AMap GIS SDK for Smart Traffic Map Visualization
ITPUB
ITPUB
Dec 30, 2020 · Databases

How JD’s JUST Engine Tackles Massive Spatio‑Temporal Data at Scale

The presentation details the design and implementation of JD’s Urban Spatio‑Temporal Data Engine (JUST), explaining its architecture, novel storage and indexing techniques, performance optimizations, experimental results, and real‑world applications such as pandemic contact tracing and hazardous‑material monitoring, while highlighting its academic impact.

GISSmart Citydatabase
0 likes · 29 min read
How JD’s JUST Engine Tackles Massive Spatio‑Temporal Data at Scale
JD Tech Talk
JD Tech Talk
Dec 30, 2020 · Databases

Architecture and Application Practice of JD Urban Spatio-Temporal Data Engine (JUST)

The presentation details the design, implementation, and real‑world applications of the JD Urban Spatio‑Temporal Data Engine (JUST), a distributed, scalable database that handles massive, complex spatio‑temporal data with novel storage, indexing, and query techniques, demonstrating high performance and ease of use across smart‑city scenarios.

Big DataGISUrban Computing
0 likes · 26 min read
Architecture and Application Practice of JD Urban Spatio-Temporal Data Engine (JUST)
Amap Tech
Amap Tech
Oct 16, 2020 · Fundamentals

Fundamentals of High‑Precision Mapping and Coordinate Systems

The article explains high‑precision mapping fundamentals, from Earth’s ellipsoid and geoid definitions and common datums to 2‑D map projections, then details vehicle‑centred and sensor coordinate frames (ECEF, ENU, body, LiDAR, IMU, camera), their transformations, rotation representations, and key standards such as EPSG and Proj.4.

Coordinate SystemsECEFGIS
0 likes · 13 min read
Fundamentals of High‑Precision Mapping and Coordinate Systems
21CTO
21CTO
Aug 19, 2020 · Databases

How to Use MySQL Polygon Types for Precise Location Check‑In

This tutorial explains how to obtain geographic coordinates, store them as MySQL POLYGON types following OGC standards, insert campus area data, and query with spatial functions and SPATIAL indexes to determine whether a user is within a defined check‑in region.

GISPolygonSpatial Data
0 likes · 7 min read
How to Use MySQL Polygon Types for Precise Location Check‑In
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
Amap Tech
Amap Tech
Jun 28, 2019 · Fundamentals

Road Matching: Definitions, Applications, and Key Algorithms

Road matching, a core subset of map‑matching theory, aligns GPS points to the correct road segments using algorithms such as distance‑based measures, Fréchet‑distance global optimization, and Hidden Markov Models, enabling accurate navigation, heterogeneous data fusion, traffic analysis, and urban planning, as validated by ACM SIGSPATIAL competitions.

Fréchet distanceGISHMM
0 likes · 11 min read
Road Matching: Definitions, Applications, and Key Algorithms
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
JD Tech
JD Tech
Jan 2, 2019 · Backend Development

Evolution and Optimization of JD Daojia's Location Service System

This article explains how JD Daojia's location system, which powers store discovery and distance calculations for its O2O platform, has evolved through multiple architectural stages, addressed precision and performance challenges, and been optimized with indexing, Mercator projection, and traffic‑shaping techniques to achieve stable, high‑availability service.

Backend ArchitectureGISlocation-service
0 likes · 10 min read
Evolution and Optimization of JD Daojia's Location Service System
Dada Group Technology
Dada Group Technology
Dec 27, 2018 · Backend Development

Evolution and Architecture of JD Daojia Location Service

This article explains how JD Daojia’s location system has evolved from simple distance calculations to a high‑performance, index‑driven backend service, detailing its core responsibilities, architectural stages, challenges, and the optimizations that improved accuracy, scalability, and resource usage.

GISdistance-calculationinverted index
0 likes · 10 min read
Evolution and Architecture of JD Daojia Location Service
JD Tech
JD Tech
Nov 28, 2018 · Operations

Technical Systems Behind JD Logistics for the 11.11 Global Shopping Festival

The article details how JD Logistics’ extensive warehouse, routing, distribution, and fulfillment systems—leveraging big data, AI, GIS, IoT, and distributed architectures—were engineered and optimized to handle the massive order surge during the 11.11 Global Shopping Festival with high throughput, low latency, and zero incidents.

AIBig DataGIS
0 likes · 8 min read
Technical Systems Behind JD Logistics for the 11.11 Global Shopping Festival
Manbang Technology Team
Manbang Technology Team
Nov 15, 2018 · Fundamentals

Introduction to GIS and Its Application in Highway Logistics Platforms

This article explains the fundamentals of Geographic Information Science (GIS), recounts John Snow's historic cholera map as an early GIS example, and details how GIS technology can be leveraged to build a road‑logistics platform that enables real‑time monitoring, dispatch, path planning, and data‑driven decision making for transportation companies.

Data visualizationGISGeospatial
0 likes · 10 min read
Introduction to GIS and Its Application in Highway Logistics Platforms
Alibaba Cloud Developer
Alibaba Cloud Developer
Jul 12, 2018 · Fundamentals

How Xianyu Scales Billion‑Item Geo Matching with Fast GeoHash Algorithms

This article explains how Xianyu uses GeoHash‑based spatial indexing, precise and approximate matching, and a rapid neighbor‑search algorithm to efficiently associate billions of GPS‑tagged items with tens of thousands of city‑level business districts, reducing computation from quadrillions to billions of operations.

Algorithm OptimizationGISGeoHash
0 likes · 13 min read
How Xianyu Scales Billion‑Item Geo Matching with Fast GeoHash Algorithms
Huawei Cloud Developer Alliance
Huawei Cloud Developer Alliance
Jan 3, 2018 · Cloud Computing

How Huawei & SuperMap Fuse Cloud Computing with GIS for Smarter Government Services

The Huawei & SuperMap Government Cloud GIS solution integrates SuperMap's cloud GIS platform with Huawei's FusionSphere OpenStack, leveraging eSDK Cloud APIs to provide centralized, elastic resource management, rapid GIS application deployment, and enhanced data‑intensive computing for government sectors, illustrating the inevitable convergence of GIS and cloud computing.

FusionSphereGISGovernment
0 likes · 8 min read
How Huawei & SuperMap Fuse Cloud Computing with GIS for Smarter Government Services
Java High-Performance Architecture
Java High-Performance Architecture
Jun 9, 2016 · Databases

Discover MySQL 5.7: 9 Powerful New Features You Must Know

MySQL 5.7 introduces major enhancements such as native JSON support, an expanded Performance Schema, a new SYS Schema for health monitoring, improved security, advanced GIS capabilities, three‑fold query throughput gains, InnoDB optimizations, multi‑source replication, and a smarter optimizer with dynamic costing.

GISInnoDBJSON
0 likes · 3 min read
Discover MySQL 5.7: 9 Powerful New Features You Must Know
ITPUB
ITPUB
Jan 19, 2016 · Databases

Surprising PostgreSQL Features That Redefine What a Database Can Do

This article showcases seven remarkable PostgreSQL extensions—including multi‑master replication, Greenplum MPP OLAP, pg_shard/FDW sharding, PostGIS 3D GIS, GPU‑accelerated PG‑Strom, PipelineDB streaming, and the versatile FDW interface—illustrating how they enable high‑availability, massive analytics, geographic intelligence, and real‑time data processing.

Database ExtensionsFDWGIS
0 likes · 5 min read
Surprising PostgreSQL Features That Redefine What a Database Can Do
Efficient Ops
Efficient Ops
Jul 24, 2015 · Databases

What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features

An expert panel from the High‑Efficiency Operations community answers eleven pressing MySQL 5.7 questions, covering test hardware, GA timeline, GIS speed, virtual column indexing, materialized view plans, 2‑D geo support, performance monitoring, Oracle’s market strategy, geojson handling, multi‑source replication, buffer‑pool locking, and InnoDB Memcached consistency.

Database PerformanceGISInnoDB
0 likes · 7 min read
What MySQL 5.7 InnoDB Experts Reveal: Key Q&A on New Features