Build a RESTful API with Node.js, Express, & SQLite Database

Develop a basic api route that uses http methods to perform create, read, update, and delete operations on posts, with endpoints /post and /post/:id.

Implement get routes in Node.js and Express to retrieve all posts and a single post by id, using req.params.id, array.find, and return JSON with proper 404 or 200 responses.

Implement a post route to add a new blog post by extracting title and content from the request body, auto-incrementing the id, and returning 201 with the new post.

Update a blog post with a put request to /post/:id, parse the id from the route, update the title and content, and return a post updated successfully message.

Create a delete route at /post/:id, verify the post exists, remove it from the in memory posts using splice, and respond with the deleted post or a 404 not found.

Discover how express middleware runs between request and response, and create custom logging, authentication, and error-handling middleware. Learn application level, router level, built-in, and third-party middleware and app.use usage.

Define a custom middleware in Express using app.use to intercept all routes, log request method and URL, and call next to continue to route handlers.

Learn how express.json middleware parses JSON bodies, converts them to JavaScript objects, and enables access to request.body for POST requests, with examples using Postman and error handling.

Learn to serve static files with Express middleware by using app.use and express.static from a public folder, including html, css, js, and fonts.

Learn how to implement cors middleware in express to enable cross-origin resource sharing and expose the access-control-allow-origin header, then understand browser versus server roles in cross-origin requests.

Develop a catch-all middleware in Express that returns a 404 JSON not found message for unknown routes, and note how middleware order and Express 4 versus 5 change behavior.

Define and use an error handling middleware in express to catch errors across routes, log details, and respond with a 500 internal server error without breaking the app.

Learn to connect and persist posts with a serverless, file-based sqlite database by building a db folder, database.js module, and a create db function in node.js.

Master sql basics and interact with a SQLite relational database to perform create, read, update, and delete operations.

Create a sqlite post table with id, title, content, author, category, feature image URL, created at, and updated at using a create table if not exists command.

Learn how to insert data into a SQLite database with Node.js, using prepared statements and placeholders to prevent SQL injection, including building a create post function and testing with promises.

Implement read operations for a SQLite table by building get all post and get post by id functions using SQL select, prepared statements, and promises, returning title and content.

Update the post table in SQLite using a prepared statement with placeholders to escape SQL injection and safely set the title, content, author, category by id.

Delete data from a SQLite table by implementing a delete post function with a prepared statement, handling promises, and testing via a Node.js server.

Discover the mvc pattern—model, view, and controller—as the backbone of a node.js api using sqlite, detailing data handling, json responses, and how separation of concerns enables scalable, maintainable code.

Explore how http enables client–server request–response communication and why it is stateless, using http methods, https security, headers, and common status codes to manage data.

Demonstrates how to inspect HTTP headers and methods using fetch requests to a local API, showing request and response headers, status codes (200, 304, 201), and JSON payloads.

Explore advanced routing in express by defining routes with http verbs (get, post, put, delete) and path patterns, using middleware, and organizing routes with express router.

Refactor your node api to use MVC pattern with routing, reorganizing post routes and middleware and implementing error handling and not-found logic.

Refactor the app into MVC with controllers, move routes to a dedicated controller, and implement get all posts and post by id, plus update and delete handlers, under API.

Serve posts from the database instead of dummy data by wiring the post model to the controller and using async/await with error handling to return posts and a success flag.

Fetch a single blog post by id from the database using a get post by id controller, with id parsing and 404 or a success response.

Add a new blog post via the post controller in a Node.js, Express, and SQLite RESTful API by validating title, content, author, and optional category, returning 201 with new post.

Handle http put/patch requests to update a blog post by validating title, content, and author. Update the database and return the updated post with a 200 status.

Learn to delete a blog post via the API by implementing an async delete post controller that uses the post id and returns a success message with the deleted id.

Publish your node api to render by pushing code to GitHub, configuring environment variables, and using a gitignore to exclude node_modules, database, and .env files.

Deploy a Node.js app to Render from GitHub, configure a web service on the main branch with npm install and npm run start, then verify the live API.

Keep your Node.js API awake on free hosting by implementing a cron job with the npm cron package, preventing idle shutdown and data loss from embedded SQLite.

Learn to set up a cron job in a node.js app, organize utilities, configure environment variables, and perform a scheduled fetch request to a render URL.

Push your code to GitHub, redeploy on render, and set a cron job to keep the Node.js API awake, while using Postman to perform CRUD on /post.

Configure render environment variables and set node env to production, deploy, and verify the cron job runs regularly to keep the blog post API alive and serve CRUD data.

Build a RESTful API from scratch with Node.js, Express, and a SQLite database, applying MVC with controllers, models, and routes, plus error handling and a not found response.