# Static Pages + Supabase

**URL:** <https://community.weweb.io/t/static-pages-supabase/4442>\
**Category:** How do I?\
**Tags:** supabase\
**Created:** [September 19, 2023, 2:50pm UTC](https://community.weweb.io/t/static-pages-supabase/4442 "2023-09-19T14:50:11Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 19, 2023, 2:50pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/1 "2023-09-19T14:50:11Z")

</div>

Hello,

I love the product, but I’m encountering some issues with data loading. I’m trying to build a tool aggregator, and for SEO purposes, I need to create a static CMS collection. Why can’t I select ‘static’ when creating a new collection? I’ve set up a table in Supabase that isn’t real-time and I’d like to extract data from it.

 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/8/8096528eb25f973c74225675a4be5781beae54dd.png)  
 ![image](https://us1.discourse-cdn.com/flex016/uploads/weweb/original/2X/a/a9ade59ba9ea3b47af9b8863953aea90c7febbea.png)

---

<div class="post-metadata">

**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:** [September 19, 2023, 3:05pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/2 "2023-09-19T15:05:41Z")

</div>

Currently possible only if you use rest api to call Supabase and save it as a static collection.

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 19, 2023, 3:06pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/3 "2023-09-19T15:06:53Z")

</div>

Got it. Thanks!

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 19, 2023, 3:12pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/4 "2023-09-19T15:12:02Z")

</div>

@Broberto Do you have any tips or tutorial on how to do that?

---

<div class="post-metadata">

**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:** [September 19, 2023, 3:19pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/5 "2023-09-19T15:19:34Z")

</div>

It’s fairly simple. I might be able to send a guide in a few hours.

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 19, 2023, 3:22pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/6 "2023-09-19T15:22:30Z")

</div>

@Broberto Thanks would appreciate it a lot.

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 20, 2023, 7:35am UTC](https://community.weweb.io/t/static-pages-supabase/4442/7 "2023-09-20T07:35:32Z")

</div>

@Broberto

Did you had a time to send that guide? Loom video or etc, could help a lot.

---

<div class="post-metadata">

**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:** [September 20, 2023, 7:38am UTC](https://community.weweb.io/t/static-pages-supabase/4442/8 "2023-09-20T07:38:21Z")

</div>

Hey! I’ve wanted to do it yesterday, but I found some issues/bug and I asked WeWeb Team about it, I might have an answer today. I haven’t forgotten about you) It’s hopefully coming, once I get an answer from them. Do you have RLS on that table? If not then we could do it even without the answer from them.

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 20, 2023, 7:50am UTC](https://community.weweb.io/t/static-pages-supabase/4442/9 "2023-09-20T07:50:45Z")

</div>

I don’t have RLS. I don’t have a lot of experience with RLS and these type of databases (I come from Bubble and Webflow).

I’m building an tool aggregator. Would RLS is needed in this case, as people could look at tool information without any permissions?

---

<div class="post-metadata">

**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:** [September 20, 2023, 7:51am UTC](https://community.weweb.io/t/static-pages-supabase/4442/10 "2023-09-20T07:51:59Z")

</div>

I will record a video for you tonight when I come from work. How many records are you expecting to have?

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 20, 2023, 7:58am UTC](https://community.weweb.io/t/static-pages-supabase/4442/11 "2023-09-20T07:58:03Z")

</div>

A lot, it could be up to 4000, but in the front page I’m planning to show 16 + load more.

---

<div class="post-metadata">

**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:** [September 20, 2023, 8:03am UTC](https://community.weweb.io/t/static-pages-supabase/4442/12 "2023-09-20T08:03:43Z")

</div>

As of now, you can do up to 3000 prerendered records within a static collection on WeWeb. There is coming some update that will make SEO more powerful very soon though.

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 20, 2023, 8:20am UTC](https://community.weweb.io/t/static-pages-supabase/4442/13 "2023-09-20T08:20:02Z")

</div>

Hmm okay, this isn’t the best. I decided to go with WeWeb, because webflow has a limit of 10000, so it wouldn’t be a problem in the future…

Anyways, I’m still interested on how to do it.

---

<div class="post-metadata">

**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:** [September 20, 2023, 8:56am UTC](https://community.weweb.io/t/static-pages-supabase/4442/14 "2023-09-20T08:56:35Z")

</div>

It’s gonna be a lot more soon, but for now, it’s a little limited. Comparing webflow to weweb is not the best, but yeah, in terms of amount for now webflow seems to be a better solution.

---

<div class="post-metadata">

**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:** [September 25, 2023, 4:53pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/15 "2023-09-25T16:53:20Z")

</div>

Hi @david 👋

Here’s a video on how you can [fetch data from Supabase using the REST API plugin](https://tella.video/david-supabase-via-rest-api-3zh8).

Note that I tested my request in Postman on a table without RLS before moving into WeWeb because I wanted to make sure I found and understood the API request I was making without needing to worry about security policies and the WeWeb interface.

It’s something I generally find helpful because it helps me isolate where I’m going wrong.

Let me know if this helps!

---

<div class="post-metadata">

**Author:** ![david](https://avatars.discourse-cdn.com/v4/letter/d/aeb1de/32.png) [@david](https://community.weweb.io/u/david)\
**Post date:** [September 25, 2023, 5:09pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/16 "2023-09-25T17:09:31Z")

</div>

@Joyce Thanks! Got information from your team, that Static pages have limit of 500, but you’ll have really soon SEO settings for dynamic pages. I’ve decided to continue with dynamic pages.

---

<div class="post-metadata">

**Author:** ![Marc.A](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@Marc.A](https://community.weweb.io/u/Marc.A)\
**Post date:** [October 12, 2023, 1:52pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/17 "2023-10-12T13:52:11Z")

</div>

Is there a rough timeline when to expect this? I would like to use supabase and crank out a lot of content, potentially thousands of pages that would need to be seo friendly.

---

<div class="post-metadata">

**Author:** ![Zacharyb](https://sea2.discourse-cdn.com/flex016/user_avatar/community.weweb.io/zacharyb/32/3567_2.png) [@Zacharyb](https://community.weweb.io/u/Zacharyb)\
**Post date:** [October 13, 2023, 2:10am UTC](https://community.weweb.io/t/static-pages-supabase/4442/18 "2023-10-13T02:10:33Z")

</div>

What about in addition to it , using a cms integration’ in Supabase Integration partner ? Could be even more painless in build pages content in Supabase

---

<div class="post-metadata">

**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 13, 2023, 4:35pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/19 "2023-10-13T16:35:04Z")

</div>

> [@Marc.A](#):
>
> Is there a rough timeline when to expect this? I would like to use supabase and crank out a lot of content, potentially thousands of pages that would need to be seo friendly.

What do you mean? There is no plan to add the option to make Supabase collections static.

However, we are working on a new SEO feature which will improve the SEO of dynamic collection pages. This feature is currently being beta tested. We hope (but can’t guarantee) it will be ready for production in Q4 this year or Q1 2024.

---

<div class="post-metadata">

**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 13, 2023, 4:35pm UTC](https://community.weweb.io/t/static-pages-supabase/4442/20 "2023-10-13T16:35:55Z")

</div>

> [@Zacharyb](#):
>
> What about in addition to it , using a cms integration’ in Supabase Integration partner ? Could be even more painless in build pages content in Supabase

Hi @Zacharyb 👋

I don’t understand your suggestion. Could you reformulate?

[Next page](https://community.weweb.io/t/static-pages-supabase/4442.md?page=2)
