https://supabase.com/ logo
Join Discord
Powered by
# help
  • u
    I thought we couldn't query the auth table directly, and to answer my own question we can use a table the links to the auth.users. ill try it out
  • a
  • r
    Hello everyone ! I love Supabase so far but I make a lot of small projects and the limit of 2 projects is not great for my type of use... What do you use for small projects/mvp? Still want to learn sql. I think a random ORM and a free host for a small sql database will be enough but maybe you already did that and have a specific setup that you think is great!
  • d
    Forgot to reply, Thank you
  • h
    I'm getting this error with prisma `Error: Invalid 
    prisma.home.findMany()
    invocation: Can't reach database server at `db.gbipqzshtnpxnvypbilh.supabase.co`:`5432` Please make sure your database server is running at `db.gbipqzshtnpxnvypbilh.supabase.co`:`5432`.`
  • h
  • n
    Hey all - has anyone ever integrated a headless cms (e.g sanity) or similar with supabase as a backend? Or sync data between them? THoughts?
  • b
    Hey y'all, I'm trying to mimic the 
    todos
    table setup from the Supabase templates. I'd like users to be able to to all of the CRUD operations (
    INSERT
    , 
    SELECT
    , 
    UPDATE
    , 
    DELETE
    ) on their own data. I've set up a table that looks like the one above, and set up RLS as shown above. I'm running into an issue where a logged in 
    user
    is unable to 
    SELECT
    any data at all. There are no errors in the API request, just seeing an empty array 
    []
    for the returned 
    data
    object. The only difference between my table and the example 
    todos
    table are a few of the column names, one of which being 
    userId
    in my table versus 
    user_id
    in the example table. Could that make a difference? If so, why? Here is my source code if you're interested in taking a peek. https://github.com/bradgarropy/next-todo
    g
    • 2
    • 8
  • b
    Hey @User did you figure this out ? I have a similar case and I'm not sure how to implement it.
  • v
    I didn't, sadly. I just made my search function work differently for now until I find a better solution
  • t
    Is possible make "invalid" a token generated?
  • p
  • p
    Think Iā€™m having the same issue. My select Claus is just returning an empty array.
  • p
    Fixed this with the help of Paul from supabase. I had RLS turned on. šŸ¤™šŸ¼
  • b
    How did you get in touch with Paul or vice versa?
  • p
    Just tweeted supabase with a code example. I used https://carbon.now.sh/ It just happened that Paul tweeted back.
  • w
    Hi I am running a self hosted version of supabase
  • w
    docker-compose up gets the instance up just fine
  • w
    But if I do docker-compose down and then docker-compose up again, all my tables are gone!
  • p
    Should this be the right way to right a join?
    Copy code
    SELECT
        "constraintId",
        sja."audienceId",
        sja."segment",
        sjs."source",
        sjct."constraintType",
        "constraintValue",
        "targeting",
        "frequency",
        "period"
    FROM "SignalJourneyAudienceConstraints"
    JOIN "SignalJourneySource" sjs ON "SignalJourneyAudienceConstraints"."sourceId" = sjs."sourceId"
    JOIN "SignalJourneyConstraintType" sjct ON sjct."constraintTypeId" = "SignalJourneyAudienceConstraints"."constraintTypeId"
    JOIN "SignalJourneyAudiences" sja ON sja."audienceId" = "SignalJourneyAudienceConstraints"."audienceId";
  • p
    Copy code
    const { data, error } = await supabase.from(
      'SignalJourneyAudienceConstraints'
    ).select(`
        constraintId,
        audienceId:SignalJourneyAudiences (audienceId),
        segment:SignalJourneyAudiences (audienceId),
        source:SignalJourneySource (sourceId),
        constraintType:SignalJourneyConstraintType (constraintTypeId),
        constraintValue,
        targeting,
        frequency,
        period
      `);
  • p
    source: {sourceId: 3}
    it kinda works...i just need toe source and not the id
  • p
    this is a row.
    Copy code
    {
  "constraintId": 1,
  "constraintValue": "*webmd.com/allergies*",
  "targeting": true,
  "frequency": 1,
  "period": 1,
  "audienceId": {
    "audienceId": 1
  },
  "segment": {
    "audienceId": 1
  },
  "source": {
    "sourceId": 3
  },
  "constraintType": {
    "constraintTypeId": 20
  }
}
  • p
    i keep getting this too
    Copy code
    Unhandled Runtime Error
Error: Objects are not valid as a React child (found: object with keys {audienceId}). If you meant to render a collection of children, use an array instead.
  • g
    RLS issue
  • n
    RLS insert trouble
    g
    • 2
    • 11
  • s
    Can supabase be used as a backend for games made in Unity and Unreal
  • s
    ??
  • s
    just got a question
  • n
    @User isn't unity c#?
1...232233234...316Latest