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.

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

[davidchallik]

Steve Griffith is always conveying the whole picture by breaking everything down in little steps. Excellent educator and a pleasant communicator. Thank you, Steve. I just learned the essence of what I needed to know. 😊

[tomyk]

this is the singly most helpful video on this topic. no other tutorial was ever this beginner friendly

[LoayAl-Said-jp]

Thank you professor.
I admire your style of teaching actually..

Your stepByStep, kinda way.. where you start from an overview then you go kinda layer by layer deep.. I like that systemic way..

Thanks for your efforts.

Loay here from Egypt.
Appreciate your efforts.

[mtcindianutube]

Thanks Steve, iam first time watching a video on Sqlite. Awesome ❤❤

[RafaelSales]

thank you a lot, just in time when I was needing to learn about databases

[joelomoglio]

Love the video, hands down the best one I have found, You do an excelent job of expaling things. Only wish you had covered PUT, im having a hard time creating based on how you did the others. But great job!!!

[averstrum]

Edit: in 2019-april-2 in [email protected] the body-parser middleware is included in express, so you don't need to install body-parser separately anymore

[atlantic_love]

I really need help. What I am wanting to do is make a small web app that does very little. My husband has high blood pressure, and I would like to make something that allows him to input his BP readings and save them, and to be able to look at graphs showing things like his BP average for the week. I know a little JavaScript, HTML and CSS. Is there possibly a way to do something like this from within a single folder? I'd like to copy the app over to his computer.

[gurbanoglu]

Thanks Professor. Could you please make a video covering PUT and PATCH requests with SQLite3 in a NodeJS API?

[tmoumimahmoud]

Thank you, but I have one question when to use sqlLite instead of mysql or postgress and when I should'nt , I know that all are relational database for sqllite it store in file and the other should i install DBMS ?

[orangesupercar]

Great Tutorial, Im not sure if im asking the right question. But i would like to pull from an API lets say the pokemonAPI and store into a sqlite3 database. Lets say every time a button is clicked on a website or something. Do you have any videos or anything like that to do this. I really enjoy your methods of teaching.

[sjshdhehbesjks]

thanks a lot, i was thinking of sqlite a week ago also can you make tutorial of sqlite using orm like drizzle or prisma

[kettenbach]

Great content and tutorial as always. Just missed the biggest enemy of all {Sleepy Joe, he has no clue of all the damage he's done}.