nvm figured it out

Hi, I just created a new Supabase project and I want to read some data from the table, but I'm getting a 401 error JWSError JWSInvalidSignature

hello. does supabase connection pooling work with third party serverless functions i.e vercel. or just supabase serverless functions?

nvm. I had to delete my old project stuff from localstorage

Does supabase connection pooling work with other serverless providers

Please don't post the same message in multiple channels.

👋 My newly released supabase app received 10's of thousands of signups, and now simple queries are timing out and the app is dead. The app is very straight forward, but it looks like some queries need to be streamlined and optimized. Is anyone knowledgeable in both Supabase and Postgres available for some paid freelance trouble shooting? I'd be really grateful if someone can help out with this and get the app back online. 🙏

how can I test my supabase database with postman? I have 2 headers: x-api-key and Authorization Bearer , but it's giving me "message": "No API key found in request" error

i got it working. headers didn't work so I used params

I have an issue using supabase and prisma, I have foreign keys which have a int8 type I am trying to fetch my data like this:

js
export default async function handler(
  req: NextApiRequest,
  res: NextApiResponse
) {
  const snippets = await prisma.snippets.findMany();
  const allSnippets: ISnippet[] = snippets.map((snippet) => ({
    ...snippet,
    id: snippet.id.toString(),
  }));

  res.status(200).json({ allSnippets });
}

js
export async function getServerSideProps() {
  const res = await fetch("http://localhost:3000/api/snippet");
  const snippets = await res.json();

  return {
    props: { snippets },
  };
}

But I get this error:

error - FetchError: invalid json response body at http://localhost:3000/api/snippet reason: Unexpected token < in JSON at position 0
error - TypeError: Do not know how to serialize a BigInt

Btw the videos on this page https://supabase.io/docs/guides/with-nextjs do not work, the console returns a 404, someone should have a look at that.

Hi everyone... I'm trying supabase local development and cannot "register" nor "invite" new users (myself mainly) ... The confirmation email never goes through ... Anyone can give me a clue ?

supabase timeout

The supabase client has gone through an extensive rewrite and my wild guess is that there's no support yet ... like for example there was before with "inbucket"

How should I "create" users in the local development environment ?

Does the GOTRUE_MAILER_AUTOCONFIRM params set that there's no confirmation needed? ... No need to invite just do a "signUp()" ?

Unable to register or invite users

Hi 🙂 I have accidentally overridden my database, and usually when this happened i could always jsut go to backups and restore a previous state. However, something apparantly changed, I cannot do this in the free tier any more 😦 Is it possible to somehow get last weeks database back, without upgrading to premium...? The only reason I need it is because its my personal todo list 😂 im the only user of my app and I really want my todos back, I don't wanna do it regularly, just a one time thing, because im stupid and i will go back to a physical todo list once i get my data back 😛

Hello guys! I have a problem with my #Supabase account. My database seems to have "Restoring" state since approximately 3 days, and I don't know how it happened. Are you able to help me with that please ? 🙂

anybody have any recommendations for how to run a webhook when a certain row is changed in the database?

Upsert using Postgresql function

Webhook on row change

backups

Seconding this

guys, can I have my database replicated across the globe? so if I have lambdas in different locations, they will be able to access data quickly?

I'm having downtime on the realtime websocket connection on two independent projects hosted in different regions. I see nothing on Supabase Status page yet Anyone experiencing the same?

ah, here it is

Just started getting these messages on both localhost and on prod url. Access to XMLHttpRequest at 'https://nfs......supabase.co/auth/v1/token?grant_type=password' from origin 'https://g.....d.vercel.app' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: No 'Access-Control-Allow-Origin' header is present on the requested resource. I hadn't pushed any changes to vercel (last 23 hours), so it seems possible something changed at Supabase ?

Hi guys, is there a way to concat in a select ? Like so:

const { data: parts } = await supabase
      .from('parts')
      .select(
        "CONCAT(root, '-', REPEAT('0', 5 - length(number::TEXT)), number, '-', revision) AS SERIAL"
      )
      .order('serial')

I checked both supabase's and postgrest's documentation but can't find any mention of concat and nothing in github issues