I have a javascript application running with server like nginx or eclipse local server, and i would like to know if it is possible to connect it with mysql server database.
I know that they are a lot of npm packages for nodejs application, but i don't want to use node js because if i'll do that i have to implement all structure of nodejs application with all dependencies and i don't know very well this technology to do that.
Thanks.
I have a javascript application running with server like nginx or eclipse local server, and i would like to know if it is possible to connect it with mysql server database.
I know that they are a lot of npm packages for nodejs application, but i don't want to use node js because if i'll do that i have to implement all structure of nodejs application with all dependencies and i don't know very well this technology to do that.
Thanks.
Share Improve this question edited Dec 29, 2015 at 17:07 CodeWizard 143k22 gold badges160 silver badges180 bronze badges asked Dec 29, 2015 at 17:06 shmoolkishmoolki 1,5619 gold badges35 silver badges58 bronze badges1 Answer
Reset to default 5There is no way to connect to a remote database server directly from JavaScript running in a browser… and if there was it would probably involve a huge security hole since anyone with access to the client could take your credentials and run any SQL they like on the server. It is unlikely you could make your database GRANTS fine-grained enough for public consumption.
If you want your client side JS to interact with your database server then you need to write a webservice for it. You can do that in Node.JS or any other server side environment you like.
If you are using Node.JS then you will probably want Nginx to proxy the requests.
Nginx supports FastCGI so you could write in any language that supports FastCGI such as Perl or PHP.