How can I use async/await for database queries in Node.js?

How can I use async/await for database queries in Node.js?

You can use async/await to handle asynchronous database queries in Node.js, making your code cleaner and easier to read. Here's a basic example using the 'pg' library for PostgreSQL:

const { Client } = require('pg');

const client = new Client();

async function fetchData() {
    try {
        await client.connect();
        const res = await client.query('SELECT * FROM your_table');
        console.log(res.rows);
    } catch (err) {
        console.error(err);
    } finally {
        await client.end();
    }
}

fetchData();

What happens if the database query fails?

If the database query fails, the error will be caught in the catch block of your async function. You can handle it accordingly, such as logging the error or sending a response to the user.

Can I use async/await with other databases?

Yes, async/await can be used with any database that supports promises. Libraries like Mongoose for MongoDB and Sequelize for SQL databases work well with async/await.

What are the benefits of using async/await over callbacks?

Async/await makes your code more readable and easier to maintain by avoiding callback hell. It allows you to write asynchronous code that looks synchronous.