×
ApsaraDB RDS

SQL and TimescaleDB

This article takes a closer look into TimescaleDB, a PostgreSQL-based time series database that is fully SQL-compatible.

Bringing PostGIS to PostgreSQL on Alibaba Cloud (Part 2)

In this part of a two part tutorial series, you learn how to perform both spatial and non-spatial function queries on ApsaraDB for PostgreSQL.

Bring PostGIS to PostgreSQL on Alibaba Cloud (Part 1)

In this part of a two-part tutorial series, you learn how to create a PostgreSQL spatial database that uses the features of PostGIS for improved spatial data management.

Alibaba Cloud Ranked as Strong Performer in Forrester Wave DaaS Q2 2019

In this article, we explore some of the reasons why Alibaba Cloud was recognized a "Strong Performer" in The Forrester Wave: Database-As-A-Service, Q2 2019.

Social Friend Relationship System Practice in PostgreSQL - Accelerating Queries of Positive and Negative Relationships

This article shows you how to speed up the query of positive and negative relationships on a PostgreSQL database.

PCC Social Media "Like" Scenario - Database Design and Performance Stress Testing

This article explores a potential solution for implementing a social "like" feature, similar to that of Facebook, by using PostgreSQL.

PostgreSQL Practices of Elective Selection Relation in Colleges

This article shows a quick demo on implementing graph search for searching and filtering student electives based on several criteria.

PostgreSQL Practices - Application of Graph Search in Content Communities

This article introduces the Smlar extension for PostgreSQL and its application in graph search for content communities such as forums.

PostgreSQL Graph Search Practices - 10 Billion-Scale Graph with Millisecond Response

This article discusses the implementation of graph search using the CTE syntax of PostgreSQL.

PostgreSQL Feed Systems Similar to Weibo - Design and Performance Metrics

This article describes scenarios that are related message pushing and message consumption by using a 2048-letter-long message as an example.

PostgreSQL Family Tree Application Practices - Graph Relation Storage and Search

This article explains how to store family relationships and quickly extract N-tier information for a typical graph application.

Facebook LinkBench Tests PostgreSQL Social Relation Profile Scenario Performance

This article introduces LinkBench for PostgreSQL and shows you how to use it to run benchmark test for your database.

Applying PostgreSQL Graph Database to Social Scenarios

In this article, we discuss several real world implementations of PostgreSQL including Finance Risk Control, Police Criminal Detection, and Social Network Analysis.

Defeating Human Traffickers with Technology

In this article, we will explore how database and other similar technologies can be used to address crimes.