# Python Package Requirements for Django Manufacturing App

## Core Framework
- Django>=4.2,<5.0

## Database
- psycopg2-binary>=2.9.0  # For PostgreSQL in production
- sqlite3  # Built-in with Python for development

## Excel Export
- openpyxl>=3.0.0 # For Excel file generation
- xlsxwriter>=3.0  # Alternative Excel writer

## Frontend Libraries
- django-bootstrap5>=22.0  # Bootstrap 5 integration for Django
- whitenoise>=6.0.0  # For serving static files

## Utilities
- python-decouple>=3.6  # For environment configuration
- pillow>=9.0.0  # For image handling
- django-crispy-forms>=2.0  # For better form rendering
- crispy-bootstrap5>=0.7  # Bootstrap 5 template pack for crispy forms

## Development & Testing
- pytest>=7.0.0
- pytest-django>=4.5.0
- black>=22.0.0  # Code formatting
- flake8>=5.0.0  # Code linting
- coverage>=6.0.0  # Test coverage

## Reporting & Data Visualization
- matplotlib>=3.5.0  # For charts and graphs
- pandas>=1.4.0  # For data manipulation

## Backup & Restore
- django-dbbackup>=4.0.0 # For database backup and restore functionality

## Internationalization
- django-modeltranslation>=0.18.0  # For model translations if needed

## Security
- django-cors-headers>=3.13.0  # For handling CORS if needed
- django-axes>=5.20.0  # For login attempt tracking

## Performance
- django-redis>=5.2.0  # For caching
- gunicorn>=20.1.0  # WSGI server for production

## Additional Utilities
- python-dateutil>=2.8.0  # For date parsing
- requests>=2.28.0  # For API calls if needed

## Development Tools
- django-extensions>=3.2.0  # Useful Django extensions
- ipython>=8.0.0  # Enhanced Python shell
- Werkzeug>=2.2.0  # For development server enhancements

## Note
This list includes both essential and optional packages. The actual implementation may require only a subset of these packages depending on specific requirements and features implemented.