PostgreSQL Evangelist. [My Git](https://github.com/digoal/blog/blob/master/README.md)Follow
This article shows you how to speed up the query of positive and negative relationships on a PostgreSQL database.
This article explores a potential solution for implementing a social "like" feature, similar to that of Facebook, by using PostgreSQL.
This article shows a quick demo on implementing graph search for searching and filtering student electives based on several criteria.
This article introduces the Smlar extension for PostgreSQL and its application in graph search for content communities such as forums.
This article discusses the implementation of graph search using the CTE syntax of PostgreSQL.
This article describes scenarios that are related message pushing and message consumption by using a 2048-letter-long message as an example.
This article explains how to store family relationships and quickly extract N-tier information for a typical graph application.
This article introduces LinkBench for PostgreSQL and shows you how to use it to run benchmark test for your database.
In this article, we discuss several real world implementations of PostgreSQL including Finance Risk Control, Police Criminal Detection, and Social Network Analysis.
In this article, we will explore how database and other similar technologies can be used to address crimes.
In this blog, we look at how statistical analysis can help enterprises determine the perfect product combination for marketing.
This article shows you how to use data pivoting on PostgreSQL to meet your various business needs.
As mobile and IoT technologies are becoming commonplace, it is important for organizations to employ intelligent database design to track and analyze data effectively.
Data can be combined for a deeper analysis of factors such as population composition and spending power, bringing more referential information for proper site selection.
Recursive syntax in PostgreSQL and PL/pgSQL can meet the requirements of analyzing events before and after a specific event in public opinion analysis scenarios.
In this article, we look at how we can create a user-car fitting model in PostgreSQL to map spatio-temporal data with drivers, passengers and vehicles.
In this blog, we discuss how PostgreSQL can help with real-time streaming statistics for data visualization, including time-series processing and full analysis.
This blog talks about the various ways of classifying data and introduces several optimization methods to ensure efficient search of multidimensional data.
In today's retail industry, data must be used to its greatest value if online and offline business are to be integrated and inventories optimized.
This article discusses the implementation for merging time series data in Composite Indexes, Window Group Query Acceleration, and Extraordinary Recursive Acceleration.