Creating a Local SQLite Database with Node.js

Are you interested in learning how to set up an SQLite database locally, quickly and easily? If your answer is ‘yes’, this course is for you. It begins with an introduction to Node.js and related packages. You'll learn how to prepare the developer environment by installing Editor and Terminal, using the terminal to set up your Node and opening the files and folder in your local editor. You will then learn how to install the Node and NPM Express packages in full detail.

Next, the course walks you through the procedures of creating a local machine database. The local server configuration is the first subject you'll investigate. You will then explore essential packages like Nodemon and MD5, which will improve your development workflow by automatically reloading and restarting applications. Following that, you'll discover how to install SQLite, build a database, add content and retrieve information from it.

Finally, you'll explore the Express body-parser package and how to use it to send data from the frontend to the backend, pick up that information, insert it into the database and then utilise it within the application source code. You'll also learn how to create the browser-side HTML file with a form for inputs and an event listener to send requests. Creating testing routes, returning JavaScript objects as JSON and running localhost is also discussed. Register for this 'how-to get started' course and try coding out for yourself!