×
Relational Database

How to Return MySQL Data in JSON Format With PHP On Ubuntu 20.04 Server

In this guide, you'll set up a simple MySQL database and then use some PHP functions to retrieve and convert data in JSON format.

Query Optimization Technology for Correlated Subqueries

This article describes what correlated subqueries are and how to rewrite correlated subqueries as SQL queries in common semantics.

Build a Personalized Recommendation System on Alibaba Cloud in Three Steps

This article explains how to build a personalized recommendation system by illustrating a news recommendation system using AnalyticDB for PostgreSQL.

Fast and Cost-effective MySQL Analysis Solution Based on Alibaba Cloud DLA

This article discusses the data analysis challenges related to MySQL databases and explores how the Alibaba Cloud Data Lake Analytics platform can help.

Lonch Group Cuts O&M Costs by 50% by Migrating to Alibaba Cloud

This article explains how Alibaba Cloud helped a pharmaceutical company cut its direct database cost and O&M cost by migrating its core ERP system and databases to the cloud.

COVID-19's Impact on Open-source Databases and Domestic Databases

This article analyzes the impact of the recent outbreak on the DB-Engines ranking of databases by popularity for May 2020.

How Can We Combine PostgreSQL and MySQL to Make the Whole Greater than the Sum of the Parts? (Part 2)

In this blog series, we'll show you how to combine both ApsaraDB RDS for PostgreSQL and MySQL to enhance business value.

How Can We Combine PostgreSQL and MySQL to Make the Whole Greater than the Sum of the Parts? (Part 1)

In this blog series, we'll show you how to combine both ApsaraDB RDS for PostgreSQL and MySQL to enhance business value.

First Experience with PostgreSQL 13 Beta 1

The PostgreSQL Global Development Group released the first beta of PostgreSQL 13 on May 21, 2020. Zhuodao takes a look at all the new features and changes.

Applying Machine Learning to Big Data Processing

This blog discusses some applications of machine learning in big data including data processing, census data analyzing, and the pipelines machine learning.

Breaking the Limits of Relational Database in Cloud Native Era

Learn how Alibaba Cloud deep dive into its next-generation database and overcome limits of relational database in cloud native era.

Really Worth it? How Does ApsaraDB for RDS and an User-Created MySQL Database Compare

Host a database of your own or purchase one of Alibaba Cloud's databases? Which has better performance? Read on to find out.

Flink 1.9: Using SQL Statements to Read Data from Kafka and Write to MySQL

This article includes the code that I demonstrated in my speech, entitled Flink SQL 1.9.0 Technologies and Best Practices, which sparked a lot of interest from the audience.