25 replies

should i use a pool or connection in mysql

This is my first time going raw on sql. i usually use an orm(prisma)

So, in this application; it's an express application
I am using

mysql2

mysql2

package to do my queries

This application is read intensive, possibly like hundreds or more read per second

Should i use a

mysql.createConnetion

mysql.createConnetion

mysql.createPool

mysql.createPool

Also, note that i will inject the connection into express

app.use((req,res,next)=>
{
req.db = Dbconnection
})

app.use((req,res,next)=>
{
req.db = Dbconnection
})

Also, do i need to await the db? Because it's going to create more complexity

25 replies

This is my first time going raw on sql. i usually use an orm(prisma)

So, in this application; it's an express application
I am using

mysql2

mysql2

package to do my queries

This application is read intensive, possibly like hundreds or more read per second

Should i use a

mysql.createConnetion

mysql.createConnetion

mysql.createPool

mysql.createPool

Also, note that i will inject the connection into express

app.use((req,res,next)=>
{
req.db = Dbconnection
})

app.use((req,res,next)=>
{
req.db = Dbconnection
})

Also, do i need to await the db? Because it's going to create more complexity