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.
Currently possible only if you use rest api to call Supabase and save it as a static collection.
Got it. Thanks!
It’s fairly simple. I might be able to send a guide in a few hours.
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.
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?
I will record a video for you tonight when I come from work. How many records are you expecting to have?
A lot, it could be up to 4000, but in the front page I’m planning to show 16 + load more.
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.
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.
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.
Hi @david 
Here’s a video on how you can fetch data from Supabase using the REST API plugin.
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!
@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.
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 about in addition to it , using a cms integration’ in Supabase Integration partner ? Could be even more painless in build pages content in Supabase
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.
