yifanzz · March 27, 2025 20:59 · Mar 27, 2025
diff --git a/rules.md b/rules.md
@@ -0,0 +1,10 @@
+# Database
+
+- Use supabase for database queries and schema
+- Before performing any database related tasks, make sure to read the database.types.ts first for existing database schema
+- Always use migrations to update the database schema, create them using the command `npx supabase migration new <migration-name>`
+- Afer creating a migration file, run `npx supabase migration up` to apply the migration and run `npx supabase gen types typescript --local > src/types/database.types.ts` to generate the type file
+- When creating a new table, it must have columns for `created_at` and `updated_at` and the values should be set automatically via triggers using `public.handle_created_at()` and `public.handle_updated_at()`
+- Always enable Row Level Security (RLS) on newly create tables via `ALTER TABLE <table_name> ENABLE ROW LEVEL SECURITY;` in migration files and add reasonable policies
+- Always use `await createServerClient()` in the `@/utils/supabase/server` to create supabase client in server components and `createBrowserClient()` in the `@/utils/supabase/client` to create supabase client in client components
+- Always maintain backwards compatibility when generating migrations
diff --git a/useful-supabase-commands.sh b/useful-supabase-commands.sh
@@ -0,0 +1,14 @@
+supabase start
+
+supabase migration create <migration_name>
+
+supabase migration up
+
+supabase db diff -f <migration_name>
+
+supabase db reset
+
+supabase db dump --data-only --local -f seed.sql
+
+supabase db push
+