useRealtime join?

[bruceharrison1984]

When utilizing useRealtime with a select clause, it is not applied when new data comes in.

For example:

  const [calendarEvents, fetchCalendarEvents] = useRealtime<CalendarEvent>(
    'calendar_event',
    {
      select: {
        columns: '*, owner: user_profile(full_name, avatar)',
      },
    }
  );

The first usage of calendarEvent will have the joined data. Inserting a new item in to calendar_event will trigger a fetch and return the new calendarEvent data, but the owner property on the new data is null. Refreshing the page correctly pulls all data.

Am i missing something here, or is this intended/expected behavior?

[tmm]

This is the expected behavior right now based on how Supabase subscriptions work.

There might be a clever way to detect that a initial query has relations and auto-fetch them on subscription changes.

[bruceharrison1984]

ok, thanks! It's easy enough to create a junction object that does the join anytime the realtime subscription updates.