Skip to content

Welcome to Simple Book Manager! Inspired by the need for a basic CRUD application, I decided to delve into web development using Express and Node.js for the backend, React for the frontend, and MySQL for the database. This project serves as a prototype, as it's my first venture into using MySQL with Node.js.

Notifications You must be signed in to change notification settings

RadithSandeepa/simple-book-manager

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

18 Commits
 
 
 
 
 
 
 
 
 
 

Repository files navigation

Simple Book Manager

This is a simple online book management project built using Express and Node.js for the backend, React for the frontend, and MySQL for the database.

Table of Contents

Screenshots

Home

Add

Update

Features

  • CRUD operations for managing books: add, update, delete, and view.
  • User-friendly interface for easy book management.
  • Responsive design for desktop and mobile devices.

Setup Instructions

1.Clone the repository:

 git clone https://github.com/RadithSandeepa/simple-book-manager.git

2.Navigate to the project directory:

 cd simple-book-manager

3.Install dependencies:

 cd backend
 npm install
 cd frontend
 npm install

4.Set up MySQL database:

  • Create a MySQL database for the project.
  • Copy the .env.example file and rename it to .env.
  • Open the .env file and fill in the necessary data:
  DB_HOST=your_mysql_host
  DB_USER=your_mysql_username
  DB_PASSWORD=your_mysql_password
  DB_DATABASE=your_database_name

Replace your_mysql_host, your_mysql_username, your_mysql_password, and your_database_name with your MySQL database connection details.

5.Import the provided SQL file (book_manager.sql) into your MySQL database to create the necessary tables and data.

6.Start the server:

 npm start

7.Open your preferred web browser and navigate to http://localhost:3000 to access the Simple Book Manager.

About

Welcome to Simple Book Manager! Inspired by the need for a basic CRUD application, I decided to delve into web development using Express and Node.js for the backend, React for the frontend, and MySQL for the database. This project serves as a prototype, as it's my first venture into using MySQL with Node.js.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published