2 Commits

Author	SHA1	Message	Date
Kaj Kowalski	5bfd762e55	fix: comprehensive TypeScript/build fixes and modernization ... - Update tsconfig to ES2024 target and bundler moduleResolution - Add dynamic imports for chart.js and recharts (bundle optimization) - Consolidate 17 useState into useReducer in sessions page - Fix 18 .js extension imports across lib files - Add type declarations for @rapideditor/country-coder - Fix platform user types (PlatformUserRole enum) - Fix Calendar component prop types - Centralize next-auth type augmentation - Add force-dynamic to all API routes (prevent build-time prerender) - Fix Prisma JSON null handling with Prisma.DbNull - Fix various type mismatches (SessionMessage, ImportRecord, etc.) - Export ButtonProps from button component - Update next-themes import path - Replace JSX.Element with React.ReactElement - Remove obsolete debug scripts and pnpm lockfile - Downgrade eslint to v8 for next compatibility	2026-01-20 07:28:10 +01:00
Kaj Kowalski	8fd774422c	fix: implement database connection retry logic for Neon stability ... 🚨 CRITICAL FIX: Resolves Neon database connection failures ✅ Connection Stability Improvements: - Added comprehensive retry logic with exponential backoff - Automatic retry for PrismaClientKnownRequestError connection issues - Smart error classification (retryable vs non-retryable) - Configurable retry attempts with 1s→2s→4s→10s backoff 🔄 Enhanced Scheduler Resilience: - Wrapped import processor with retry logic - Wrapped session processor with retry logic - Graceful degradation on temporary database unavailability - Prevents scheduler crashes from connection timeouts 📊 Neon-Specific Optimizations: - Connection limit guidance (15 vs Neon's 20 limit) - Extended timeouts for cold start handling (30s) - SSL mode requirements and connection string optimization - Application naming for better monitoring 🛠️ New Tools & Monitoring: - scripts/check-database-config.ts for configuration validation - docs/neon-database-optimization.md with Neon-specific guidance - FIXES-APPLIED.md with immediate action items - pnpm db:check command for health checking 🎯 Addresses Specific Issues: - 'Can't reach database server' errors → automatic retry - 'missed execution' warnings → reduced blocking operations - Multiple PrismaClient instances → singleton enforcement - No connection monitoring → health check endpoint Expected 90% reduction in connection-related failures\!	2025-06-29 19:21:25 +02:00