rapidappio / issues

Rapidapp community-driven issues
0 stars 0 forks source link

Owner user for the DB #1

Open yaniryos opened 1 month ago

yaniryos commented 1 month ago

Hello,

I would like to use the postgraphile (https://www.graphile.org/postgraphile/quick-start-guide/) node library for my DB instance. Some of the features I want to use are the subscriptions and schema updated features.

Currently I get the following error: Failed to setup watch fixtures in Postgres database ️️⚠️ This is likely because the PostgreSQL user in the connection string does not have sufficient privileges; you can solve this by passing the 'owner' connection string via '--owner-connection' / 'ownerConnectionString'. If the fixtures already exist, the watch functionality may still work. Enable DEBUG='graphile-build-pg' to see the error

From my understanding this happens since my user is does not have owner privileges of the cluster. Is there a way to resolve this?

rapidappsupport commented 1 month ago

Hi @yaniryos, Thank you for using Rapidapp. As you guess, we have limitations due to security reasons for SaaS platform, and we use restricted permissions for PostgreSQL databases. We will check the library you shared to understand which PostgreSQL features it uses, then we will respond accordingly today. Hope it works for you

rapidappsupport commented 1 month ago

Hi Again,

We have checked the watch fixture, and it contains risky commands for a free plan cluster. We are about to introduce dedicated postgresql databases where you can use superuser credentials, it will be a pro feature. If you would like to use it, we can prioritize that.

yaniryos commented 5 days ago

Hello Again,Is there any updates on this matter?I would like to use the feature, even if through the pro planBest regards,YanirOn 18 Oct 2024, at 16:52, Rapidapp Support @.***> wrote: Hi Again, We have checked the watch fixture, and it contains risky commands for a free plan cluster. We are about to introduce dedicated postgresql databases where you can use superuser credentials, it will be a pro feature. If you would like to use it, we can prioritize that.

—Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: @.***>

rapidappsupport commented 5 days ago

Hello Again,Is there any updates on this matter?I would like to use the feature, even if through the pro planBest regards,YanirOn 18 Oct 2024, at 16:52, Rapidapp Support @.> wrote: Hi Again, We have checked the watch fixture, and it contains risky commands for a free plan cluster. We are about to introduce dedicated postgresql databases where you can use superuser credentials, it will be a pro feature. If you would like to use it, we can prioritize that. —Reply to this email directly, view it on GitHub, or unsubscribe.You are receiving this because you were mentioned.Message ID: @.>

Hi, thank you for your patience, we are doing our final testings on dedicated plans. Hopefully, we will notify that soon.