Creating a Node + Express + Sqlite + EJS app from Scratch
A step by step tutorial for my Class,
The code built in the demo https://github.com/john-guerra/nodeEx...
The old code, fully featured with CRUD https://github.com/john-guerra/nodeEx...
DB Browser: https://sqlitebrowser.org/dl/
SF Bike Share Data: https://s3.amazonaws.com/baywheels-da...
Navio: https://navio.dev/
(Gemini) Transcription:
Introduction [0:00, 2:22]
Setting up the project [2:23, 11:11]
Creating a Node.js project with npm [2:23, 3:11]
Choosing a template engine [3:12, 4:01]
Generating the project structure [4:02, 5:14]
Understanding the code structure [5:15, 8:09]
Front-end [5:18, 5:22]
Back-end [5:23, 5:27]
Database connection [5:28, 5:31]
Running the application [8:10, 11:11]
Fixing errors and understanding logs [8:12, 10:23]
Querying the database from the back-end [10:24, 11:11]
Populating the front-end with data [11:12, 1:44:31]
Including data in the EGS template [11:12, 12:12]
Adding loops to iterate through data [12:13, 13:21]
Formatting the data for display [13:22, 14:44]
Adding labels for the data [14:45, 16:03]
Putting it all together [16:04, 1:44:31]
Recap: how data flows through the application [16:04, 18:02]
Pushing the code to GitHub [18:03, 22:22]
Cloning the repository and setting up a new project [22:23, 24:31]