Relative Content

Tag Archive for supabasesupabase-database

How to connect two separate projects to same docker local development database

I have followed the local development process in the Supabase docs for setting up my docker + database environment. I can use the supabase cli tools just fine to connect to it. However, I’m interested in creating a new, separate api, for talking to the underlying docker container and database. Essentially, can I spin up one repo with the migrations, run the supabase start script there, and have other repos simply connect to this existing container without having to create a whole new container?

Order by computed column in graphql supabase

Is it possible to order by a computed column with graphql ? Assuming to this discussion, it is possible with supabase client API call : https://github.com/orgs/supabase/discussions/7875

Column already exists when running local migration

I am running supabase locally I have been using the Studio to create tables and their columns I have been pushing the latest migrations up with supabase db push When I run supabase migration up, I get this error ERROR: column “story” of relation “initiatives” contains null values (SQLSTATE 23502) At statement 3: alter table […]

supabase – column already exists when running local migration

I am running supabase locally I have been using the Studio to create tables and their columns I have been pushing the latest migrations up with supabase db push When I run supabase migration up, I get this error ERROR: column “story” of relation “initiatives” contains null values (SQLSTATE 23502) At statement 3: alter table […]

Running Supabase locally, ‘relation does not exist’ issue

I am working with a GitHub repo and trying to get the project to run locally on my machine. I am not the original creator of the project.
The .env file has a NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_ANON_KEY and SUPABASE_SERVICE_ROLE_KEY. I set up a Supabase account and was able to set NEXT_PUBLIC_SUPABASE_URL and NEXT_PUBLIC_SUPABASE_ANON_KEY, but SUPABASE_SERVICE_ROLE_KEY I am not sure what to set.
Anyways, when I run npx next dev, I get the following issue.