# \[Supabase\] Become a Supabase Magician in WeWeb (With Examples of JOINS etc.) **URL:** \ **Category:** Tutorials\ **Tags:** supabase\ **Created:** [July 18, 2024, 12:25pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808 "2024-07-18T12:25:21Z")\ **Posts on this page:** 16\ **Page:** 1
**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:** [July 18, 2024, 12:25pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/1 "2024-07-18T12:25:22Z")
# Become a Supabase Magician in WeWeb (With Examples) In the latest article on my Radar - a blog platform where I post no-code and especially WeWeb content, I explore the integration of Supabase with WeWeb. This comprehensive guide covers advanced usage of Supabase, helping you build scalable WeWeb applications efficiently. > **[Become a Supabase Magician in WeWeb (Tutorial With Examples) – Broberto](https://broberto.sk/radar/weweb/become-a-supabase-magician-in-weweb-with-examples/)** > > Discover advanced techniques for using Supabase with WeWeb. Enhance your apps with these advanced examples and interactive WeWeb examples. ### Why Use Supabase in Your Low-Code Project I discuss Supabase as an open-source alternative to Firebase, detailing its real-time capabilities, PostgreSQL database, and seamless integration with WeWeb. The flexibility and freedom offered by Supabase make it a top choice for low-code projects. ### Fetching Data Effectively Data fetching is crucial for any application. The article explains the different methods provided by WeWeb’s Supabase plugin, emphasizing the importance of understanding your data. ### Using WeWeb Collections The most common pattern for fetching data is through WeWeb’s Collections. This approach is highly effective for most cases, and I recommend a collection-first mindset. ### The Static Pages Issue Supabase collections don’t support Static Collections for Static Pages. I provide a workaround using Supabase’s REST API feature, enabling data fetching from REST endpoints in WeWeb. ### Joining Data in WeWeb Many users are unaware of efficient data fetching. The article explains the Advanced data embedding feature (JOINs) in WeWeb’s Supabase plugin, simplifying data integration. ![An example of Advanced filtering](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/f/f11f67d4692083a3dd204f263bec2b972fb248df.png) ### Efficient Data Filtering with Joined Data The updated plugin allows filtering by nested fields, enabling precise data filtering based on foreign key values. I provide examples of filtering products by brand name and ensuring non-null brands. By following this guide, you can leverage the powerful capabilities of Supabase and WeWeb to create robust, scalable applications with ease. I gotta admit, by diving deep into this, even I learnt a lot of new things. ---
**Author:** ![plucky00](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/plucky00/32/4726_2.png) [@plucky00](https://community.weweb.io/u/plucky00)\ **Post date:** [July 18, 2024, 6:09pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/2 "2024-07-18T18:09:33Z")
Wonderful post! I just swtiched from Xano to Supabase and find it very powerful and waaaay cost effective. 😀 ---
**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:** [July 18, 2024, 6:26pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/3 "2024-07-18T18:26:14Z")
I’m hoping this will help many of you guys, that’s the aim 🙏🏻😄 ---
**Author:** ![mauromequelussi](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/mauromequelussi/32/10223_2.png) [@mauromequelussi](https://community.weweb.io/u/mauromequelussi)\ **Post date:** [July 22, 2024, 4:38am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/4 "2024-07-22T04:38:33Z")
very good Congratulations ---
**Author:** ![WeeeeeWeb](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/weeeeeweb/32/9689_2.png) [@WeeeeeWeb](https://community.weweb.io/u/WeeeeeWeb)\ **Post date:** [July 22, 2024, 8:36am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/5 "2024-07-22T08:36:31Z")
Interesting to hear that. I am using XANO and always curious about supabase due to the pricing factor, How does the function stack add up in this case? I found the ability to do almost all functions in XANO, a very powerful tool. I did not test that with supabase, so curious on how you are finding the transition? Thanks. ---
**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:** [July 22, 2024, 8:58am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/6 "2024-07-22T08:58:17Z")
> [@WeeeeeWeb](#): > > I found the ability to do almost all functions in XANO, a very powerful tool. In Supabase you’re not limited by the no-code UI, you have a direct, raw access to the Postgres DB (to a certain extent) so you can literally do any functionality you need. ---
**Author:** ![sam1](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/sam1/32/6724_2.png) [@sam1](https://community.weweb.io/u/sam1)\ **Post date:** [October 4, 2024, 4:44am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/7 "2024-10-04T04:44:04Z")
When I attempt to filter a collection from a spread section of data I get an effectively saying the Colom doesn’t exist on the top table. ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/8/868d69a8d3f48da9383b1d88e7da7ef4119acad3.png) ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/0/0d0bbf2b50ce9c0b1797c16666bf01cb6bd198e6.png) your reply here seemed to suggest I can, > [@How to handle Supabase collection fetches w/ foreign key filters?](https://community.weweb.io/t/how-to-handle-supabase-collection-fetches-w-foreign-key-filters/9154/18): > > It’s only in the Workflow Actions. You could work around this by first … spreading the data and then filtering on top level Could you clarify if I am missing something or if this is only possible in the workflow select. ---
**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:** [October 4, 2024, 6:22am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/8 "2024-10-04T06:22:50Z")
If you go and use a workflow instead of a Collection, you should be able to set a filter on a `news.active` column and it could work like this, as that is the “true reference” to that column. ---
**Author:** ![enzocarmo](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/enzocarmo/32/7681_2.png) [@enzocarmo](https://community.weweb.io/u/enzocarmo)\ **Post date:** [October 5, 2024, 11:55pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/9 "2024-10-05T23:55:29Z")
Does this mean that all collections that have a join I want to create a filter, will I have to put in a page workflow to load data and feed a variable that will be used, for example a data grid that shows my registered products? ---
**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:** [October 6, 2024, 7:03am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/10 "2024-10-06T07:03:57Z")
Yes, you’re right indeed, you need to switch to the Workflow Actions, because the Collections currently in WeWeb unfortunately don’t allow custom keys. ---
**Author:** ![Paul27](https://avatars.discourse-cdn.com/v4/letter/p/ac91a4/32.png) [@Paul27](https://community.weweb.io/u/Paul27)\ **Post date:** [November 16, 2024, 9:33am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/11 "2024-11-16T09:33:02Z")
Hey @Broberto, awesome work you do! I was looking at the WeWeb Academy’s Supabase training and lander here. I wanted to confirm that the JOIN queries are actual JOINs? They are not subsequent queries, using results/parameters from the previous query, performed on the front-end level? ---
**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:** [November 16, 2024, 9:45am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/12 "2024-11-16T09:45:00Z")
Hello, you can rest assured, JOINs as you see them in my guide are genuine JOINs. It’s thanks to how the WeWeb plugin utilizes the Supabase SDK under the hood. So to answer your question, yes. And thanks for the kind words 🙂 ---
**Author:** ![alamoglie](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/alamoglie/32/10706_2.png) [@alamoglie](https://community.weweb.io/u/alamoglie)\ **Post date:** [May 25, 2025, 2:50am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/13 "2025-05-25T02:50:48Z")
Broberto, we need your YT channel to grow, and we also need you to create a WeWeb academy. I would be willing to pay for a subscription to it. ---
**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 25, 2025, 12:06pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/14 "2025-05-25T12:06:33Z")
Thanks for the kind words! Sadly WeWeb Market is not very big for these things, so it’s not really possible for me to do such a thing without losing money on it (opportunity cost). But I think WeWeb has hired plenty of people now who are gonna level up the Academy a lot 🙂 ---
**Author:** ![alamoglie](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/alamoglie/32/10706_2.png) [@alamoglie](https://community.weweb.io/u/alamoglie)\ **Post date:** [May 25, 2025, 3:05pm UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/15 "2025-05-25T15:05:50Z")
I completely understand the point about opportunity cost. But what you’ve already created is truly excellent. The quality of those manuals and the effort you invested in them provide a fantastic starting point. I believe that WeWeb’s lack of a larger audience is partly due to the absence of dedicated Academies and comprehensive tutorials. Many people on the fence between using WeWeb or Bubble will likely opt for Bubble. I’ve tried Bubble myself, and frankly, the tool isn’t as good—not on WeWeb’s level. If you look at Webflow’s success, even with so many competitors, I believe a significant part of it is owed to the Webflow Academy—specifically, to how entertaining, concise, user-friendly, and professional their videos are. WeWeb should really invest in this; I’m convinced its user base would grow exponentially. ---
**Author:** ![Matthew\_S](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/matthew_s/32/13342_2.png) [@Matthew\_S](https://community.weweb.io/u/Matthew_S)\ **Post date:** [May 26, 2025, 9:42am UTC](https://community.weweb.io/t/supabase-become-a-supabase-magician-in-weweb-with-examples-of-joins-etc/9808/16 "2025-05-26T09:42:53Z")
A new academy is 100% needed, it’s on our educational roadmap. Updating the user documentation is the first big milestone, then the academy will shortly follow. The goal is to include a lot more in the academy than just guides (like quizzes, games, etc), so it will take some time to build. We’re aiming is to start the academy revamp in the coming months. Any suggestions for specific pieces of content you would like to see in the new academy are warmly welcomed 🙂