Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Node-mysql with mariadb

I already use mariadb as a mysql server. However, I'm not sure using a node package designed for mysql is a good idea to use for mariadb.

There are actually two node packages:

  • For mscdex/node-mariasql
  • For mysqljs/mysql

I currently use mysql, since it seems pretty mature and maintained. It also seems to work well with mariadb on my side.

Are there any restrictions/incompatibilities/security issues to use mysqljs/mysql over mscdex/node-mariasql for a mariadb server?

Thanks

like image 548
Ervadac Avatar asked Apr 22 '14 17:04

Ervadac


People also ask

Can I use MySQL with MariaDB?

In fact MariaDB is fully compatible with MySQL since it was (and still is) intended to be a perfect replacement for MySQL. A standard MySQL installation comes bundled with a couple of useful tools, such as mysqldump, which is helpful for backups. It can be used with both MySQL and MariaDB.

Is Node JS good with MySQL?

Generally, Node. js is coupled with MongoDB and other NoSQL databases, but Node. js performs well with relational databases like MySQL, too. If you want to write a new microservice with Node.

Which database is best for node?

“Node. js can only be used with MongoDB (which is the most popular NoSQL database).”


2 Answers

No, it doesn't matter which you use. MariaDB is backwards compatible with MySQL. You could even connect to MySQL with node-mariasql if you wanted.

like image 145
mscdex Avatar answered Oct 15 '22 04:10

mscdex


Hi i am currently working on project with Maria DB and i am using node-mysql for production. It works really well for me. Reason of not using node-mariadb is the number of ratings and maturity of package.

like image 33
Shaikh Shahid Avatar answered Oct 15 '22 04:10

Shaikh Shahid