It would be great if developers could connect and send SQL queries to their own remote databases like mySQl. MSSQL etc. instead of importing csv files.
I had to write an API to access my remote DB which took a while.
I agree. Wix Code is amazing but I feel this is an essential feature since we can already create HTTP endpoints for our data.
This is currently the primary (only in some cases) reason for not using wix for some projects.
yes im expecting this feature also, please make it happen
UPDATE {}
if you connect a rest api to your sql database you can access json responses to query with wix a remote database. Only wix code for now which is also just javascript.
if you want to connect a remote app like a java interface you can build an api for your wix website inside the wix platform with http-function from wix code too. From there you can start the http function to query and fetch data inside java
So you can access remote databases and query externally your wix collections… I am new to javascript but I didnt rest to find a way out. Yes you need to use the wix code, yes I don’t work for wix, And yes I read the whole wix documentation for wixcode
You can install mysql, mongodb, GoogleCloud or AWS NPM packages, and access you remote DB from your backend code. To do that, click the plus sign (+) next to the “backend” code on the left panel, and choose “Install NPM package”.
You can then import it from your backend code and use it as you want.
If you’re missing a specific NPM for your DB, you can ask Wix to add it from within the NPM install dialog.
Yes this would be the best way
see
Hi - I’m in the process of trying to connect to an external mysql DB. Is using NPM mysql the best way to do this currently? I’ve installed it on the backend but get an error “require” is not defined when I try to use the code from here mysql - npm
Or… Wix support for Zapier, as a standard offering vs. the current Wix answer of developing Wix API code.
Hey, you can connect to an external database - check it out here -
https://www.wix.com/corvid/feature/external-database-collections