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 - www.npmjs.com/package/sqlite
SQLite Tutorial - www.sqlitetutorial.net/sqlite...
SQLite Github link - github.com/TryGhost/node-sqlite3
Express Website - expressjs.com/
Code from this tutorial - github.com/prof3ssorSt3v3/nod...
MySQL Video Playlist - • Learning MySQL - Getti...
ExpressJS Playlist - • Quickstart with Expres...
NodeJS Playlist - • Basic Terminal Command...
Postman tutorial - • The Basics of Using Po...
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

[@RafaelSales55]

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

[@luther-pd5uy]

I don't know what I would call this but good timing is up there. I have my first full stack project to submit by the 10th of August and and this is one part of my backend. Thanks for that btw. Without sounding unkind I was finding it hard to locate native English speakers with good explanations but here you are start to finish in one video.

[@mtcindianutube]

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

[@andredearaujorodrigues7725]

Tutorial too good! Amazing

[@averstrum6372]

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.

[@SteveGriffith-Prof3ssorSt3v3]

Building something like that is not too hard. An experienced developer could put it together in a day or two. Data can be saved locally (on your computer) using LocalStorage, IndexedDB, Cache API, or even cookies. The hard part is meeting the security restrictions for the browser. The pages have to be opened through a web server and localhost or some real url. You said you wanted it local so it has to be through localhost. It can't be done just opening a file in the browser like C:/Users/Files/mypage.html, the url has to start with With the storage options I listed before, you are still at the mercy of the browser deciding when it wants to delete the data. If loading the web page via localhost then you can actually save a file locally on the computer via JavaScript and then open it again via JavaScript. If you install Node.js on your computer and your husband's computer then you can easily build the website along with a Node.js module that creates the web server to load your HTML over http. It's a lot of moving parts but none are really that difficult on their own. Here is a tutorial about handling files from web pages. - kzbin.info/www/bejne/sKKVqXdjrdp8fZY

[@atlantic_love]

@@SteveGriffith-Prof3ssorSt3v3 Thanks for the great post! Lots to think about! The Node.js thing was why I was wanting to do something "local".

[@SteveGriffith-Prof3ssorSt3v3]

@atlantic_love node running on your computer or your husband's is still local. Just an extra step to set up.

[@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}.

[@alexeyn2281]

vladimir putin ? are you serious ?

[@SteveGriffith-Prof3ssorSt3v3]

всегда.

[@alexeyn2281]

@@SteveGriffith-Prof3ssorSt3v3 он же убийца, садист, военный преступник