What is the difference between MySQL & MySQL2 considering NodeJS
I have read the following:
What the difference between mysql and mysql2 gem
So far I have only used MongoDB with NodeJS and I want to be able to learn MySQL for any of my relational database needs. While researching MySQL & NodeJS I have found repositories for MySQL2 and it has nothing related to the MySQL website. I'm guessing that there have been API's created that make it faster for developing with languages like NodeJS & Ruby. From a NodeJS standpoint, I'm guessing that I still run the regular MySQL database on my server, but I need to interact with it using these new API's. Like:
https://github.com/sidorares/node-mysql2/blob/master/README.md
I have seen a site where they do performance benchmarks and NodeJS & MySQL come in very low for performance and NodeJS & MySQL2 very high.
Source for this info: php-nodejs-mysql-and-mongo
Image from that post:
Do I simply use the regular MySQL database on my server and use this mysql2 API or is there a different implementation of MySQL that works with this API?
This is just 2 different APIs written by regular people. Difference is in syntax of commands and maybe in performance, just install both, make your own tests for your goals and choose one you think is more suitable for you.
Here is a comparison by NPMCompare:
- Where is MySQL's my.ini located on Windows?
- How to download Mysql jdbc jar file on centos
- pymysql.err.OperationalError: 1054. "Unknown column 'X' in 'where clause'
- What is the difference between utf8mb4 and utf8 charsets in MySQL?
- How to make a field NULL using MySQL GUI Tools?
- Renaming foreign-key columns in MySQL
- Fetch dates within the next 5 days from today, from a column of dates
- the MySQL service on local computer started and then stopped
- Using TABLE keyword to SELECT everything from vs SELECT * from table_name
- Importing CSV using MySQL Workbench. Not all records imported
- Mysql Pivot View
- unknown variable 'default-authentication-plugin=mysql_native_password'
- How to select a column with max value of other column, and all corresponding rows of column in another table?
- Trying to update a table using a trigger in mysql
- error column cannot be null, trying to upload file into sql
- Docker - mysqld: Table 'mysql.plugin' doesn't exist
- ERROR 2013 (HY000): Lost connection to MySQL server at 'reading initial communication packet', system error: 54
- How can I check (My)SQL statements for syntactical correctness
- Automate mysql_secure_installation with echo command via a shell script
- need some explanation about MySQL where ... in ... subquery
- Show values from a MySQL database table inside a HTML table on a webpage
- UTF-8 all the way through
- How to load multiline csv feature into MySQL
- What are Visible INDEX and Invisible INDEX in MySQL? Which is better?
- MySQL Error Even Purging and Reinstalling does not fix it
- Problems using MySQL with AWS Lambda in Python
- How to know relations between tables
- How to increase MySQL connections(max_connections)?
- Mysqldump without triggers : ERROR 1359 (HY000) at line 1420: Trigger already exists
- PHP, mysql_query just NOT working