Hey, I'm trying to develop locally with Supabase. What is the good way of setting up the same tables and policies on my local machine and on Supabase's site? I assume from the supabase CLI that link might help with this, but I'm not able to find much documentation.

Hey all, I am wondering if it is possible to have 2 unqiue fields combined, like I want to have userid unique AND postid unique. How would that work?

hey all, I was wondering what's the best way to restrict update permissions to only some columns in a table? I've run a

GRANT

command in a SQL editor, following the suggestions here https://github.com/supabase/supabase/discussions/346 but then there's no way that I can see to review the saved permissions. What happens if I rename a column for instance?

Hi! I am new to Supabase and have watching some tutorials. But my use case is a bit different *I only want me as an admin to be able to add users, manually * Is this achieved by the following? - Set

Disable Signup

to true - Invite users in the Supabase UI: Authentication/Users/Invite

What's the difference between the

contains

and

containedBy

filters? The documentation doesn't say what the examples would return, so it's not super helpful 😦

My hosted supabase instance got restarted (idk why) and then I can't no more see the `pg_graphql`'s

graphql

endpoint

Is it possible to authenticate and make calls to supabase within a chrome extension? Trying to make an extension that accompanies my web app, and is populated by supabase

i love supabase ❤️

So when I pull down my database for prisma, it doesn't pull down the users table. So when I try to reference a user id in my prisma, I don't have the ability to do so because prisma doesn't support foreign keys. How do you guys get around this with using prisma and supabase?

Hello Is there a proper way to check if a user exists on the database when doing a sign up?

Does anyone have suggestions to prevent malicious database modification from users? I'm designing an application where basically all the runtime will be through Edge Functions, but don't want users to authenticate themselves using their bearer token for direct database access (even with RLS). Would it be best to proxy all user data through system-level database access within the function and give users zero access by themselves?

is there a way to generate shorter uuids? rn im using uuid_generate_v4() but id like something thats preferably 5 symbols long

Is it possible to get function hooks on old projects? All of our projects are using http right now which is less than ideal

Hi devs, just curious to know in gotrue what is difference between invite and magiclink both send invite only right? https://github.com/supabase/gotrue#post-admingenerate_link

Hello @busch! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

How can i select only certain fields to be returned in data after an insert operation using supabase db apis

Hi, I feel like I must be missing something obvious here, but anyway. Currently trying to evaluate Supabase for a project I need to get moving on (the other option I'm looking at is Parse). I've set up self hosting using Docker (self hosting is important for this project), and I see "Default Organization" and "Default Project"... I assume it is possible to set up new Organizations and Projects, but I can't see how in the interface or in the documentation and so far googling hasn't given me the answer either.

Howdy! I understand that the GraphQL API is in beta but I was curious if we can use it in local development. I've tried the

/graphql/v1/

endpoint on my local API after enabling and rebuilding the graph but I get this response when I try to query anything

{
  "message": "The schema must be one of the following: public, storage"
}

I mostly just want to make sure I'm not missing something obvious. 🙂

Hey, I want to sync my db with data from a 3rd party API and was wondering what you guys would recommend? My idea was either: 1. create a supabase function that fetches the data, then call it with

pg_cron

and

pgsql-http

2. use

pg_cron

with

pgsql-http

and fetch the data from the database directly Or if you have any other ideas lmk 😛

@User I wanna report a bug: Using pg_graphql and Apollo studio, there is no way to make

Update<db>Collection{}

worq. Always get this error msg:

json
{
  "data": null,
  "errors": [
    {
      "message": "missing FROM-clause entry for table \"f\""
    }
  ]
}

This is my mutation and variables:

json
mutation UpdateCommentCollection($set: CommentUpdateInput!, $filter: CommentFilter) {
  updateCommentCollection(set: $set, filter: $filter) {
    records {
      id
      created_at
      text
      user_id
      nft_id
    }
  }
}

{
  "set": {"text": "Bad one!"},
  "filter": {
    "id": {
      "eq": 3
    }
  }
}

I'm facing an issue where INSERTs and UPDATEs are not replicated (realtime) but DELETEs are?

If I want to use an already running instance of PostgreSQL on the system would just adding the host to the docker compose and changing the relevant URLs work or is there more I have to configure inside of the database?

Does supabase have any example for storing tree structures? I am looking if there is any implementation like this in Django so that I don't need to reinvent the wheel https://pypi.org/project/django-treebeard/

I am really new to back end stuff like functions etc .. so not sure if it's possible to run python etc scripts with edge functions

Anyone using supabase with astro.build?

09:58:24 AM [build] Building for SSR...
[vite:resolve] Cannot bundle Node.js built-in "stream" imported from "node_modules/.pnpm/node-fetch@2.6.7/node_modules/node-fetch/lib/index.mjs". Consider disabling ssr.noExternal or remove the built-in dependency.
 error   Cannot bundle Node.js built-in "stream" imported from "node_modules/.pnpm/node-fetch@2.6.7/node_modules/node-fetch/lib/index.mjs". Consider disabling ssr.noExternal or remove the built-in dependency.

Astro provides a global version of fetch, but I'm not sure how to tell Vite to use that one instead of 2.6.7

Hello @martinemmert! This thread has been automatically created from your message in #843999948717555735 a ``few seconds ago``. Pinging @User so that they see this as well! Want to unsubscribe from this thread? Right-click the thread in Discord (or use the ... menu) and select Leave Thread to unsubscribe from future updates. Want to change the title? Use the

/title

command! We have solved your problem? Click the button below to archive it.

hey guys, I'm trying to do a text search on my database but I'm not getting the results I need I have a "Post" with a title colum and I store german words in there say I have this title "Ernährung bei einem hohen Cholesterinwert" I tried this statement right here

sql
select * 
from "Post"
where 
  to_tsvector('german', title) 
  @@ to_tsquery('german', 'chol');

but I'm not getting any results, any idea why?

Hello, Is it possible to change region once you've started a project? Can you redeploy somewhere else or do you have to restart all your project?

Hey, I'm tryin to setup discord authentication, but unfortunately whenever I'm changing a value in the authentication settings (or pressing save after changing an input box) the following message appears and the changes won't get saved:

Update config failed: An error has occured: Failed to fetch

hey guys, question not sure why but if i have RLS on and i fetch data from svelte endpoint its only working if RLS is off however if i fetch the data from my store, it works, Im not sure if my authentication is the issue that is causing it