Supabase CMS integration with Silex

booksthatburn

Starting a new thread for walking through Supabase integration with Silex

booksthatburn

What I've done so far, using the Wordpress integration guide as a starting point:
A. Created Supabase account and linked to GitHub project

B. Create a new project

Choose “New Project” on the Dashboard
If an organization already exists, choose that organization or create a new one along with the project. (no organization existed so I created a new one)
Fill in the Organization, Project Name, Database Password, and server/project region.
Security Options and Advanced Configuration Options are available for advanced users, but are not necessary to configure.
When all settings are chosen, “Create new project”
Options to configure the project are now available.

booksthatburn

C. Connected GitHub repository to Supabase
For this I just followed the prompts from GitHub and it was pretty self-explanatory, I forgot to document the individual steps.

booksthatburn

Here's where I got stuck. I tried to get the Endpoint information to connect to Silex

In Supabase, open Project Settings → Configuration → API
Copy URL for database source (defaults to Primary Database)
(then it seemed like the next steps would line up with steps 18-40 of the Wordpress documentation)
Return to Silex, open a new project (or add into to an existing one)
Open Settings
Click “CMS”
Add new data source
6a. Add label
6b. Paste URL from Supabase into the “URL” field in Silex
6c. Click “Test connection”

This is where it failed, I got the error:
"Status: ✗ Unknown GraphQL connection failed: GraphQL introspection failed: Failed to fetch"
I've tried to troubleshoot it in Supabase but I don't know what I'm missing.

lexoyo

booksthatburn could you please paste the api url so that I can make sure it is a graphql api

Also mabe you need to add headers for auth?

booksthatburn

https://zazmavnytnsahvjzrgrv.supabase.co

I have a database of language codes, in the public schema, with read access enabled for all public users.

lexoyo

booksthatburn Oh but that's not the URL of the API
I did a quick search and it may be https://<your-project>.supabase.co/graphql/v1

booksthatburn

That's the only thing I can find under API, if that's not it then I don't know where to look.

lexoyo

did you try https://<your-project>.supabase.co/graphql/v1 ?

lexoyo

Hello @booksthatburn
Did you manage to get it working ?

lexoyo

I just published a new guide in English to connect Supabase with your Silex site –from project setup to publication of a live site, 100% free and open source.

📖 Read it here: https://docs.silex.me/en/guides/supabase