×

digoal

7064 Reputation

PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)

Follow
Activities(50) Posts(148) Series(10) Areas of Expertise Following Followers

digoal Posted blog

PostGIS: How to Calculate Distance between Coordinates in Spherical and Projected Systems

In this article, the author discusses calculating distances in projected and spherical coordinate systems in respect of geometry and geographic data using PostGIS functions.

digoal Posted blog

PostgreSQL: Importing OpenStreetMap and Road Data

In this short post, the author explores how to import OpenStreetMap data into a PostgreSQL database.

digoal Posted blog

PostgreSQL: How to Optimize Spatial Index-based Query Performance for Multipolygon Data

In this article, the author discusses optimizing spatial index-based query performance for multipolygon data in PostgreSQL.

digoal Posted blog

PostgreSQL: Processing 3D Data with PostGIS and SFCGAL

In this article, the author discusses how to process 3D spatial data in PostgreSQL using PostGIS and SFCGAL.

digoal Posted blog

PostgreSQL: How to Determine the Positions of Overlapping Points and Planes in PostGIS

In this article, the author discusses overlapping points and planes and determining their actual positions from a visual perspective in PostGIS.

digoal Posted blog

PostgreSQL: ST_Value Function Usage Examples to Optimize Raster Data in a Database

In this article, we'll discuss optimizing raster data in PostgreSQL databases using the ST_Value function and describe various optimization methods.

digoal Posted blog

PostgreSQL Opens the Door to Space and Time

This article discusses spatiotemporal data and its wide usage in multiple domains, such as indoor positioning, pilotless driving, and scientific research.

digoal Posted blog

PostgreSQL 3D City Applications

In this article, the author explains various features in PostgreSQL that help implement 3D city applications.

digoal Posted blog

PostgreSQL Real-time Position Tracking + Trace Analysis System Practices: Processing 100 Billion Traces/Day with a Single Server

In this article, the author discusses PostgreSQL-based real-time position tracking and trace analysis in respect of express delivery companies.

digoal Posted blog

PostgreSQL-enabled Electronic Fences: Application Scenarios and Performance

In this article, the author discusses electronic fence technology based on PostgreSQL and describes its applications in various common business scenarios.

digoal Posted blog

PostgreSQL Best Practices: Overcoming Ride-Hailing Conflicts Arising in a Trip Dispatch System

In this article, the author discusses optimizing the PostgreSQL database to overcome ride-hailing conflicts in crowded areas during peak hours.

digoal Posted blog

Use Geometry Split to Optimize PostgreSQL Performance in GiST Index-based Polygon Search

In this article, the author discusses geometry split in PostgreSQL and describes how to use it to optimize performance in GiST index-based polygon search with example code.

digoal Posted blog

Optimize Spatial Searches in PostgreSQL Using ST_Contains and ST_Within

This article discusses optimizing spatial search performance in PostgreSQL using ST_Contains and ST_Within to address the I/O amplification problem and CPU usage.

digoal Posted blog

Spatial Search: Geometry and GiST Combination Outperforms Geohash and B-tree

In this article, we explore spatial search performance and describe when to use Geohash, geometry, and geography data types along with indexes such as GiST and B-tree.

digoal Posted blog

Use BRIN to Discover Target Customers from Massive E-Commerce Advertising Data in Milliseconds

This article discusses discovering target customers using BRIN from massive e-commerce advertising data using PostgreSQL and AnalyticDB.

digoal Posted blog

Importing Data from Google Earth to PostgreSQL

This article discusses how to utilize PostgreSQL to import crucial data and geometry segments from Google Earth and convert KML files into ESRI format files.

digoal Posted blog

Comparison Between PostgreSQL 10 and Greenplum in Spatiotemporal Object Selection and Data Pivoting

In this article, the author discusses spatiotemporal object selection and data pivoting and extensively compares PostgreSQL 10 and Greenplum in this respect with example code.

digoal Posted blog

PostgreSQL: Real-time User Positioning and Selection Based on Massive Amounts of Data

In this article, the author discusses real-time user positioning and selection using PostgreSQL. The author also discusses various design methods and optimization for performance improvements.

digoal Posted blog

Database Design and Implementation of a Ride Hailing Dispatch System

This article discusses the database design of an order dispatch system for ride hailing apps by using DiDi as an example.

digoal Posted blog

PostgreSQL Best Practices: Real-Time Monitoring and Alerts for Senior Citizen Healthcare

This article discusses managing healthcare for elderly people using big data and talks about optimization methods for real-time monitoring and alerts.

Latest Comments