Music Sheet Application

# Music Sheet Application

## Overview
This is a music sheet/songbook management application built with Node.js, Express, and MongoDB. It allows users to create, manage, and view songbooks with lyrics, particularly focused on Khmer (Cambodian) songs with custom font support.

## Project Structure
- **app.js**: Main Express application configuration
- **bin/www**: Server startup script (configured for port 5000)
- **models/**: Mongoose data models
  - `user.js`: User authentication model with Passport.js
  - `songbook.js`: Songbook metadata model
  - `songlists.js`: Song list model
- **routes/**: Express route handlers
  - `index.js`: Main routes
  - `books.js`: Songbook management routes
  - `songs.js`: Song management routes  
  - `users.js`: User authentication routes
- **views/**: EJS templates for frontend
- **public/**: Static assets (CSS, JavaScript, fonts, images)
- **uploads/**: User-uploaded images for songs/books

## Technology Stack
- **Backend**: Node.js 16.x with Express.js
- **Database**: MongoDB (Mongoose ODM)
- **Authentication**: Passport.js with Local Strategy
- **Template Engine**: EJS
- **File Uploads**: Multer
- **Session Management**: Cookie-session

## Configuration

### Environment Variables
- `DATABASEURL`: MongoDB connection string (required)
- `SESSION_SECRET`: Secret key for session encryption (recommended for production)
- `PORT`: Server port (defaults to 5000 for Replit compatibility)

### Current Setup Status
- ✅ Server configured to run on port 5000
- ✅ Server configured to bind to 0.0.0.0 for Replit proxy
- ✅ All dependencies installed
- ✅ MongoDB connection configured and working
- ✅ Application running successfully
- ✅ Deployment configured for autoscale

## Database Setup

### Setup Complete
The application is now connected to a working MongoDB database via the DATABASEURL environment variable.

### Connection Features
- Automatic connection validation on startup
- Clear error messages if connection fails
- Helpful troubleshooting guidance in logs

### If You Need to Change Database

**Option 1: MongoDB Atlas (Recommended - Free)**
1. Go to https://www.mongodb.com/cloud/atlas
2. Create a free account and cluster (M0 tier)
3. Get connection string: Connect → Connect your application
4. Update DATABASEURL secret in Replit with the new connection string
5. Format: `mongodb+srv://username:[email protected]/database?retryWrites=true&w=majority`

**Option 2: Alternative MongoDB Service**
- Any MongoDB-compatible service will work
- Update DATABASEURL with your connection string

**Option 3: Migrate to PostgreSQL**
- Replit provides a built-in PostgreSQL database
- Would require converting Mongoose models to PostgreSQL (Sequelize/Prisma)
- Significant code changes needed

## Running the Application

### Development
The workflow is already configured. Once a valid DATABASEURL is set:
1. The server will automatically restart
2. Access the application through the Replit webview
3. Server runs on port 5000

### Deployment
Deployment configuration will be set up once the application runs successfully.

## Features
- User authentication (signup/login)
- Role-based access (admin/operator)
- Songbook creation and management
- Song lyrics with custom Khmer fonts
- Image upload for book covers
- Search functionality
- Responsive design

## Next Steps
1. ✅ Install dependencies: `npm install` (completed)
2. ✅ Configure server for Replit (completed)
3. ✅ Set up valid MongoDB connection (completed)
4. ✅ Test application functionality (completed)
5. ✅ Configure deployment settings (completed)

**Setup Complete!** The application is ready to use and deploy.

## Recent Changes (October 13, 2025)
- Imported project from GitHub
- Updated server to use port 5000 (Replit requirement)
- Changed server binding to 0.0.0.0 for Replit proxy compatibility
- Installed all npm dependencies
- Added MongoDB connection validation and error handling
- Configured deployment for autoscale
- Verified application functionality with screenshot testing
- Created comprehensive project documentation