Database / Supabase basics Interview Questions
Why do we use database migrations in Supabase projects?
Migrations are versioned, ordered SQL files that describe every schema change — new tables, altered columns, new RLS policies — so the database structure can be recreated deterministically instead of relying on manual dashboard edits that nobody tracked.
With the Supabase CLI, running supabase migration new add_orders_table creates a timestamped file that gets applied with supabase db push, and the same file can be committed to git, reviewed in a pull request, and applied identically to a teammate's local database, a staging project, and production. This also enables environment branching, where each git branch can spin up its own isolated Supabase project seeded from the same migration history, catching schema issues before they reach a shared environment.
Invest now in Acorns!!! 🚀
Join Acorns and get your $5 bonus!
Acorns is a micro-investing app that automatically invests your "spare change" from daily purchases into diversified, expert-built portfolios of ETFs. It is designed for beginners, allowing you to start investing with as little as $5. The service automates saving and investing. Disclosure: I may receive a referral bonus.
Invest now!!! Get Free equity stock (US, UK only)!
Use Robinhood app to invest in stocks. It is safe and secure. Use the Referral link to claim your free stock when you sign up!.
The Robinhood app makes it easy to trade stocks, crypto and more.
Webull! Receive free stock by signing up using the link: Webull signup.
More Related questions...
