Building APIs with Node.js

©  Caio Ribeiro Pereira 2016

Caio Ribeiro Pereira, Building APIs with Node.js , 10.1007/978-1-4842-2442-7_5

5. Working with SQL Databases

Caio Ribeiro Pereira¹ 

(1)São Vicente - SP, São Paulo, Brazil

In Chapter 4, we created simple routes for the application to list tasks via a static data model. That was enough to start to explore some basic concepts about API resources.

Now, we are going to work deeper on using a relational database to create dynamic management of tasks and users. To simplify our examples, we are going to use SQLite3 (Figure 5-1). It is a preinstalled database on Linux, Unix, and MacOSX, so there’s no need to set it up. However, if you are using Windows, you can easily install it by following the instructions at https://www.sqlite.org/download.htm ...