Lager Guru v3.4.0
Release date: 2025-12-08
Git tag: v3.4.0
Branch: feature/safety-pro-ultra
🔥 Summary
This release introduces Safety Pro Ultra, the most advanced tier of Safety Pro Edition with enhanced features, improved performance, and comprehensive HSE (Health, Safety, Environment) management capabilities.
✨ Added
Safety Pro Ultra Features
- Advanced HSE Management: Comprehensive Health, Safety, and Environment management
- Enhanced Risk Assessment: Advanced risk assessment matrix and severity calculations
- HSE KPI Views: Comprehensive KPI views for health, safety, and environment metrics
- Advanced Analytics: Enhanced analytics and reporting capabilities
- Risk Severity Matrix: Sophisticated risk severity matrix for better risk assessment
Database Enhancements
- Idempotent Migrations: All migrations are now idempotent for safe re-runs
- Performance Optimizations: Improved query performance for HSE KPI views
- Security Improvements: Enhanced RLS policies and security measures
- Index Optimizations: Optimized database indexes for better performance
UI Enhancements
- Safety Pro Ultra Pages: New UI pages for Safety Pro Ultra features
- Enhanced Navigation: Improved navigation for Safety Pro Ultra modules
- Better UX: Enhanced user experience for advanced safety features
🔧 Improved
Security & Performance
- RLS Policy Fixes: Fixed and improved RLS policies for better security
- Query Performance: Optimized HSE KPI views with proper GROUP BY clauses
- Index Performance: Removed non-immutable constraints from indexes
- Migration Safety: All migrations are now idempotent and safe to re-run
Database Schema
- DROP POLICY IF EXISTS: Added proper DROP POLICY statements for idempotency
- SECURITY INVOKER: Added SECURITY INVOKER to HSE KPI views
- Constraint Fixes: Removed CHECK constraints with CURRENT_DATE (not IMMUTABLE)
- Index Predicates: Fixed index predicates to use immutable functions only
🐛 Fixed
- Migration Idempotency: All migrations can now be safely re-run
- RLS Policy Issues: Fixed missing DROP POLICY statements
- GROUP BY Clauses: Fixed GROUP BY clause issues in HSE KPI views
- Security Warnings: Addressed Supabase Security and Performance Advisor warnings
- Duplicate Policies: Removed duplicate policy definitions
🔒 Security
- Enhanced RLS: Improved RLS policies for better security
- Idempotent Policies: All RLS policies can be safely re-created
- Performance: Optimized RLS policy execution
- Security: Enhanced security measures for HSE data
⚙ Migration Notes
- Requires Safety Pro Edition: Must have Safety Pro Edition (v3.2.0) installed first
- Idempotent Migrations: Safe to re-run migrations multiple times
- No Breaking Changes: All changes are backward compatible
- Performance Impact: Improved performance for HSE queries