views folder
as views are idempotent. is there a method to have views in a separate folder rather than to have them define in migrations? would also make tracking changes using git easier.
3 Replies
@SB yes, you can keep views in a separate folder like sql/views. they are idempotent, so rerunning is safe.
It also makes Git tracking easier.
No, the views have to be in a migration file when using Supabase migrations via the CLI.
how do you then deploy them? i'm running git actions so would be ideal to add something there