Node Local SQLite Database with Node for beginners

Learn to set up a local node server using express, require the package, create an app, define routes, and start listening on a port to serve ready messages.

Learn to use nodemon to automatically restart a node server during development, installing globally with npm and sudo, and running it to monitor app.js for changes.

Install the sqlite3 package with npm to set up a local sqlite database in node, create a users table with id, first, last, email, and password, and run queries.

Create an insert.js file, connect to the sqlite3 database, and execute an insert into the users table with email and password, logging the inserted id or any errors.

Create a reusable database module in db.js and export it with module.exports. Require the module in your node app to access the database and run insert to verify it works.

Create a query to select all from the users table, reuse the existing database object, execute the query, handle errors, and iterate over results with forEach to log each row.

List all users on a web page through an Express route /users and return a JSON array of rows from the users table.

Define a get route to fetch a user by id in a node local sqlite setup, using a parameterized select where id equals and returning a single row.

Build a frontend form that submits data to a Node backend using Ajax, parse the request with body-parser, and post to a route to insert into the database.

Create a user form with first, last, email, and password fields, submit via ajax using fetch to an express backend, and save the data to a local sqlite database.

Add a new user by sending front-end data via Ajax to a Node backend, parse the body, and insert first name, last name, email, and password into SQLite users.

Build a local node app with sqlite database, exposing routes to create, retrieve by id, and list all users, while handling form submissions, json responses, and console logging.