Promise

[eyy]

Are there any plans for Promise support, alongside the callbacks and streams?

Thanks.

[grncdr]

I have thought about it, but haven't got around to implementing anything yet. A few months ago I was thinking of adding 3 promise-returning methods on Query instances:

• .reduce( initialValue, (accumulator, row) => accumulator ) - takes an initial value and a reducer function. Returns a promise for the reduced value.
• .then( (result) => any, (error) => any ) - Same mechanics as providing a callback: all data is aggregated into a result which is passed to onSuccess, or an error is passed to onError.
• .map( (row) => any ) - Takes a function to map over result rows and returns a promise for a new Result object.

These would not be terrible difficult to implement on top of the existing stream API in a separate package that each adapter could re-use. Something like any-db-query-extensions that mixes the methods into a given object/prototype. If you're interested in writing that lib I would use it in the adapters I maintain.

[Meaglin]

Proper Promise support in any-db and any-db-transaction would be really nice :)

[vitaly-t]

@Meaglin, check out this one: pg-promise.

Proper Promise support in any-db and any-db-transaction would be really nice :)

[Justus-Maier]

To make use of the async/await syntax we need promise returns.
Workaround using promise-streams:

const wait = require('promise-streams').wait;
[...]
  await wait(connection.query(sql).on('data', row => console.log(row)));