Node.js as webserver with MySQL

Question

Node.js as webserver with MySQL

I am looking to create a webserver, with the lightest possible setup. Is it possible to run a webserver with node.js, MySQL on a 512MB RAM server.

mysql
linux
node.js

Answer 1

you can hit

$ npm install mysql

and then include

var _mysql = require('mysql');

var HOST = 'localhost';
var PORT = 3306;
var MYSQL_USER = 'nodehacker';
var MYSQL_PASS = 'lulwut';
var DATABASE = 'nodedb';
var TABLE = 'gadgets';

var mysql = _mysql.createClient({
    host: HOST,
    port: PORT,
    user: MYSQL_USER,
    password: MYSQL_PASS,
});

mysql.query('use ' + DATABASE);