O'Reilly logo

Building APIs with Node.js by Caio Ribeiro Pereira

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required