Breaking News: Grepper is joining You.com. Read the official announcement!

how to manage a db connection in javascript

Alive Anaconda answered on May 9, 2020 Popularity 10/10 Helpfulness 5/10

answer how to manage a db connection in javascript

related javascript database connection

how to manage a db connection in javascript

Comment

//put these lines in a seperate file
const mysql = require('mysql2');

const connection = mysql.createPool({
    host: "localhost",
    user: "",
    password: "",
    database: ""
    // here you can set connection limits and so on
});

module.exports = connection;

//put these on destination page
const connection = require('../util/connection');

async function getAll() {
    const sql = "SELECT * FROM tableName";
    const [rows] = await connection.promise().query(sql);
    return rows;
} 
exports.getAll = getAll;

Popularity 10/10 Helpfulness 5/10 Language javascript

Source: stackoverflow.com

Tags: connection javascript

Link to this answer
Share Copy Link

Contributed on May 09 2020

Alive Anaconda

0 Answers Avg Quality 2/10

Closely Related Answers

javascript database connection

Comment

Connecting to a SQL database using Node.js and the mysql package:

const mysql = require('mysql');

const connection = mysql.createConnection({
  host: 'localhost',
  user: 'username',
  password: 'password',
  database: 'databasename'
});

connection.connect((err) => {
  if (err) {
    console.error('Error connecting to database:', err);
    return;
  }
  console.log('Connected to database');
});

Popularity 9/10 Helpfulness 5/10 Language javascript

Source: Grepper

Tags: database-connection data

Link to this answer
Share Copy Link

Contributed on Mar 05 2023

SubZero

0 Answers Avg Quality 2/10

how to manage a db connection in javascript

Contents

More Related Answers

how to manage a db connection in javascript

Closely Related Answers

javascript database connection

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.