Is there a way to shorten the code of getting one user from postgres DB in node.js?

Question

I use node.js and pg library (node-postgres) to interact with database.

This is the code I use to retrieve one user of specific ID:

const { rows: users } = await db.query("SELECT * FROM users WHERE id = $1", [id]);
const user = users[0];

Even if there is only one record postgres always returns an array, so I retrieve this first item in the second line.

Is there a way to shorten this code if there is only one user? Like make it one line instead of two.

adiga · Accepted Answer · 2020-12-11 11:25:47Z

2

You can directly get the first user object by destructuring the rows array

const { rows: [user] } = await db.query(...)

answered Dec 11, 2020 at 11:25

adiga

35.4k9 gold badges66 silver badges88 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1