Clef - Interactive Music Database System

Welcome to Clef, an interactive music database system! Clef allows users to manage and interact with a music database, providing functionalities to add, update, and retrieve music records and playlists.

Features

• Add Music Records: Insert new music entries into the database.
• Update Records: Modify existing music records.
• Retrieve Music Information: Search and display music records from the database.
• User-friendly Interface: Interactive and easy-to-use frontend.

Technologies Used

• Backend: Node.js, Express.js
• Database: MySQL
• Frontend: HTML, CSS, JavaScript
• Others: Bootstrap for styling

Installation

Follow these steps to set up the project locally:

1. Clone the repository:

   git clone https://github.com/prtmsh/clef.git
   cd clef

2. Install Dependencies:

   npm install

3. Configure the Database: Create a MySQL Database. Import the schema from database-config.sql:

   mysql -u <username> -p <database_name> < database-config.sql

4. Update Configuration: Edit the database connection settings in server.js:

   const db = mysql.createConnection({
    host: 'localhost',
    user: 'your-username',
    password: 'your-password',
    database: 'your-database-name'
    });

5. Start the server:

   node server.js

6. Access the Application: Open your browser and navigate to http://localhost:3000

Contact

If you have any questions or suggestions, feel free to reach out to me: Email LinkedIn

Thank you for using Clef! Enjoy managing your music collection.