Is it possible and has anyone tried using the Postgres SQL database offered by Supabase for the Strapi data source? Any tips on setting this up would be greatly appreciated.
I think it should be possible as supabase provide the DB credentials for direct access but there are often some gotchas in these setups.
I am currently using supabase and have no issues. Just use the connection info under project settings > database > connection info. The install was really straightforward. I am also using supabase for media storage (utilizing the plugin that’s available for that). The README for the supabase upload plugin is not correct. You’ll have to add this section to your config/plugins.js and the associated variables to your .env file.
I think my approach would be just to use the supabase auth and users for my customer accounts and only use the strapi accounts for internal use in the CMS.
I do hope that this setup will work and not cause conflicts.
I’d love to hear of anyone who has actually gone this way.
Another open question: do the real-time features work if you manage the content with strapi?
Warning
Strapi applications are not meant to be connected to a pre-existing database, not created by a Strapi application, nor connected to a Strapi v3 database. The Strapi team will not support such attempts. Attempting to connect to an unsupported database may, and most likely will, result in lost data.