voterunner

commit

5526a4a285e303cc11568e4dedc082d7600ed0ae

parent

a603875a207356176bdaa193058246684ae25e29

Author

Tobias Bengfort <tobias.bengfort@posteo.de>

Date

2017-11-19 10:57

limit number of db connections on sqlite

Diffstat

1 files changed, 5 insertions, 2 deletions

diff --git a/app.js b/app.js

@@ -20,6 +20,7 @@ var log4js = require('log4js');
   20    20 var MarkdownIt = require('markdown-it');
   21    21 
   22    22 var DATABASE_URL = process.env.DATABASE_URL;
   -1    23 var SQLITE = DATABASE_URL.match(/^sqlite/);
   23    24 var PORT = process.env.PORT || 5000;
   24    25 var HOST = process.env.HOST || 'localhost';
   25    26 
@@ -31,13 +32,15 @@ server.listen(PORT, HOST, function() {
   31    32 	log.info('Listening on ' + HOST + ':' + PORT);
   32    33 });
   33    34 
   34    -1 var db = anyDB.createPool(DATABASE_URL);
   -1    35 var db = anyDB.createPool(DATABASE_URL, {
   -1    36 	max: SQLITE ? 1 : 10,
   -1    37 });
   35    38 process.on('exit', (code) => {
   36    39 	db.close();
   37    40 });
   38    41 
   39    42 var queryDB = function(sql, data) {
   40    -1 	if (DATABASE_URL.match(/^sqlite/)) {
   -1    43 	if (SQLITE) {
   41    44 		sql = sql.replace(/\$/g, '?');
   42    45 	}
   43    46