Menu

Post image 1
Post image 2
1 / 2
0

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

DEV Community·Jakub·27 days ago
#mMDRgtiY
Reading 0:00
15s threshold

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 data while you're experimenting. The problem? The boundary between these two is almost invisible. When you use the AI chat in Lovable to insert data — say, seed some blog posts, add sample users, or populate a lookup table — that data goes into the test database . Your production app, the one your users actually visit, reads from the live database . You insert ten records. You check the app. Zero records. You start debugging. Where the confusion hits Here's the typical debugging spiral: You ask the AI to insert data.…

Continue reading — create a free account

Join HashtagPLUS to read full articles, follow hashtags, vote, and join the conversation.

Read More