db pool

1 files changed, 12 insertions, 5 deletions

diff --git a/bucky/db/bookshelf.js b/bucky/db/bookshelf.js
index b631545..4303920 100644
--- a/bucky/db/bookshelf.js
+++ b/bucky/db/bookshelf.js
@@ -1,11 +1,18 @@
 var knex = require('knex')({
   client: 'mysql2',
   connection: {
-    host     : process.env.DB_HOST,
-    user     : process.env.DB_USER,
-    password : process.env.DB_PASS,
-    database : process.env.DB_NAME,
-    charset  : 'utf8',
+    host:     process.env.DB_HOST,
+    user:     process.env.DB_USER,
+    password: process.env.DB_PASS,
+    database: process.env.DB_NAME,
+    charset:  'utf8',
+  },
+  pool: {
+//    ping: function(connection, callback) {
+ //     connection.query({text: 'SELECT 1 = 1'}, [], callback);
+  //  },
+    min: 1,
+    max: 4,
   }
 })