How To Create and Populate a SQLite Users Table With Real User Data in Node JS (2022 Tutorial)

Come learn how to use SQLite and Node JS to create and populate a users table with real random user data from an API! Here we will be using the sql CREATE TABLE and INSERT INTO table, and query by saying SELECT ALL via Node’s NPM package sqlite3.

API: https://random-data-api.com/api/users/random_user?search=20

Chapters:
00:00 Intro and Setup
01:07 Connect to database
01:56 Create Users Table
02:54 Get data from API
05:15 Insert data into table
07:35 Query the database (select all)

#nodejs
#sqlite3
#database