Postgres' PostGIS GEOMETRY/GEOGRAPHY data types in Keystone? #9412
arthurCormack
started this conversation in
Feature requests
Replies: 1 comment 1 reply
-
It looks like we will have geospatial types support in prisma very soon: prisma/prisma-engines#4208 |
Beta Was this translation helpful? Give feedback.
1 reply
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
I have some applications that make use of geospatial data that I am am considering migrating to KeystoneJS. But an essential requirement is POSTGIS' GEOMETRY & GEOGRAPHY data types. Those aren't supported in Prisma, but they can be utilized nonetheless, using Prisma's Raw Queries (https://www.prisma.io/docs/orm/prisma-client/using-raw-sql/safeql#1-set-up-prisma-orm-for-use-with-postgis) . I can imagine a multitude of complications to this, such as the other databases that work with Keystone, not having PostGIS. But it might be possible emulate the same functionality using a collection of other fields in those other databases to achieve the same result, albeit in a less performant way.
I'm wondering how feasible/likely it might be to create a GEOMETRY/GEOGRAPHY Types in Keystone?
What are the recommendations for handling geospatial data in keystone in the meantime?
Is this something that would be of value to others?
Beta Was this translation helpful? Give feedback.
All reactions