关于DHIS2当前版本对MySQL的支持性及GIS功能可用性的技术问询

Hey there, great question—let's get straight to the details:

MySQL Support Status #

DHIS2 officially discontinued support for MySQL starting with versions released after 2.28. All current stable and supported releases (like the latest 2.40+ series) only recognize PostgreSQL as the recommended and fully supported relational database. Any attempts to run modern DHIS2 versions on MySQL will likely lead to compatibility issues, missing features, and no official troubleshooting support from the DHIS2 team.

GIS Functionality Compatibility #

• Since MySQL isn't supported anymore, DHIS2's GIS features won't work properly (if at all) with MySQL. These tools are deeply integrated with PostGIS—PostgreSQL's dedicated spatial extension—for core capabilities like map rendering, spatial data queries, and geo-based data management.
• MySQL's spatial capabilities are limited compared to PostGIS, and DHIS2 hasn't been optimized to work with them for years. Even if you managed to hack together a connection, you'd run into broken map views, failed spatial operations, and inconsistent geo-data handling.

If you're coming from an older 2.28 (or earlier) MySQL-based DHIS2 setup, the official project resources include guidance for migrating your data to PostgreSQL to get full access to all modern features, including GIS tools.

内容的提问来源于stack exchange，提问作者baradhili