is it possible to use node js Postgres client in blocking / synchronous way

Question

is it possible to use node js Postgres client in blocking / synchronous way

I am looking for a node js client to connect to PostgreSQL 8.3 and run my queries in synchronous blocking mode (for scripting not web server).

I am currently using https://github.com/brianc/node-postgres which works well but it only supports async.

Thank you,

Sean.

node.js
postgresql

Answer 1

You can use async in series mode to run your queries in a sync way and to avoid multiple callbacks struture : Async.series

pg.connect(configDB.connectionString, function(err, client, done) {
    if (err) { return console.error(err); }

    var condition = true;
    async.series([
        CreateExtensions,
        PushSQL,
        function (next) {
            if (condition) {
                UpdateTable(id, name, next);
            }
            else {
                next();
            }
        }
    ],
    function(err, results) {
        if (err) { console.error(err); }
        client.end();
        pg.end();
    });

    function CreateExtensions(callback)  {
        var queryConfig = 'CREATE EXTENSION postgis; CREATE EXTENSION hstore;';
        client.query(queryConfig, function(err) {
            return callback(err);
        });
    }

    function PushSQL(callback)  {
        var queryConfig = fs.readFileSync("./database/cmdb.sql", 'utf8');
        client.query(queryConfig, function(err) {
            return callback(err);
        });
    }

    function UpdateTable(id, name, callback) {
        var queryConfig = "UPDATE table SET name = '" + name + "' WHERE id = " + id + ";";
        client.query(queryConfig, function(err) {
            condition = false;
            return callback(err);
        });
    }
});