How to Use TiDB in the Context of Geographic Coordinate Retrieval

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

Original topic: 在地理坐标检索的场景下,tidb如何使用

| username: TiDBer_7Q5CQdQd

In a business scenario where it is necessary to delineate coordinate points within a geographic coordinate range, how does TiDB support this? If used in conjunction with Elasticsearch, how should it be designed?

| username: xfworld | Original post link

Are you asking for a solution in the community? It feels like there are no answers… :upside_down_face:

From another perspective, if the business scenario involves storing coordinates and you don’t use TiDB but use MySQL, how do you plan to handle it?

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

I don’t have a solution.
However, if you want to synchronize data from TiDB to another system in real-time, you should mostly look into TiCDC-related content.

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

It seems that TiDB does not support spatial data types and functions, while MySQL does.

| username: TiDBer_7Q5CQdQd | Original post link

Does TiDB have plans to support it in the future?

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

Why don’t you ask the TiDB vendor?

| username: redgame | Original post link

I have seen that it will be supported later.

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

In the current roadmap, GIS is listed under the “Future” column. According to the current plan, this future version will definitely be released later than the mid-2024 LTS version.

| username: TiDBer_7Q5CQdQd | Original post link

Thank you, it will probably be 2025.

| username: system | Original post link

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