drizzle-team / drizzle-team/drizzle-orm

[FEATURE]: Geospatial datatypes missing present in the `drizzle-orm`

Open
#1,831 3 comments 12 reactions 0 assignees View on GitHub
db/mysql drizzle/kit enhancement
Dominant language
TypeScript
Stars
35.8k
Forks
1.6k
Avg merge
2d 7h
Merged PRs (30d)
4

Description

### Missing Geospatial datatypes (present in MySQL) from `drizzle-orm`

I'm trying to create a schema but after spending hours going through the docs, bard (ai), and stack overflow, I couldn't find a way to store geospatial data directly using the `drizzle-orm`. I believe this feature is missing in `mysql-core`.

The following datatypes are missing and need to be implemented in `drizzle-orm`:
- GEOMETRY
- POINT
- LINESTRING
- POLYGON

Details: [MySQL Spatial Data Types](https://dev.mysql.com/doc/refman/8.0/en/spatial-type-overview.html)

I'll be going through the custom data type builder solution if nothing works but seems like the spatial types should be part of the orm by default.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.