# Supabase Test vs Live Database (if possible) **URL:** \ **Category:** How do I?\ **Tags:** supabase\ **Created:** [October 5, 2023, 8:56pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758 "2023-10-05T20:56:04Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![avery](https://avatars.discourse-cdn.com/v4/letter/a/ed655f/32.png) [@avery](https://community.weweb.io/u/avery)\ **Post date:** [October 5, 2023, 8:56pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/1 "2023-10-05T20:56:04Z")
Xano has a lovely feature that allow you to switch between your test DB and Live DB and weweb allow you to control what you can show in the editor vs prod. Has anyone been able to mimic this with Supabase? ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [October 9, 2023, 9:34am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/2 "2023-10-09T09:34:55Z")
Hi @avery 👋 I believe our CPO @flo has played around with Supabase’s [local development](https://supabase.com/docs/guides/cli/local-development) feature. Let me check with him how that works and get back to you on that one. ---
**Author:** ![avery](https://avatars.discourse-cdn.com/v4/letter/a/ed655f/32.png) [@avery](https://community.weweb.io/u/avery)\ **Post date:** [October 10, 2023, 3:06pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/3 "2023-10-10T15:06:28Z")
Yes please keep me updated! ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [October 16, 2023, 3:07pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/4 "2023-10-16T15:07:31Z")
Hi @avery 👋 FYI, we haven’t forgotten about you. It’s just taking a bit of time because the answer is long and we want to explain it well 🙂 ---
**Author:** ![avery](https://avatars.discourse-cdn.com/v4/letter/a/ed655f/32.png) [@avery](https://community.weweb.io/u/avery)\ **Post date:** [October 20, 2023, 10:26pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/5 "2023-10-20T22:26:07Z")
Hey @Joyce, just curious if there are any updates on this 😃 ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [October 23, 2023, 2:21pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/6 "2023-10-23T14:21:17Z")
yes! Here’s [a video @flo recorded on the topic](https://www.loom.com/share/268713829b8c4f98be138cddc48010bb). I still need some time to go through it and record a “tighter” version but hopefully it can get you started 🙂 ---
**Author:** ![avery](https://avatars.discourse-cdn.com/v4/letter/a/ed655f/32.png) [@avery](https://community.weweb.io/u/avery)\ **Post date:** [October 25, 2023, 6:10pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/7 "2023-10-25T18:10:22Z")
Awesome that is super helpful, thank you so much. Do you know if there are any plans in the future to add more to the supabase plugin? It seems that it will get tedious to keep switching between the locals keys and the live keys before publishing. Also in case someone else stumbles on this post, our workaround to get multiple people working off the same project (cause local dev won’t work for multiple people). We created 2 supabase projects (one dev, one production) so that multiple people can connect to the “dev” project (connect locally, do push request, etc) while that dev project is connected to weweb. You will still have to switch keys before publishing and make sure to clone any changes to your “dev” supabase to your “production” supabase. ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [October 26, 2023, 10:20am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/8 "2023-10-26T10:20:24Z")
> [@avery](#): > > Do you know if there are any plans in the future to add more to the supabase plugin? Yes! The team is working on updating the Supabase plugins [with the v2](https://supabase.com/blog/supabase-js-v2) and will look to add new features at the same time. Not sure yet what will be included in that update though because it’s still in the exploration phase. > [@avery](#): > > Also in case someone else stumbles on this post, our workaround to get multiple people working off the same project (cause local dev won’t work for multiple people). We created 2 supabase projects (one dev, one production) so that multiple people can connect to the “dev” project (connect locally, do push request, etc) while that dev project is connected to weweb. You will still have to switch keys before publishing and make sure to clone any changes to your “dev” supabase to your “production” supabase. Nice! Thanks for taking the time to share this tip 😀 ---
**Author:** ![julian](https://avatars.discourse-cdn.com/v4/letter/j/74df32/32.png) [@julian](https://community.weweb.io/u/julian)\ **Post date:** [March 13, 2024, 10:36am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/9 "2024-03-13T10:36:27Z")
Hey Joyce, is there any update on this? Does the updated Supabase plugin allow to use different databases in development and production? If not, what is best practice here? edit: just figured out, that this thread is pretty much about the same topic: [[Editor] Staging and Production credentials handling - #6 by Alexis](https://community.weweb.io/t/editor-staging-and-production-credentials-handling/7317/6) ---
**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\ **Post date:** [March 13, 2024, 11:01am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/10 "2024-03-13T11:01:35Z")
Yeah, actually I’m kinda disappointed that things like Sound Plugin got released instead of a proper fix for this, Xano has had this for ages, you even facilitated it by implementing it on your side. I don’t want to be the hater, but I guess more people care about being able to have a proper dev experience with Supabase (also as an amount of demographic of users) than to have a Sound Plugin 🙂 ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [March 13, 2024, 10:35pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/11 "2024-03-13T22:35:03Z")
Hey Broberto, yeah I completely understand your frustration. As Alexis mentioned in the other topic, it’s definitely something we’d like to prioritize but we still need to figure out how and when it will be possible. As you know one feature in doesn’t necessarily mean one feature out, it’s more complex than. The sound plugin was completely decorrelated from the Supabase improvement for example. It’s often like that which is why sometimes less urgent things are released earlier. ---
**Author:** ![Joyce](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/joyce/32/13232_2.png) [@Joyce](https://community.weweb.io/u/Joyce)\ **Post date:** [March 13, 2024, 10:38pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/12 "2024-03-13T22:38:05Z")
Hey Julian, as mentioned in the other topic, I don’t have an update on this and haven’t come across an ideal workaround. Hopefully we can push a nice update soon 🙂 It’s currently in the exploration phase. ---
**Author:** ![avery](https://avatars.discourse-cdn.com/v4/letter/a/ed655f/32.png) [@avery](https://community.weweb.io/u/avery)\ **Post date:** [March 14, 2024, 2:19am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/13 "2024-03-14T02:19:15Z")
I would also say to that Xano was made for the no-code space vs Supabase was made to make developers lives easier when creating databases. It would be nice if in the Supabase plugin had an extra fields to input your production keys and url so when you deployed it would use those keys (hint hint 😉) but it would also open a whole can of problems for no-coders if they didn’t keep their development and production databases in sync (plus not everyone is willing to purchase 2 supabase databases for one weweb project). Right now we just have to deal with what Supabase gives us because doesn’t have no-code/low-code way of keeping 2 databases in sync safely like Xano does. ---
**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\ **Post date:** [March 14, 2024, 8:42am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/14 "2024-03-14T08:42:54Z")
> [@avery](#): > > (plus not everyone is willing to purchase 2 supabase databases for one weweb project). You can host Supabase locally and input those credentials. Also @Joyce thanks for answering. I still feel like Supabase is getting gatekept by you guys over Xano, sounded to me like that’s the reason why Realtime update also is not released yet, so honestly I don’t expect this change to be happening anytime soon either. ---
**Author:** ![D-EFFCON](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@D-EFFCON](https://community.weweb.io/u/D-EFFCON)\ **Post date:** [March 18, 2024, 4:25am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/15 "2024-03-18T04:25:36Z")
Wouldn’t you just use Supabase branching? ---
**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\ **Post date:** [March 19, 2024, 11:11am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/16 "2024-03-19T11:11:33Z")
Branching is in Alpha if something hasn’t changed meanwhile, I’d say I wouldn’t trust it 😅 (yet). The point is, WeWeb needs to implement a possibility to differ between staging and production keys, that’s a standard thing. ---
**Author:** ![cdev](https://avatars.discourse-cdn.com/v4/letter/c/8797f3/32.png) [@cdev](https://community.weweb.io/u/cdev)\ **Post date:** [May 21, 2024, 9:51am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/17 "2024-05-21T09:51:00Z")
Has there been any update on this? I haven’t seen any info in past two months. ---
**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\ **Post date:** [May 21, 2024, 10:07am UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/18 "2024-05-21T10:07:31Z")
> [@Broberto](#): > > Also @Joyce thanks for answering. I still feel like Supabase is getting gatekept by you guys over Xano, sounded to me like that’s the reason why Realtime update also is not released yet, so honestly I don’t expect this change to be happening anytime soon either. As I said 😃 ---
**Author:** ![cdev](https://avatars.discourse-cdn.com/v4/letter/c/8797f3/32.png) [@cdev](https://community.weweb.io/u/cdev)\ **Post date:** [May 23, 2024, 8:23pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/19 "2024-05-23T20:23:25Z")
If I use this method to change Supabase projects, do I only need to change the URL and key for Supabase and Supabase Auth plugins? Or do I need to go through every collection and set them up again? The two Supabase projects would have identical databases. In the video, he went to the todos collection and confirmed it again. ---
**Author:** ![Broberto](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/broberto/32/5918_2.png) [@Broberto](https://community.weweb.io/u/Broberto)\ **Post date:** [June 5, 2024, 8:07pm UTC](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758/20 "2024-06-05T20:07:19Z")
Hello, anyone looking for an answer to this might be interested in this post > [@\[Supabase\] Switch between Production and Staging in one click](https://community.weweb.io/t/supabase-switch-between-production-and-staging-in-one-click/8972): > > Preface Since I kind of opened this discussion a few days ago, in this thread [[Chrome Extension] Supabase Live and Staging](https://community.weweb.io/t/chrome-extension-supabase-live-and-staging/8849) I actually found a really neat way of doing this, at least while WeWeb rolls out their own solution. This solution also doesn’t account for the part where WeWeb uses the Private - Secret keys to fetch things like fetching the users etc. What does this work on? Fetching the tables within your collections creating process a.k.a it can introspect your DB’s schema Changing th… [Next page](https://community.weweb.io/t/supabase-test-vs-live-database-if-possible/4758.md?page=2)