Does TiDB have plans to support spatial geographic functions?

Translated
1

Note:
This topic has been translated from a Chinese forum by GPT and might contain errors.

Original topic: TiDB 有没有计划支持空间地理函数

| username: TiDBer_CQ

I would like to know if TiDB has plans to support spatial type functions (i.e., GIS / GEOMETRY), data types, and indexes; is there such a demand currently, and what technical solutions are being used to support such needs while using TiDB?

2
| username: 有猫万事足 | Original post link

The latest roadmap does not include this plan.
For the latter part of the question, I also want to know how to handle it better and see other people’s solutions.

3
| username: heiwandou | Original post link

No, but PostgreSQL has it.

4
| username: 小龙虾爱大龙虾 | Original post link

+1 I didn’t see it in the roadmap.

5
| username: 像风一样的男子 | Original post link

In the first half of the year, there were plans related to GIS, scheduled for after 2024, but now they are gone.

6
| username: Jolyne | Original post link

I have the same question. Our industry is related to geography, and we are currently using PG and SQL Server with relatively large data. We initially wanted to try TiDB for other scenarios, but later found out that it doesn’t have spatial functions. Now we directly convert geometry to other types, so these point data can only be viewed :joy:

7
| username: 江湖故人 | Original post link

GaussDB and Greenplum, which are based on PostgreSQL, have relatively good support in this area.

8
| username: 随缘天空 | Original post link

You can make suggestions to the official team.

9
| username: dba远航 | Original post link

Spatial types are generally better supported by NoSQL.

10
| username: TiDBer_小阿飞 | Original post link

SuperMap Software is generally considered the most professional spatial database in China, right?
SuperMap’s open-source spatial database Yukon, based on Huawei’s open-source database openGauss, provides capabilities for storing, computing, and managing spatial data, empowering existing relational database technologies. The Yukon open-source spatial database is compatible with PostGIS and supports the storage of 3D model data, offering integrated 2D and 3D spatial data storage, computation, and management capabilities. Yukon also supports adaptation with PostgreSQL.
It ranks first on Mo Tian Lun.

image
image1380×818 123 KB

11
| username: 像风一样的男子 | Original post link

MySQL supports all spatial functions.

12
| username: dba远航 | Original post link

MYSQL support is correct, but TiDB is a distributed database, and it is very difficult for distributed databases to support stored procedures, functions, views, triggers, etc.

13
| username: andone | Original post link

Currently, there isn’t any.

14
| username: oceanzhang | Original post link

The current version does not have it.

15
| username: TiDBer_gxUpi9Ct | Original post link

Not available now.

16
| username: system | Original post link

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.