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.

Improve this question
5
  • PhpMyAdmin is a seperate php based admin tool for MySql and can be set up independently of MySQL ... so not sure about your question Commented Oct 30, 2013 at 0: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 docs.phpmyadmin.net/en/latest/require.html. Commented Oct 30, 2013 at 1:04
  • 1
    Yes that is true ... you can always use the command line tools Commented Oct 30, 2013 at 1:06
  • 1
    stackoverflow.com/questions/5818312/mysql-with-node-js Commented Oct 30, 2013 at 6:58
  • 1
    @NamHoang 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. Commented Apr 11, 2014 at 14:26

1 Answer 1

Reset to default
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.

Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.