1

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.

nxh
  • 1,073
  • 1
  • 11
  • 22
  • PhpMyAdmin is a seperate php based admin tool for MySql and can be set up independently of MySQL ... so not sure about your question – avrono Oct 30 '13 at 00:51
  • I would like to have an administration tool for MySQL. As I am understand, phpMyAdmin is the most popular one and it requires Apache, PHP to run http://docs.phpmyadmin.net/en/latest/require.html. – nxh Oct 30 '13 at 01:04
  • 1
    Yes that is true ... you can always use the command line tools – avrono Oct 30 '13 at 01:06
  • 1
    http://stackoverflow.com/questions/5818312/mysql-with-node-js – Sathish D Oct 30 '13 at 06:58
  • 1
    @NamHoang https://github.com/simov/express-admin is a web UI for end users, which means you can only add/modify/remove records. It's not designed for managing databases - like create/drop tables and so on. – simo Apr 11 '14 at 14:26

1 Answers1

2

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.

Community
  • 1
  • 1
ashack
  • 1,192
  • 11
  • 17
  • Thanks for your recommendation. I am using Workbench, but mostly for designing DB schema. Regarding administration, I find that the command line tool is not bad. – nxh Jan 18 '14 at 20:26