??

@User I an organizing a Twitter Space to talk about Serverless Platform as a Service (SPaaS) like Supabase. I was hoping to connect with someone that does Dev Rel to see if I could get someone to represent Supabase in the online dicussion. If someone could send me a DM here in Discord I'd apperciate it

This is me: 👉 https://twitter.com/andrewbrown I'm known for free cloud certification videos courses

Sounds cool @User ! What timezone? it can be any of - me, @User , @User , @User or possibly others depending on timing

I only need a single speaker but the rest can join. I'll DM you my form to figure your time preference

Hello, is the rest API of Supabase down? We are getting many timeouts in production

Hey, could someone please help me out to make a one-to-many relationship between two tables? I have 2 tables: jobs - id, - title - company_id companies - id, - name How do I query Jobs together with companies? (One company can have multiple jobs)

I am trying this but it does not work:

supabase
      .from('companies')
      .select(`id, name, jobs ( id, title)`)

Getting an error:

hint: "By following the 'details' key, disambiguate the request by changing the url to /origin?select=relationship(*) o…"

message: "More than one relationship was found for companies and jobs"

I think there's a problem with your query.. This should work:

supabase
        .from('jobs')
        .select(`id, title, companies ( id, name )`)

Make sure you have set company_id as a foreign key

still same error ;/ works well without

, companies (id, name)

part. Maybe I did not set the foreign key correctly... The only thing I did, I added a relation from Jobs table to Companies: company_id → public.companies.id.

The foreign key seems to have been set up correctly

Unfortunately I'm not sure why you're getting an error :(

I am new to this, but pulling my hair for 2 hours now....

here is the code I am trying btw:

js
import { useState, useEffect } from 'react'
import { supabase } from '../lib/initSupabase'

export default function Index() {

  const [jobs, setJobs] = useState([])

  useEffect(() => {
    fetchJobs()
  }, [])

  async function fetchJobs() {
    let { data: jobsData, error } = await supabase
      .from('jobs')
      .select(`id, title, companies (id, name)`)
    if (error) console.log('error', error)
    else setJobs(jobsData)
  }

  return (
    <ul>
      <li>
        {jobs.map((job) => (
          <div key={job.id}>{job.title}</div>
        ))}
      </li>
    </ul>
  )
}

Hello everyone, I've just started playing with supabase, great product ! My first question is: how can I see for a table if the real time is activated or not ? Edit: found it in the docs: https://supabase.io/docs/guides/api#managing-realtime Thx

Edit: Ignore as misread question: In the UI it is under Authentication then Policies.

I can see that RLS is activated but realtime ?

The only way I've seen is to run

alter publication supabase_realtime drop table table_test;

and it'll tell me that there is nothing to drop ie. realtime is off

Sorry, read to quickly. Database Replication then Realtime is off the right. Seems different than when I set it up.

More tricky question, how can I activate realtime outside of supabase UI ? I've tried

alter publication supabase_realtime add table table_test;

from a node client or by wrapping it in an RPC but I always get:

must be owner of publication supabase_realtime

Enable realtime outside of Supabase UI

does your migration approach handle storage changes? I think there's probably a way to do it by writing a custom script to diff changes against entries in storage across db's. Curious if anyone has done that yet

Get some of that sweet sweet #swag!! https://twitter.com/_dijonmusters/status/1450941750248415232?s=21

the sizes run slighty on the small side, so a US medium would probably need an L

Oh really? I am a UK medium and the small from your sized looked like it would work. Would you recommend k just get the medium?

5 in a row! ⭐ ⭐ ⭐ ⭐ https://twitter.com/kiwicopple/status/1451104569266671619

Does anyone have a good workflow on keeping your production and staging database sort of in sync? I find myself replicating a lot between them and there must be an easier way lol

#ASK Is it possible for filtering with

.textSearch

with multiple table ???? For example this is what i really want :

dart
var response = await this._supabase.from('publisher').select().textSearch('name', 'email', data).execute();

So i can filter based on the

name or email

column.