I saw this UI in the Auth UI docs but in the library there isn't look like that, the colors are different, font and the modals, how can I create this UI?

I couldn't find how the supabase auth JWTs are stored/encrypted in the browser with docs provided and also would like to know about how those are handled as well?

So I notice on websites I use, they have a signup with google option then a signin with google option. In supabase there is only the signInWithOAuth() function. How can I force users to signup with google before they signin? And is this the correct way to go about things. Signup with google first then signin with google.

I'm trying to filter a list of products by a price that's in a JSONB column. This is an sql example of what I want to do

sql
select * from public."products" 
where ("shopPrices"->>'productWholesalePrice')::numeric > 500;

This works exactly as expected. Finds one product that has the exact price of 51.05.

js
const products = await supabase
    .from('products')
    .select('*')
    .eq('shopPrices->>productRetailPrice', 51.05);

This does not work. It finds a bunch of products with price lower than the specified 500.

js
const products = await supabase
    .from('products')
    .select('*')
    .gt('shopPrices->>productRetailPrice', 500);

I'd appreciate any help ❤️

Regarding any future supabase changes, Is it safe to use app_metadata & user_metadata (for strict vs user editable fields) as opposed to creating a custom profile table? It seems much easier to maintain for me and my code is cleaner using the supabase admin methods. But iirc I read a message on discord or github that supabase can modify auth.users table at any time, but I'm hoping this doesn't affect the metadata objects. Just wanted to be sure 🙂 .

I would like my user to be able to connect from third party app to my own application. I need to create an Oauth2 flow. I need two endpoints :  1) An authorization endpoint that asks the user to sign in if they aren't, and and then redirects back to the supplied redirect URI. It would likely need to encode the user's access token and refresh token in the

code

parameter sent to the redirect URL, as well as pass through the

state

parameter. 2) A token endpoint, that takes in the authorization code, decodes it, and send back the access token and refresh token. I can’t find any resources on how to do this… especially for generating an access_token for user on commands. Do you have an idea on how to solve this ?

Hello I have an existing table and I would like to encrypt a single column from it following the method described in this post https://supabase.com/blog/transparent-column-encryption-with-postgres I have successfully created a pgsodium key using

sql
select * from pgsodium.create_key();

in the SQL editor of my project However when I attempt to run the following (in the sql editor of my project)

sql
SECURITY LABEL FOR pgsodium
    ON COLUMN server_settings.sftp_password
    IS 'ENCRYPT WITH KEY ID MY_UUID_KEY_HERE';

I get the following SQL error

Failed to run sql query: must be owner of event trigger pgsodium_trg_mask_update

I guess I'm doing something wrong but I'm not too sure what. Thanks a lot.

How can I do this SQL query in Supabase JS?

SELECT companies.*
FROM companies
LEFT JOIN company_admins ON companies.id = company_admins.company_id
LEFT JOIN company_members ON companies.id = company_members.company_id
WHERE company_admins.user_id = <logged_in_user_id>
   OR company_members.user_id = <logged_in_user_id>;

I'm not using SSR, so I'm just using

useEffect

and

useState

to set local UI state when data is fetched. Thanks

When I try to load a signed URL for an image, it fails. I'm not sure why--the image is there, the bucket is public, and loading an image from a different bucket works. Can anyone figure out what's going on here?

const { data, error } = await supabase
    .storage
    .from('maps')
    .createSignedUrl(map.src, 600);

When using ssg to prefetch / fetch on the server (inside getServerSideProps), I need to pass a createContext object to the ssg:

const ssg = createProxySSGHelpers({
    router: appRouter,
    ctx: createTRPCContext({
      req: context.req as NextApiRequest,
      res: context.res as NextApiResponse,
    }),
    transformer: superjson,
  });

I'm using the createTRPCContext from create T3 app. Is this okay to do? I have to pass the req and res from the context because I have a Supabase server client in the background that needs that information:

export const createTRPCContext = (_opts: CreateNextContextOptions) => {
  const supabase = createServerSupabaseClient<Database>({
    req: _opts.req,
    res: _opts.res,
  });
  return createInnerTRPCContext({
    supabase,
  });
};

Working on a Next project. I sign in with email/password, redirect to dashboard and seem to lose session/user.id context before I can interact with the DB (400 errors). I've never had this issue before. Also: which approach is the most current: https://supabase.com/docs/guides/getting-started/quickstarts/nextjs or https://supabase.com/docs/guides/getting-started/tutorials/with-nextjs... I'm using the later with createBrowserSupabaseClient. Thanks, -Jake

I see I'm able to check the token expiration to log a user out if their session token is expired, but is there a way to validate whether the user has an invalid JWT in the session? I'd prefer to log the out user right away rather than relying on RLS

anyone knows how to fix this?

Hey @acupofjose I am not sure whether this is a bug or expected behaviour, but when I insert with columns marked with

IgnoreOnInsert

it works on the Supabase side of things, as I expected the timestamps to be generated there. However, when the Postgresql client returns the

ModeledResponse

, the columns marked with the said attributes are blank. screenshots are included below P.S Ty for making this client I am learning so much about C#!!!!! ❤️

Hello, just need a sanity check. Using the JS lib 2.8.0, following the docs to update an attribute in a single record, all seems fine (200) but the DB row isn't modified 😬

await supabase
          .from("vendors")
          .update({ expense_category_id: expenseCategoryId })
          .eq("id", id)
          .select();

The

vendors

table has a RLS Policy for UPDATE:

(auth.uid() = user_id)

The returned record is unmodified. Anything I could be missing??

I am trying to pass access_token in Authentication header to server function and login to as user to make crud requests to supabase as the user from server. I believe ive see similar questions on here but i must be doing something wrong. https://github.com/supabase/supabase/discussions/2125 My sveltekit front end with logged in user seams to successfully send access_token like such

const response = await fetch('/api/user', {
          method: 'GET',
          headers: {
            'content-type': 'application/json',
            'Authorization': 'Bearer ' + session?.access_token
          }
        });

My server component in +server.js in sveltkit looks like this

import { createClient } from '@supabase/supabase-js'
import { env } from '$env/dynamic/public';

export async function GET(event) {
  try {
    console.log('getUserData')
    const authHeader = event?.request?.headers?.get('Authorization')
    console.log('authHeader',authHeader)
    if(!authHeader){
      return new Response(JSON.stringify({ message: 'No Authorization Token Provided'}, { status: 401 }))
    }
    const supabaseClient = createClient(env.PUBLIC_SUPABASE_URL, env.PUBLIC_SUPABASE_ANON_KEY, {
      auth: {
        autoRefreshToken: false,
        persistSession: false,
        detectSessionInUrl: false
      }
    })
    const res = await supabaseClient.auth.getUser(authHeader)
    console.log('userres',res)

successfully prints jwt and i want to get the user sub and login as user but user res says

userres {
  data: { user: null },
  error: AuthApiError: This endpoint requires a Bearer token
      at /node_modules/@supabase/gotrue-js/dist/main/lib/fetch.js:41:20
      at process.processTicksAndRejections (node:internal/process/task_queues:95:5) {
    __isAuthError: true,
    status: 401
  }
}

I bought the custom domain and it says verified not sure if I even followed the process correctly like changing CNAME after or whater. No clue what they were talking about but it says verified. If i add phot to storage still says gibberish url. When i sign in with magic link still get email from supabase. What am i getting from custom domain?

The

<->

operator is from

pg_trgm

extension, I know I can write a rpc function call or order my query results by distance. But I like to use

.order()

directly in JavaScript. is it possible to do so? I checked the doc and this isn't mentioned https://supabase.com/docs/reference/javascript/order

Following the supabase docs for MFA(https://supabase.com/docs/guides/auth/auth-mfa), there is provided code how to enroll a user into MFA: However, the enroll function keeps creating a new enrollment factor on refresh. If a user will keep refreshing the website too many times, he'll get the enrolled factors exceed allowed limit error. Is there a way to reuse a previous enrollment if one exists to stop generating qr codes?

So I'm building this social network and let's take for example the messaging service. I'm using Alpine and Vercel APIs with Supabase. I want to update the conversation when one or both users send a message. How should I do this? I've put the listener (a fetch) in a x-effect but it doesn't seem right. Can anybody explain to me how to achieve realtime updates with this stack?

I am trying to use these libraries inside my supbase function. The function can be created without any issue, but when running it, i am getting this error: > Failed to run sql query: TypeError: plv8.requires is not a function This is my function: > CREATE OR REPLACE FUNCTION login(req json) > RETURNS json AS $$ > > const supabase = plv8.require('supabase-js'); > const { parsePhoneNumber } = plv8.require('google-libphonenumber'); > const { v1: uuidv1 } = plv8.require('uuid'); > const hashJs = plv8.require('hash.js'); > const Hashids = plv8.require('hashids/cjs'); > > // My JS code > > $$ LANGUAGE plv8;

`.from("users") .select(

full_name, phone, user_group.group_id

) .leftJoin('user_group', 'users.id', 'user_group.user_id') .eq('user_group.group_id', group_id) if (error) { throw error; }` Como puedo crear esa consulta? intenté crear una view pero no puedo hacerlo dinamico. ayudaaa!!

So I'm not being able to fetch my data from the database i created, it's a simple function, idk what's going on, no errors too. here's my table- and my code-

export default function Home() {
  const [fetchedData, setFetchedData] = useState(null);

  useEffect(() => {
    async function fetchData() {
      try {
        let { data: cardata, error } = await supabase
          .from("Cardata")
          .select("*");

        if (error) {
          console.log(error);
        }
        if (data) {
          setFetchedData(data);
          console.log(cardata);
        }
      } catch (err) {
        console.log(err);
      }
    }
    fetchData();
  }, []);

return <h1>WELCOME</h1>

and the console (no errors, just an empty array)

I'm using sveltekit supa and prisma

Been playing with Flutter, created a SB project, followed the user management example, corrected the createState() lines, gave myself an invite, which I accepted. But that invite redirected the localhost:3000, so I'm not sure if the account was properly set up. I did not have a chance to set a password. When running the Flutter example, I have to provide that email address to receive an OTP. However there's an error message "An unexpected error occurred ... ". Checking the SB frontend I see nothing in the logs. There's also nothing in the client's logs. Now what? How do you debug something that has no logs?

I have a transform script that extracts data from a json blob and puts the data into a different table numerous columns. For smaller amounts of data (300-600 rows) it works fine, but when there's more data to process it seems to fail. I've tried increasing the timeout in the edge function but that didn't work. I'm calling the edge function via the rest API. Seems to error after about 16 seconds. What can I do to make this work?

Hello I have a column value encrypted using pg crypto. I am able to decrypt it without any issue within the SQL editor. However when I try to use the select method in the supabase.js api I get the following error. This is my query

js
supabase.client
        .from('servers')
        .select(`
                server_name,
                server_settings (
                    sftp_ip,
                    sftp_port,
                    pgp_sym_decrypt(sftp_password::bytea, '${env.SUPABASE_ENCRYPTION_KEY}')
                )`
        )

Using `pgp_sym_decrypt(sftp_password::bytea, '${env.SUPABASE_ENCRYPTION_KEY}')`in my select statement causes the following error. Removing the single quote also causes an error.

An error occurred while fetching server settings {
  code: 'PGRST100',
  details: `unexpected "'" expecting field name (* or [a..z0..9_$]) or "*"`,
  hint: null,
  message: `"failed to parse select parameter

What's the correct way of decrypting a field using pgcrypto in with the javascript SDK? Thank you in advance

Hi , Me and my team were considering using Google SSO for our client , using SAML 2.0 protocol , wanted to know if this feature is fully supported inside Supabase or is it just available to access the Supabase Dashboard ? because we are researching whether Supabase is a good fit for the project we are currently working on

Does anbybody know if there is a way to convert html to pdf with edge functions? I saw that you can take a screenshot but turning that code into generating an pdf does not work https://github.com/supabase/supabase/tree/master/examples/edge-functions/supabase/functions/puppeteer

I would like to contribute to supabase's code base through their Good First Issues but I can't seem to get npm install running locally. 1. I've forked the repo, cloned it and run

npm install

locally 2. But I seem to keep getting this error, logs are below. Stuff that I've tried. 1. Thought it was an

npm cache

issue, ran

npm install --cache ./temp-cache

to test, but it still gets stuck here. 2. Reinstalled VS Build Tools 2019 , as I read somewhere that node-gyp needs it so I thought a fresh installation might help. 3. Run

npm install -g node-gyp

and it installs successfully and I can get its version, but

npm install

still fails there. Any ideas?