v0.4.0

Added

Node-based CLI System

• Migration CLI - Complete Node.js-based CLI for database migrations with comprehensive command support
• CLI Integration Tests - Full test coverage for CLI commands and migration workflows
• Developer-friendly CLI - Enhanced CLI with better error handling and user feedback

Heroku Deployment Support

• Heroku Configuration - Complete Heroku deployment support with environment variables and scripts
• Database Connection Utilities - Enhanced database connection handling for cloud environments
• Production Optimizations - Database configuration and logging setup optimized for production

Authentication System Enhancements

• JWT Authentication - Enhanced JWT-based authentication for analytics and database management routes
• Authentication Migration - Updated authentication mechanism from API key to JWT for specific routes
• CORS Configuration - Enhanced CORS configuration with updated allowed origins for development

Development Experience Improvements

• JSON Error Handling - Enhanced JSON parsing and error handling for invalid JSON requests
• Repository Guidelines - Added comprehensive repository guidelines document
• Environment Variable Testing - Comprehensive tests for environment variable validation and error handling
• Error Handling Tests - Extensive error handling tests across config, analytics, database, AI service, and logger utilities

Fixed

• Database Integration Tests - Resolved database integration test failures
• Password Field Consistency - Updated password field handling in database queries and integration tests
• README Corrections - Fixed repository links to point to correct API repository
• CI Workflow - Updated CI workflow for unit tests and corrected performance test commands
• Dependency Management - Fixed prepare script to handle missing husky installation and restored uuid dependency
• Release Commands - Updated release command to run migration status instead of build
• SQL Query Optimization - Updated SQL query in AnalyticsController to remove DISTINCT and group by query_text

Changed

Code Quality & Refactoring

• Response Status Codes - Refactored response status codes to use centralized constants
• Logging Improvements - Updated logging messages and improved readability across scripts
• Connection Status Updates - Enhanced connection status handling and fallback search logging
• Migration Scripts - Added migration scripts to adjust API keys key_prefix column length

Documentation & Metadata

• Version Updates - Updated version number to 0.3.0 in middleware and routes
• Project Title - Updated project title in README to include API reference
• CODEOWNERS - Updated CODEOWNERS to assign ownership to @Thavarshan
• License - Changed license to Apache-2.0 in package.json to match LICENSE file
• Documentation Exclusions - Added 'docs/' to .gitignore to exclude documentation build outputs