observablehq / feedback

Customer submitted bugs and feature requests
42 stars 3 forks source link

Generate Heroku Hobby Postgres database with OAuth #349

Open thadk opened 2 years ago

thadk commented 2 years ago

Is your feature request related to a problem? Please describe. It is a bit challenging to find and set up good trial SQL server-oriented database for data visualization purposes. I don't usually keep a server with PostgreSQL running and don't want to worry about its security.

It might be a convenient feature to encourage exploration if, like the Hasura.io setup, ObservableHQ will help you generate and authenticate to a blank Heroku Hobby Postgres database using OAuth

Describe the solution you'd like

The Heroku app repository it creates is completely blank, it seems to just run the postgres plugin creation and take note of the authentication details for use in the platform. The plugin may not even go to sleep as a Hobby-tier heroku app would, not sure.

Describe alternatives you've considered

Laying out the steps to connect to a Heroku database in a tutorial would be sufficient for me at my level of familiarity/interest in this.

Additional context I'm excited about the geospatial queries on PostGIS which can easily be enabled in Heroku postgresql (albeit an old version)

https://talk.observablehq.com/t/generate-heroku-hobby-postgres-database/6097.

CobusT commented 2 years ago

Thanks for logging it here!