What are the ways to connect to MySQL on Node JS?

Question

MySQL

Still using require('mysql') to connect to MySQL ?
As a PHP-shnik, I connected on puff using mysqli ...
What is the best option?
Thank you!

Answer 1

There are no standard tools in node for MySQL, you need to install them using npm.
The most popular and easiest option: https://github.com/mysqljs/mysql
A more interesting option (includes a migration system and query-builder) - https://github.com/tgriesser/knex
The second one also knows how to work with postgres and sqlite.