search

ploomber / doc

Documentation for Ploomber Cloud
https://docs.cloud.ploomber.io
Apache License 2.0
24 stars 14 forks source link

Shiny-R PostgresSQL Example #252

Closed stanleyo03 closed 2 months ago

stanleyo03 commented 2 months ago

Added example Shiny-R app that is connected to Postgres database.

Closes #253

📚 Documentation preview 📚: https://ploomber-doc--252.org.readthedocs.build/en/252/

neelasha23 commented 2 months ago

Please add Closes #issuenumber in the description @stanleyo03

stanleyo03 commented 2 months ago

@neelasha23 There wasn't an issue for this PR, I was just adding the app I made for the blog post. Should I create an issue? Thanks!

stanleyo03 commented 2 months ago

Please add Closes #issuenumber in the description @stanleyo03

done!

stanleyo03 commented 2 months ago

closed temporarily to remove database info

neelasha23 commented 2 months ago

closed temporarily to remove database info

you can convert it to draft if still making changes, instead of closing

neelasha23 commented 2 months ago

Please tag and mark it as ready for review once it's ready

stanleyo03 commented 2 months ago

@neelasha23 ready for review

neelasha23 commented 2 months ago

Please deploy this app to cloud and share the app link @stanleyo03

stanleyo03 commented 2 months ago

@neelasha23 I think I want to change the sample dataset I'm using because I downloaded the data locally and don't want to upload it onto this repo. Thoughts? I will change the blog post to draft until I fix it.

neelasha23 commented 2 months ago

@neelasha23 I think I want to change the sample dataset I'm using because I downloaded the data locally and don't want to upload it onto this repo. Thoughts? I will change the blog post to draft until I fix it.

Didn't get it. Why do u need to upload to this repo? You can create a zip of the data and code files and deploy to Ploomber Cloud as a Docker deployment. am i missing something? @stanleyo03

stanleyo03 commented 2 months ago

I noticed that from the ploomber cloud cli, you can deploy the example apps. However, my app wouldn't work because the data is local and not imported directly from an online source. But now that I'm thinking about it, users would have to add their database parameters, so they would have to modify the R files anyways. Should I just leave it as it is?

neelasha23 commented 2 months ago

You can try the Web UI: https://www.platform.ploomber.io/register/ we need to verify the app works on the cloud and document the exact steps so users can follow. You can add ur db credentials in the R file and upload the zip @stanleyo03

stanleyo03 commented 2 months ago

@neelasha23 here is a link to the app: https://postgres-shiny-app.dev.ploomberapp.io/

stanleyo03 commented 2 months ago

@neelasha23 sorry could you approve this again, I noticed there was a missing closed parenthesis in one of the files