Thanks 😄

I got decoding the JWT working yesterday.

Just to check the uuid in the JWT and compare it against my users table now.

🙂

Where can I setup

User-defined Enumerated Types

?

With a simple SQL query. Example:

CREATE TYPE mood AS ENUM ('sad', 'ok', 'happy');

https://www.postgresql.org/docs/9.1/datatype-enum.html

thanks a lot

Hi, I'm trying to customise the magic link email template currently - is there a documented list of what is available to use within the template? The base template includes

{{ .ConfirmationURL }}

. Is there anything else?

These are somewhat documented here: https://github.com/supabase/gotrue#e-mail You can do a cmd +f for

template

and step through the different ones.

what is the best way to ovveride ui styles like the shadow on :focus?

n00b question: How do I filter on

null

values? I tried with

.eq('date', null)

and

.eq('date', 'null')

'invalid input syntax for type date: "null"'

you'll have to use `.is()`: https://supabase.io/docs/reference/javascript/is

Many thanks!

Problem with tables

Would want to query: lte('dateOut', '2021-01-31') .gte('dateOut', '2021-01-01') OR .is('dateOut', null) Need help on that please

There are a few examples on the page that was linked to, also please create a thread the next time for this.

Sorry, will do. I fail to locate the example where you can do or() with is(). Sql would be WHERE I want to query a date field on a date range but also to include result where the field is empty.

Using .or

Hi all, is it possible to write Supabase functions in Python? Python is listed twice on the website, but it doesn't appear in the supabase console under the extensions page. (Places where Python support is mentioned on the Supabase website: https://supabase.io/docs/guides/database/extensions and https://supabase.io/docs/faq#have-you-built-firebase-feature-yet)

Hey, is there a reason why I no longer can create tables with automatically generated uuids as primary column?

Does anyone know how to order nested data from a supabase select?

const { data, error } = await supabase
      .from('packs')
      .select(
        `
          *,
          categories(*, category_items(*, item:item_id(*)))
        `
      )
      .order('created_at', { ascending: true })
      .order('created_at', { foreignTable: 'categories' })
      .order('position', { foreignTable: 'category_items', ascending: false })
      .eq('user_id', token.sub);

Essentially I am selecting from the packs table, all of the related categories, category_items and items. I'd like for the nested category_items to be ordered by position, however they're all coming in totally out of order for some reason

How to do the query to obtain the animal of a single user . Help me

I've got a chat component similar in design to LinkedIn (thread sidebar, main chat window). I've set it up so when you click on a thread, it passes the thread id to the chat window, which then fetches the messages. The problem is that if you click between threads rapidly, the network requests stack on top of each other and the browser ultimately freezes. This happens, I think, partly because my fetch messages runs in useEffect and there are some unexpected rerenders. I'm trying to think of solutions other than grabbing threads + messages and storing the whole thing in state.

The slack clone uses a dynamic route to grab the channel id, is that a best practice for this style set up?

Can you change your Supabase project password?

I forgot it...

Supabase project password

Supabase GUI seems to be buggy...

Can't edit a column properly

any ideas what I can try?