Up and Running with SQLite3 in a NodeJS API

In this tutorial I explain how to use a SQL based relational database using SQLite3 as the example DB. An Express-based API is created that reads and writes data from the SQLite database.

SQLite NPM package - https://www.npmjs.com/package/sqlite
SQLite Tutorial - https://www.sqlitetutorial.net/sqlite...
SQLite Github link - https://github.com/TryGhost/node-sqlite3
Express Website - https://expressjs.com/

Code from this tutorial - https://github.com/prof3ssorSt3v3/nod...

MySQL Video Playlist -    • Learning MySQL - Getting Started  

ExpressJS Playlist -    • Quickstart with Express Web Server Fr...  

NodeJS Playlist -    • Basic Terminal Commands for OSX  

Postman tutorial -    • The Basics of Using Postman for API T...  

0:00 introduction
2:00 project setup
4:30 connecting to the database
11:00 creating tables and run method
17:38 setting up the API
19:15 creating API endpoints
24:15 SQLite methods and POSTMAN
26:20 SELECTing all data
34:20 INSERTing new data
41:00 DELETEing records