Connecting external database to my WIX Website

I’m quite new to WIX but up until now I have managed to do most of what I have planned to do.
However I’m currently quite stuck with a major problem I’m having which is connecting an external database to my WIX website.

At the moment I haven’t set-up my database because I want to choose the database which I can integrate the best with WIX, I’m thinking om MySQL.

Therefore I would like to use the " External Database Collection " feature of WIX, however I have no idea how to set this up.

I have read that I will need to set up an API to be able do to this but this is completely new for me… I have searched quite a long time already on the internet but I haven’t found a explanation which could help me…

Is there anyone who can point me in the right direction on how to start with this?

Thank you!

Hi,
you can add an external database collection as instructed here .

Click here to learn more about working with external database collections.

Hi

First of all thank you for the fast feedback. The 2 links you added are links I did already read and are unforntunaly not new for me.

The question is more that I don’t understand how to build my custom API for the SPI. Could anyone point me in the right direction and help me?

Wix won’t be able to help you build your own API for your external database collection as it won’t be a Wix product.

Depending on where your external database is stored, if you are using another company for example, then they should in theory have their own API, look for REST API, which you will be able to use with your database to pass data to and from that API to Wix API.

If you are using another company, then they should be able to provide you help through their own support with the ‘Important Information for Creating Your Adapter’ section of that tutorial page.

You can look online for many ways of making your own API etc.
https://rapidapi.com/blog/20-tutorials-on-how-to-create-your-own-api-sorted-by-programming-language/
https://swagger.io/blog/api-development/how-to-build-an-api/

If you are really struggling, then have a look at finding somebody from the Wix Arena who can help you with this task. https://www.wix.com/arena/web-designers/1