Supabase dual-DB gotcha — test vs live, and how I stopped shipping broken data

I spent two hours debugging an empty production list. The data was in the test database the whole time. If you're building with Lovable and Supabase, there's a gotcha that will bite you eventually — and when it does, you'll wonder why nobody warned you. Consider this your warning. The setup nobody explains When you spin up a Supabase project through Lovable, you get two database environments: test and live . This makes sense in theory — you don't want your AI-assisted edits touching production d