appsmithorg / appsmithorg/appsmith

[Feature]: Provide support for geographic datatypes manupulation in postgres using Postgis

Open
#9,940 0 comments 3 reactions 0 assignees View on GitHub
Community Reported Enhancement Integrations Product Medium Postgres Query & JS Pod Query Widgets & IDE Pod
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

Open the contributing 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.