Support MySQL Spatial data types #240

Activity

1. SockworkOrange

   added

   enhancementNew feature or requestNew feature or request

   on Mar 25, 2025
2. SockworkOrange

   added the

   Feature

   issue type on Mar 25, 2025
3. doron050

   added

   help wantedExtra attention is neededExtra attention is needed

   on Jun 7, 2025
4. SockworkOrange

   added

   blockedImplementation is blocked due to lack of SQLC supportImplementation is blocked due to lack of SQLC support

   and removed

   help wantedExtra attention is neededExtra attention is needed

   on Aug 7, 2025
5. doron050 commented on Oct 24, 2026

   

   doron050

   on Oct 24, 2026

   Collaborator

   More actions

   Status update: this was blocked by sqlc's MySQL parser rejecting spatial types such as GEOMETRY (sqlc-dev/sqlc#3741). That is fixed on sqlc main by sqlc-dev/sqlc#4576 (merged 2026-08-21), but it isn't in a release yet. The latest release is v1.31.1 (2026-04-22), which predates the fix.

   So the next sqlc release should unblock us. After that we still need to add the spatial type mappings in the MySQL driver (likely MySqlGeometry from MySqlConnector), which I haven't verified yet.