Hi does someone know how I can make an stored procedure in the supabase cli using sql, or has a good reference where I can find that?

Hi, how many simultaneous realtime connections can the free db hold ?

What's the difference between having user profile data stored in the "user_metadata" vs a 'profile' table?

Hi, I'm new to this kind of SaaS apps, I try a few things with the documentation and I found myself limited very soon, I was trying to make a UI for my web game where my registered users can change their avatar ( a field in his row in the profile table), choosing one from X existent avatars. The thing is, I don't want the user to be able to update all the row, but just a few field like the already mentined avatar. Other fields in the profile table may be acquired by microtransactions like premium currency amount. Should I make a backend API to handle this with service_role tokens instead of letting the user interact directly with the tables?

Hey! Is it possible to create DB schemas in code and then push them to supabase? I'm looking for something similar to Laravels DB migrations but within a React ecosystem

Hi, I have a json file that has 7000 ingredients, I looped through all of them and tried to write to supabase database, however for some reason 70% of the writes fail?

const writeData = async () => {
      const { data, error } = await supabase.from('ingredientsjson').insert({
        productName: newIngredient.productName
      });
      if (error) {
        console.log(`${newIngredient.productName} document failed to write`);
      }
    };
    writeData();

What is the reason for this, how can I even properly populate my database?

Good afternoon to all, sorry for the inconvenience, I am trying to use realtime in my project, my intention is to be able to show alerts or database changes through a notification, I am using JS and I have not been able to make changes directly from the database so I can print something by console, I use VUE as a framework and I am bringing through a method that runs on the mounted but I do not receive any information, any help would be wonderful, thank you very much and happy day.

How would I write this query with the querybuilder?

select credit, website from collaborators, "participations-in-collabs", collabs where collaborators.id = "participations-in-collabs".collaborator and "participations-in-collabs".collab = collabs.id and collabs.id = SOME VARIABLE

I tried

js
const {data, error} = await supabase.from('collabs').select(`
collaborators (
  credit,
  website
)`).eq('collabs.id', id);

but I'm getting the following error:

null {
  code: 'PGRST108',
  details: null,
  hint: "Verify that 'collabs' is included in the 'select' query parameter.",
  message: "Cannot apply filter because 'collabs' is not an embedded resource in this request"
}

Any chance I could change the redirect url for auth actions? I want to handle such requests on my server, but can't parse the query parameters because supabase uses

#

instead of

?

(For example:

http://localhost:8000/endpoint#error=unauthorized_client&error_code=401&error_description=Email+link+is+invalid+or+has+expired

) Can I change somehow to be a valid query param url?

I have a unique authentication / authorization set up that I'd like to implement with Supabase. It will include multi-level authorization, so that a computer can be "logged in" to the system, and employees can "clock in" and have their own profiles underneath it. Employees won't stay logged in, but will enter a personal 4-digit code to authorize actions against the DB. Is this kind of set up possible with Supabase?

Is there any info on when supabase realtime will work with views? The only workaround I found is making a new table that "syncs" with the view using a trigger and then subscribing to that table.

how can I check my current PostgREST version? I know you can get psql version with

SELECT version();

How do I resolve a 400 error when I'm testing a password reset action?

I have my database set up with a mix of email/password & invitation signup and I'm looking for inspiration: What kind of strategy do people suggest for periodically cleaning out the Users table of rows that are still awaiting confirmation after the link has expired?

Can you authorize a DB query based on a value passed to the DB in addition to the JWT?

is there a way to internally loop while doing bulk inserts? right now i'm just doing a for loop

Hello @49Ryann! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Is there anyway to autopopulate profile data into the logged user instead of a secondary call?

Does anyone know of a tutorial/guidance on handling multiple users under a main account table? I basically need users signed up and invited. That would be listed in an account table,

Hello @TypeNull! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Does anyone know if we have access to the user metadata when using a database function & trigger? Having a hard time finding that documented. When Signing up a user.

I am trying to get

supabase/postgres

running in k8s but every it starts, it fails and then says that I don't have permission to the directory. If I turn off persistent volume claims, it's fine. Any idea why?

I set up auth with the discord provider, and I was wondering if there's a way to get the discord API token to make requests?

Is there a way to perform a transaction with a database insert and a file insert in a storage bucket? If not, I could maybe simulate it. Create a table which records file insert (table name: file_insert). When I'm going to insert a file in the storage bucket, I add a row in the table with the file path, file name and date of insertion (date of insertion is the date it tried to insert the file in case of failure). When the file insert is done, I perform a transaction which does the insert I want in the db and remove the corresponding record in the file_insert table. If the transaction fails, it's not a problem. I will have a function called each day that will look into the file_insert table for rows where the date of insertion is > than a given threshold. If the date of insertion is > than the given threshold, it means that the insertion in the storage bucket either succeed or failed but for sure the insertion in the db failed. In this case, I can delete the file from the storage bucket (if it exist in the storage bucket). Hence, it's similar to a transaction which includes the db insert and the file insert, right?

I'm trying to update the auth token in a realtime subscription. Is that payload wrong? I'm getting phx_error when sending this:

json
{
  "topic": "realtime:public:products",
  "event": "access_token",
  "payload": {
    "access_token": "token"
  },
  "ref": null
}

Hello @garyaustin! This thread has been automatically created from your message in #843999948717555735 a few seconds ago. We have already mentioned the @User so that they can see your message and help you as soon as possible! 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.

Is supabase down? My project and dashboard are both not opening

This isn't related to Supabase. Does anyone know how I can style the gesture bar on Chrome for Android? The meta theme color only does the top bar, as shown.

Hi, is it possible to set the current date as the default value of a column?

hey all -- getting a 504 error for my supabase project. cant connect to my project in the dashboard either.