node.js - express app correct way to connect to mongo db? -


i have following directory layout contains node.js / express application:

server.coffee server.js src ├── config │   └── index.coffee ├── controllers │   ├── index.coffee │   └── user.coffee ├── index.coffee ├── models │   └── user │       └── user.coffee ├── routes.coffee └── utils     ├── dbconnect.coffee views ├── 404.blade ├── 500.blade ├── index.blade └── user     ├── create.blade

the /src/config/index.coffee has details of mongo url export db_url

#### config file # sets application config parameters depending on `env` name  logger = require "../utils/logger" logcategory = "server config"  db_host = "localhost" db_port = "27017" db_name = "zmgc" db_url = null db_user = null db_pass = null   # connecting dexies database on mongodb boundservices = if process.env.vcap_services json.parse(process.env.vcap_services) else null unless boundservices     if db_user , db_pass         db_url = "mongodb://#{db_user}:#{db_pass}@#{db_host}:#{db_port}/#{db_name}"     else         db_url = "mongodb://#{db_host}:#{db_port}/#{db_name}" else     service_type = "mongodb-1.8"     credentials = boundservices["mongodb-1.8"][0]["credentials"]     db_url = "mongodb://" + credentials["username"] + ":" + credentials["password"] + "@" + credentials["hostname"] + ":" + credentials["port"] + "/" + credentials["db"]  #set current environment true in env object exports.setenvironment = (env) ->   logger.info "set app environment: #{env}", logcategory    switch(env)     when "development"       exports.debug_log = true       exports.debug_warn = true       exports.debug_error = true       exports.debug_client = true       exports.db_url = db_url      when "testing"       exports.debug_log = true       exports.debug_warn = true       exports.debug_error = true       exports.debug_client = true       exports.db_url = db_url      when "staging"       exports.debug_log = true       exports.debug_warn = true       exports.debug_error = true       exports.debug_client = true       exports.db_url = db_url      when "production"       exports.debug_log = false       exports.debug_warn = false       exports.debug_error = true       exports.debug_client = false       exports.db_url = db_url     else       logger.info "environment #{env} not found", logcategory

and in /src/utils/dbconnect.coffee, have following:

# connecting database on mongodb config = require "../config/index" logger = require("./logger") mongoose = require("mongoose") mongoose.set "debug", true  logcategory = "database connection"  db_connect_mongo = init: (callback) ->   self =   mongo_options = db:       safe: true   db_url = config.db_url   mongoose.connect db_url, mongo_options   db = self.db_mongo = mongoose.connection    db.on "error", (error) ->     logger.error "error connecting to: " + db_url, logcategory     callback error, null    db.on "connected", ->     logger.info "successfully connected to: " + db_url, logcategory     callback true, db    db.on "disconnected", ->     logger.info "disconnected database: " + db_url, logcategory  # check , connect redis  exports = module.exports = db_connect_mongo

am correct in assuming once start application, /src/index.coffee :

express = require "express" logger = require "./utils/logger"  # initialize logger logger.configure()  #### application initialization # create app instance. app = express()  # define port app.port = process.env.port or process.env.vmc_app_port or process.env.vcap_app_port or 3000  # config module exports has `setenvironment` function sets app settings depending on environment. config = require "./config"  logcategory = "server"  app.configure "development", "testing", "staging", "production", ->   config.setenvironment app.settings.env  # database connection dbconnection = require "./utils/dbconnect" dbconnection.init (result) ->   if result     logger.info "database initialized", logcategory

the connection stays open, don't have keep opening , closing this?

is correct approach this?

any advice appreciated.

yes, once connect, connection stay open until explicitly disconnected or goes idle while. docs:

for long running applictions prudent enable keepalive. without it, after period of time may start see "connection closed" errors seems no reason. if so, after reading this, may decide enable keepalive:

your db_connect_mongo violates node convention first argument null when invoking callback in success case. correct this, don't use callback(true, db) mean success, use callback(null, db). other , being bit complicated can , should simpler, have should work.


Comments

Post a Comment

Popular posts from this blog

php - cannot display multiple markers in google maps v3 from traceroute result -

i'm newbie in php mysql , google maps v3. have problems in google maps v3. made traceroute web based , map traceroute's result in google maps v3 final project of college education. have try many tutorials didn't work. have tried tutorials in forum nothing worked. problem cannot display multiple markers got location data database. maybe because i'm newbie , not know how do. confuse looping show markers. here code <?php error_reporting(e_all ^ (e_notice)); ini_set('max_execution_time', 360); $enable_log_user = false; global $ip, $host_name, $host_ip; $host = @$_post['host']; $trace = @$_post['trace']; $self = $_server['php_self']; include("phpsqlajax_dbinfo.php"); $connection = mysql_connect ('127.0.0.1', $username, $password); if (!$connection) { die('not connected : ' . mysql_error());} $db_selected = mysql_select_db($database, $connection); if (!$db_selected) { die ('can\'t use db : ...
Read more

c# - DetailsView in ASP.Net - How to add another column on the side/add a control in each row? -

i have detailsview control on page used edit various fields of record, works in respect. i looking way add 1 column (and if works, why not more) right, absolutely read-only, show same fields of record comparison purposes. i aware there no obvious way such thing out of box detailsview . have looked other controls (transposed gridview , recommended formview , listview ), nothing satisfies. have special data binding setup using detailsview , can't out of without losing features. anyone on how "hack in" additional columns (for display only) on detailsview ? the solution have now, use second detailsview , visible set false in aspx. in code, make sure databind hidden detailsview hosts data third column first, initial detailsview named itemdetails . and in item created event, pass third column html rendering of hidden controls (in last code block) : protected void itemdetails_itemcreated(object sender, eventargs e) { if (dataite...
Read more

javascript - firefox memory leak -

i have following script (i use raphaeljs also) draws circle, waits 1 second, draws circle again, etc (you can copy paste - functional, need include raphael raphaeljs.com): <div id="holder"> </div> <script src="raphael.js" type="text/javascript"></script> <script> var paper = raphael(10, 50, 320, 200); var rad = math.pi / 180; var finangle = 0; function sector(cx, cy, r, startangle, endangle, params) { var x1 = cx + r * math.cos(-startangle * rad), x2 = cx + r * math.cos(-endangle * rad), y1 = cy + r * math.sin(-startangle * rad), y2 = cy + r * math.sin(-endangle * rad); return ["m", cx, cy, "l", x1, y1, "a", r, r, 0, +(endangle - startangle > 180), 0, x2, y2]; } var path = sector(100,100,50,0,180); var arc = paper.path(path); function draw() { path = sector(100,100,50,0,finangle); ...
Read more