Today, we are going to create a todo app with React and Node JS. A to-do app, short for “to-do list application,” is a software product that assists people or teams in better organising activities and managing their time. It normally lets users to create, organise, and prioritise tasks in a list style, set reminders and due dates, and mark completed tasks.

In this article, we will see how we can create this this todo application with React, Node JS and MySQL using Sequelize. We will use React for the frontend and Node JS for the API creation.

What is Sequelize in MySQL?
Sequelize is a Node.js Object-Relational Mapping (ORM) framework that allows you to connect with relational databases using JavaScript syntax. It works with a variety of database systems, including MySQL, PostgreSQL, SQLite, and MSSQL.

When used in conjunction with MySQL, Sequelize offers a number of useful capabilities for managing database connections, accessing data, and executing migrations. It abstracts away the actual SQL queries and enables developers to deal with database tables as JavaScript objects, utilising a robust set of API methods.

Some of the key features of Sequelize with MySQL include:

Support for database migrations: Sequelize provides a way to easily create, update, and roll back database schema changes, making it easy to manage database schema changes in a controlled and repeatable way.
Object-Relational Mapping: Sequelize maps database tables to JavaScript objects, allowing developers to interact with the database using JavaScript syntax and avoid writing raw SQL queries.
Query building: Sequelize provides a powerful query builder that allows developers to create complex SQL queries using a simple and intuitive syntax.
Connection pooling: Sequelize includes a built-in connection pool, which can help improve performance by reusing database connections rather than creating a new connection for every request.
Transactions: Sequelize supports database transactions, which provide a way to group together a set of database operations that should be executed atomically.
To utilise serialisation in MySQL, you must first identify the essential areas of your application where concurrent access to the same data is possible, and then apply proper locking methods to avoid conflicts. Excessive locking can cause conflict and lower concurrency, therefore it’s critical to achieve a balance between performance and data consistency.

Now let us begin …

Building the Frontend With React
First, we have to create a new React app

npx create-react-app folderName
Next, we need to add some dependencies — react-router-dom, sweetealert2. This will help us to show the results of performed actions.

yarn add react-router-dom sweetalert2
From inside the src folder, we will create a new folder called assets -> images. We will also create another folder called components — that’s where we will put our API component. We will also create a folder called pages still inside the src folder.

Read more https://codeflarelimited.com/blog/create-a-todo-app-with-react-node-js-and-mysql-using-sequelize-and-pagination/

Why Nodejs for a to-do app?

Deicide:
Why Nodejs for a to-do app?

Yeah, there are requirements for that. I've personally seen an interview assessment question with that requirement. Also to help people understand that if you can apply to a to-do app, you can apply it to just about anything.

kemi72:

Yeah, there are requirements for that. I've personally seen an interview assessment question with that requirement. Also to help people understand that if you can apply to a to-do app, you can apply it to just about anything.

Good answer.

It's one of the fastest answer.

Paystack:


Good answer.

It's one of the fastest answer.

Thanks.

Can you build me an ios app?

dkdaniel11:
Can you build me an ios app?

Yes, sure. What is the app about?