Search code examples
mysqldatabaseweb-servicesnode.jslamp

How to setup MySQL in combination with Node.js

I am making a Restful API using Node.js.

My project requires using MySQL Database (since there is an existing MySQL DB which needs to be re-designed). Therefore, what is the best way to setting up the new MySQL? Using bundle like LAMP or standalone MySQL?

  • LAMP will provide me the traditional administration tool phpMyAdmin (export, import, visualization...).
  • Installing MySQL alone seems more tidy but there is no "mature" administration tool yet. I can only find this one https://github.com/simov/express-admin.

Can you please tell me the pros and cons of each way? Thank you in advance.

Solution

  • I also recommend mySQL with Node.js for getting started. Your best bet for administration tools would be to use a standalone client to tunnel into your database, like MySQL Workbench.