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-nodejs/connect/
SQLite Github link - https://github.com/TryGhost/node-sqlite3
Express Website - https://expressjs.com/

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

MySQL Video Playlist - https://www.youtube.com/watch?v=a9W7OpS4LfI&list=PLyuRouwmQCjlXvBkTfGeDTq79r9_GoMt9

ExpressJS Playlist - https://www.youtube.com/watch?v=cMbJ8hatqJ8&list=PLyuRouwmQCjne87u8XUdOM5oCl7vI2vVL

NodeJS Playlist - https://www.youtube.com/watch?v=fO8ontWnlwk&list=PLyuRouwmQCjnD0CgJYfcLnQ0LnlZHrs6B

Postman tutorial - https://www.youtube.com/watch?v=t5n07Ybz7yI

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

Тэги:

#MAD9014 #MAD9022 #web_development #JavaScript #JS #CSS #HTML #steve_flix #steveflix #web_dev #professor_Steve #prof3ssorSt3v3 #100daysofcode #SQL #SQLite #NodeJS #Node.js #express #API #how_to_build_an_API #API_database #Node_API #SQLite3 #SQLite_3

Скачать видео