I would think that is a bit more complicated than what I had suggested, are you using any authentication or is it all public?

i am using authentication, and i already have a table post_activities where i store comments, likes, so its logical what you are saying

so i will probably store new row with type: 'view', with post id and user id

public IP addresses change occasionally, so you would have to take that into consideration using IP as a relation

Hey there is there a way to format date column to 'dd.mm.yyyy' and filter it using LIKE operator ?

filtering dates

Can I join a many to many relation to a single object instead of an array? (I only expect one result anyway) - edit: got it 🙂

My supabase magic link emails all go to spam. Is there a way I can fix it?

await supabase.from("*").delete();

is this possible to reset the DB without dropping tables?

Is there a way to enable delete cascade on the Supabase UI?

What is the format of the URL in

supabase db remote set URL

? An URL that works with psql causes an error with supabase: Error: Error parsing connection string: Make sure the URL is percent-encoded.

Hi, im getting invalid refresh token even though the time of request is less than the expires_at time?

#843999948717555735 Hello, Is it possible to run a query with filters on another column, like: final res = await supabase .from('cities') .select('*') .eq('columnA', 'columnB') .execute();

is there a way with the Supabase CLI to clean up after i close a terminal without termination supabase local instance first supabase start wont run because all the docker containers are already there

i have cleaned up manually, but would be nice to do it with a single Supabase CLI command

I have a table with group memberships (group id user id) and i want to create RLS to enforce that when someone creates a new post, the post's "group" column is only with an eligible group id. Is this possible with RLS? I'm having trouble coming up w/ the SQL expression. Here is the SQL expression to get the valid group id:

SELECT group_id from group_memberships WHERE user_id = auth.uid()

Is it possible to send additional params using the

.signIn()

method? I know it's possible to set metadata with the

.signUp()

call, but since we are mostly using OAuth providers and magic email links we are using

signIn()

everywhere

Does anyone know if something like this is possible using Magic.Link and Supabase? Do the cloud functions here look possible to emulate in Postgres functions? https://magic.link/posts/magic-firebase-integration

Hey I need to collect more info on email signup, is that possible, I've got a table for user profiles with all the necessary columns and I was hoping I could send that info to the appropriate place when the user signs up but I know you can't add columns to the Auth table. what's the best way to setup my backend so I can collect a bunch of meta information (as text) that get's submitted on signup?

Can someone help me figure out why I'm getting a 406 error when trying to retrieve my user info following the Supabase quick start documentation?

I have essentially their unmodified provided code. I'm able to login, I'm able to upload a profile picture and user information, and I see it correctly stored in the database through the Supabase admin panel. However when I log back in, it just refuses to load the profile pic and user information and instead gives me a 406 error.

Relevant code -

javascript
Account.js
import { useState, useEffect } from "react";
import { supabase } from "../utils/supabaseClient";
import Avatar from "./Avatar";

export default function Account({ session }) {
  const [loading, setLoading] = useState(true);
  const [username, setUsername] = useState(null);
  const [website, setWebsite] = useState(null);
  const [avatar_url, setAvatarUrl] = useState(null);

  useEffect(() => {
    getProfile();
  }, [session]);

  async function getProfile() {
    try {
      setLoading(true);
      const user = supabase.auth.user();
      console.log(user);

      let { data, error, status } = await supabase
        .from("profiles")
        .select(`username, website, avatar_url`)
        .eq("id", user.id)
        .single();

      console.log(status);
      if (error && status !== 406) {
        throw error;
      }

      if (data) {
        setUsername(data.username);
        setWebsite(data.website);
        setAvatarUrl(data.avatar_url);
      }
    } catch (error) {
      alert(error.message);
    } finally {
      setLoading(false);
    }
  }

The error in browser:

Hello - our application is using algolia for search and supabase for db.. whats the best route to keep everything in sync (e.g trigger updates to algolia indices when there are changes in supabase)?

Additional information on signup

Is it just me, or is anyone else unable to sign in to the dashboard now as well? I get the following error message in the URL:

https://app.supabase.io/?error=server_error&error_description=Error+getting+user+email+from+external+provider

I just logged in successfully

Generating Types | Supabase

How can I set the policy to grant insertion rights only to designated users?