Supabase #help

silentworks

11/02/2021, 2:05 PM

Concat in select with js supabase client library

Zenon

11/02/2021, 2:32 PM

Hey everyone, I had a doubt with postgres I have two tables, unrelated. table users has a column tags which is a text array, something like ['a', 'b'] table videos has a column video_tags which is also a text array like ['a', 'b' 'c'] I want to write a function which basically compares the two arrays, and provides a list of videos where the users.tags[] have something in common with videos.video_tags[], in the descending order of the count (no of matching keywords) Also I'm faily new to postgres functions so it'd be nice if you could help me with the syntax to write in the function definition, I'll be taking in the user_id as the only argument.. Thanks :))

alx90

11/02/2021, 3:46 PM

Hey guys, its really crazy but I still get no data 😄 Could you plase have a look on my code and maybe could say me what Im doing wrong?

Copy code

//my supabase.js in my lib folder 
import { createClient } from "@supabase/supabase-js";

export const supabase = createClient(
  "XXXXXXX.co",
  "anaon-key"
);

and here my index.js

Copy code

import { supabase } from "../lib/supabase";


export default function Home(props) {
  async function getUsers() {
    const { data, error } = await   
    supabase.from("users").select();
    console.log(data);
    //data: [] WHTA THE HELL XD ?!
  }

  useEffect(() => {
    getUsers();
  }, []);

  return (
    <div className="App">
      <Head>
        <title>PageBuilder - Ambitive</title>
        <link rel="icon" href="/favicon.ico" />
      </Head>
    </div>
  );
}

here is my data: I really dont know why im getting no data 😦 I consoled.log my error nad its null so I think the request is successfully :/

Scott P

11/02/2021, 5:39 PM

select("*")

nw_matt

11/02/2021, 8:17 PM

Is it possible to generate new auth credentials from a current auth + refresh token? I'd like to provide auth from a currently logged-in session (in browser) to an external app (via a localhost url redirect for example)

garyaustin

11/02/2021, 9:03 PM

Select Not Working

louis.barclay

11/02/2021, 11:58 PM

Hi all! I think my Supabase is broken/not in good shape. See this message - sign up is suuuper slow or not working, and that's the case even when trying to add (invite) a new user via the dashboard, suggesting it's not an issue on the side of my codebase. I don't think I've made any significant changes to my Supabase set up recently. Any help much appreciated - am losing business because of this. https://discord.com/channels/839993398554656828/839993398554656831/905243478202662913

AirDiamond

11/03/2021, 4:49 AM

In a plpgsql trigger function I have the following "IF" statement. But I can't get the code inside to fire no matter what I try: = null, != null, = 0, !=0, =3, >16, etc. "official" is an int8 field. If I remove the IF statement, the code inside executes fine. Any ideas? >

Copy code

IF NEW.official != null THEN
> do stuff...
> END IF;

AirDiamond

11/03/2021, 4:59 AM

I just figured it out: IF NEW.official IS NOT NULL THEN

DOPΣ

11/03/2021, 6:28 AM

Why The supabase is so slow

jonny

11/03/2021, 6:31 AM

Got any more info ?

philbookst

11/03/2021, 9:48 AM

hey guys, i'm using the supabase js client as single exported variable just like here: https://github.com/vercel/next.js/blob/canary/examples/with-supabase-auth-realtime-db/lib/initSupabase.js now if i'm getting more than 10 concurrent requests on my site, the load time increases dramatically and leads to serverless execution timeouts but less than 10 reqs perform well i inspected the active_connections using the supabase sql templates and it shows me max_connections 60 and active connections always got stuck at 12 even if i 30 or 50 concurrent requests would come in any idea on how to fix this?

user

11/03/2021, 12:18 PM

Hi! Does self-hosted supabase require any postgres extensions or does it work on a raw postgres instance? Couldn't find anything about this in the docs

user

11/03/2021, 12:19 PM

My use case is that I want an realtime api and auth for timescaledb

M0nk3yBrainDead

11/03/2021, 1:04 PM

Can I connect to the database using flask sqlalchemy? (I'm new to databases 😅)

rishav

11/03/2021, 3:02 PM

Hi. regarding pricing, the trasfer limits are per day, week or month?

egnus

11/03/2021, 10:05 PM

Hello, dumb question, i guess, but how to add a function as default value in the UI of supabase for certain fields? Like uuid_generate_v4 suggestion

user

11/04/2021, 12:22 AM

Can't find my storage buckets. Error http://localhost:3000/buckets?select=id%2Cname%2Cpublic%2Cowner%2Ccreated_at%2Cupdated_at failed, reason: connect ECONNREFUSED 127.0.0.1:300

user

11/04/2021, 12:22 AM

Any one faced the issue on storage buckets

user

11/04/2021, 12:22 AM

Scott P

11/04/2021, 1:15 AM

Are you running the Supabase server on your local machine, and on port 3000?

user

11/04/2021, 1:58 AM

This is on the supabase project dashboard . The online version

user

11/04/2021, 1:59 AM

I am not running this locally. Might be a misconfigured deployment or something its strange

iamvp7

11/04/2021, 10:08 AM

Is there any development in progress for Java client for Supabase like Dart / Javascript ?

M0nk3yBrainDead

11/04/2021, 12:46 PM

Does supabase work like a normal database?

M0nk3yBrainDead

11/04/2021, 12:46 PM

In connecting by link or stuff

M0nk3yBrainDead

11/04/2021, 12:47 PM

I want to connect it by flask-SQLAlchemy

silentworks

11/04/2021, 1:43 PM

Supabase a normal database

rchampourlier

11/04/2021, 3:33 PM

I'm getting

PrismaClientInitializationError: Error querying the database: db error: ERROR: no more connections allowed (max_client_conn)

using Supabase PG with pgbouncer in a NextJS/Vercel deployment (with serverless functions). I've followed Prisma serverless instructions (https://www.prisma.io/docs/guides/performance-and-optimization/connection-management#serverless-environments-faas). I don't really see how to investigate where the issue could come from, having not much information on pgbouncer's instance. @User ! I see you encountered the same issue, did you find a solution? Thanks for the help!

DOPΣ

11/04/2021, 6:17 PM

Anyway to get the results faster?