There are many libraries and frameworks for the Node.js runtime, and among them MySQL has developed its own library for node.js. You can query and manage MySQL database through this library. However, you have to write a lot of code for each request😨:
// Example of creating database in Node.js MySQL
var mysql = require('mysql');
var con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword"
});
con.connect(function(err) {
if(err){
console.log(err.message);
};
console.log("Connected!");
con.query("CREATE DATABASE mydb", function (err, result) {
if(err){
console.log(err.message);
};
console.log("Database created");
});
});
And it can be confusing to programmers who are just starting to program. Or, if you are working on a big project there is also a possibility that you will end up with a lot of code like this.
But recently a NanoQL library has been developed. The main and purpose of this library is to make it easy to send and manage MySQL queries and execute programs through shortcodes. Now let's create a database in MySQL with NanoQL:
(Quick start and installation NanoQL:)
npm install nanoql
// Example of creating database
var Nanoql = require("nanoql");
var con = new Nanoql(["localhost", "yourusername", "yourpassword"]);
console.log("Connected!");
con.sql(`CREATE DATABASE mydb`, (err, res)=>{
con.isErr(err);
console.log("Database created");
});
Now let's look at other examples:
// Creating table in Node.js MySQL
var mysql = require('mysql');
var con = mysql.createConnection({
host: "localhost",
user: "yourusername",
password: "yourpassword",
database: "mydb"
});
con.connect(function(err) {
if(err){
console.log(err.message);
};
console.log("Connected!");
var sql = "CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))";
con.query(sql, function (err, result) {
if(err){
console.log(err.message);
};
console.log("Table created");
});
});
// Creating table in Node.js MySQL + NanoQL
var Nanoql = require("nanoql");
var con = new Nanoql(["localhost", "yourusername", "yourpassword", "mydb"]);
console.log("Connected!");
con.sql(`CREATE TABLE customers (name VARCHAR(255), address VARCHAR(255))`, (err, res)=>{
con.isErr(err);
console.log("Table created");
});
If you want to save time using MySQL and want to program in easy ways, I recommend NanoQL.
Top comments (0)