Node.js provides a number of third-party libraries to retrieve data from the database. These libraries provide the same power and flexibility that other languages provide to access the database. With Node.js, you are able to work with most of the available SQL and NoSQL databases. This section describes how we can access data from relational databases directly from the Electron application. Here, we use MySQL database as the backend for our application.
For demonstration purposes, let's create a small database with a single table. Create a MySQL database called customer_manager
to get started with our sample. You can use any database of your choice, but you need to use the corresponding Node.js bindings to access the data from the database. Create the database with the following command or use any MySQL GUI tools like MySQL workbench to create the database:
CREATE DATABASE customer_manager;
Add a table called customers
in the newly-created database. Use the following sample...