appsmithorg / appsmithorg/appsmith
[Feature]: Provide support for geographic datatypes manupulation in postgres using Postgis
- Dominant language
- TypeScript
- Stars
- 40.9k
- Forks
- 4.8k
- Avg merge
- 1d 22h
- Merged PRs (30d)
- 45
Description
### Is there an existing issue for this?
- [X] I have searched the existing issues
### Summary
Today is Appsmith we can work with the geographic datatypes for postgres DB with limited functionality, but to make this easier to transform data we can integrate `PostGIS` which is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL.
Relevant discussion around this can be found [here](https://theappsmith.slack.com/archives/CGBPVEJ5C/p1640145234229500)
### Why should this be worked on?
This will make working with geographic datatypes using Postgresql much simpler.
Contributor guide
Research direction
No files, tests, or entry points are named. Start by reviewing Appsmith's existing PostgreSQL geographic-datatype support and the linked Slack discussion to define the PostGIS integration scope. Done should mean geographic data can be transformed and queried more easily through PostGIS.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- postgresql
- Domain
- databases
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100