sqlx icon indicating copy to clipboard operation
sqlx copied to clipboard

feat(mysql): add GEOMETRY support

Open mirromutth opened this issue 1 year ago • 1 comments

Resolve #2735 Also may help to resolve issue in #166

Allows users enable geometry feature to use type geo_types::Geometry<f64> for GEOMETRY fields in MySQL.

Use ColumnType::Blob due to MySQL does not allow to execute prepared statement with a ColumnType::Geometry parameter, or am I missing something?

Based on geozero provided by georust

mirromutth avatar Feb 21 '24 11:02 mirromutth

Any plans to merge this soon?

heksesang avatar Apr 12 '24 12:04 heksesang

geozero provides integration with SQLx on their end so this would just introduce a dependency cycle.

I'm happy with it living there for the time being.

abonander avatar Aug 13 '24 20:08 abonander

Hi @abonander , if I understand correctly the documentation of geozero, Geometry for MySQL (with sqlx) isn’t supported on their side. Do you suggest to add this feature on the geozero project ?

gmli avatar Aug 28 '24 20:08 gmli

Yes, since they've already added a sqlx feature. Otherwise it's just asking for annoying dependency cycle errors in Cargo.

abonander avatar Aug 28 '24 20:08 abonander

Thank you. @mirromutth did you planned to do it on geozero ?

gmli avatar Aug 28 '24 20:08 gmli