New Features, Enhancements & Fixes

This release adds several highly requested capabilities including account email changes, installability via PWA, and improvements in mobile responsiveness. It also brings better environment-based credential handling. Special thanks to @humrochagf for contributing to enhanced database security and deployment compatibility!

---

✨ New Features

Account Email Change

Users can now update the email address linked to their account from the Settings page.

• Editable email field with real-time validation.
• Backend checks prevent duplicates and invalid formats.
• After a successful update, the new email is saved in localStorage and used for future logins.
• UI reflects the new email immediately.

Files: frontend/settings-new.html, frontend/settings-new.js, backend/app.py

---

Progressive Web App (PWA) Support

The application is now installable on Android devices.

• Added manifest.json with full metadata and icons.
• Implemented a service worker (sw.js) with a cache-first strategy for offline functionality.
• Linked everything in index.html and registered via script.js.

Files: frontend/manifest.json, frontend/sw.js, frontend/script.js, frontend/index.html

---

Manage Tags Button on Index Page

• New “Manage Tags” button added to the main warranties filter section.
• Opens the tag management modal directly, now centered for improved UX.

Files: frontend/index.html, frontend/script.js, frontend/style.css

---

🔄 Changes

Mobile and Tablet Responsiveness

Improved the visual layout of grid and list views on smaller screens.

• Enhanced readability and interaction for mobile and tablets.

Files: frontend/index.html, frontend/status.html, frontend/style.css, frontend/mobile-header.css

---

Database Credential Handling

Contributed by @humrochagf Replaced hardcoded DB credentials with environment-based configurations.

• Environment variables (DB_USER, DB_ADMIN_USER, DB_ADMIN_PASSWORD) are now used via Docker Compose.
• Removed redundant superuser checks and hardcoded credentials from scripts and SQL files.
• Improves deployment automation and security.

Files: Dockerfile, backend/app.py, backend/fix_permissions.py, backend/fix_permissions.sql, backend/migrations/010_configure_admin_roles.sql, 011_ensure_admin_permissions.sql, apply_migrations.py, docker-compose.yml

---

🐛 Fixes

• Modal Validation: Client-side validation for new email is improved with clear messages.
• PWA Caching: Prevents outdated assets from persisting by versioning core resources.
• Credential Errors: Resolved issues where migrations failed due to mismatched or hardcoded DB names.

---

📷 Screenshots