MariaDB Adds Node.js Connector
Tuesday, 18 December 2018

The developers of MariaDB have released a connector for Node.js for the database, giving developers a way to build build Node.js applications on top of MariaDB’s relational database.

Node.js is an increasingly popular framework for developers .It is an asynchronous event driven JavaScript runtime built on Chrome's V8 JavaScript engine, and uses an event-driven, non-blocking I/O model. The team at MariaDB say the new connector gives a significantly better performance over alternative connectors.

newmamriadbbanner

 

MariaDB is the spin-off of MySQL that was started when Oracle took over the original MySQL. It was developed by Monty Widenius, the main developer of the original version of MySQL. 

The connector is a non-blocking MariaDB client for Node.js that is 100 percent JavaScript and compatible with Node.js 6+. The connector was available as an alpha earlier in the year, and the updated version offers support for Insert streaming, pipelining, and batching. It also supports failover and load balancing via a multi-node configuration.

Insert streaming means that when you're using a Readable stream in your application, you can stream Insert statements to MariaDB through the connector.

Pipelining lets the connector send commands without waiting for server results so that the order is preserved. For instance, if you want to send two Insert statements, the pipeline means the connector doesn't wait for the results of the first query before sending the second Insert; instead, it sends queries one after the other, avoiding much of the network latency.

Batch support is new in this release, meaning you can send a batch of queries in one call to improve performance for situations such as needing to insert a large amount of data into a database table. There's a new batch API to handle this.

The developers of the connector say that when benchmarked against existing Node.js drivers, the MariaDB Connector performed 1.7 times faster in query mode and 35 times faster in batch mode. This is being attributed to the pipleline and insert streaming support reducing network traffic and enabling asynchronous processing of database queries from a Node.js application.

The Connector works with MariaDB’s standard SQL layer, and is available for download as a Release Candidate now and will be generally available in January.

newmamariadbsq

More Information

Node.js Connector On MariaDB Site

Related Articles

MariaDB 10.3 Release Candidate

MariaDB Enterprise Updated

MariaDB Enterprise Spring Update

MariaDB Enterprise Updated

MariaDB Enterprise

MariaDB 10 Available

 

To be informed about new articles on I Programmer, sign up for our weekly newsletter, subscribe to the RSS feed and follow us on Twitter, Facebook or Linkedin.

Banner


Crazy Clocks
10/03/2024

It's that time again when the clocks change and  time is of the essence and I indulge my interest in crazy clocks. I am always surprised that there are still new ideas for how to display the time [ ... ]



Quantum Computers Really Are A One Trick Pony
17/03/2024

Google is offering $5 million if you can think up a use for a quantum computer. Wait, I thought quantum computers were the next big thing, a revolution! Surely we know what they can do?


More News

raspberry pi books

 

Comments




or email your comment to: comments@i-programmer.info

Last Updated ( Sunday, 06 January 2019 )