©  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 ...

Get Building APIs with Node.js now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.