rule_channels

rules

channels

js
const response = await supabase
  .from('rules')
  .select(`
    id,
    words,
    rule_channels:channels( title, thumbnail_url )
  `);

mentions

rule

id

Site URL

Additional Redirect URLs

const { user, session, error } = await supabase.auth.signIn({
  provider: 'github'
}, {
  redirectTo: 'https://example.com/welcome'
})

typescript
export const getAllBoards = async () => {
  const { data, error } = await supabase.from<BoardType>('board').select('*');
  if (error) {
    console.log(error);
    return [];
  }
  return data;
};

getServerSideProps

typescript
export const getServerSideProps: GetServerSideProps = async (context) => {
  const { user } = await supabase.auth.api.getUserByCookie(context.req);
  if (user) {
    const boards = await getAllBoards();
    return {
      props: {
        _boards: boards,
      },
    };
  }
  return {
    props: {
      _boards: [],
    },
  };
};

pg_dump: error: query failed: ERROR:  permission denied for sequence refresh_tokens_id_seq
pg_dump: error: query was: SELECT last_value, is_called FROM auth.refresh_tokens_id_seq

NOT supabase.from('posts').select('*, author(*), publisher(*)')
LIKE THIS supabase.from('posts').select('*, *')

postgres