Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog, and this project adheres to Semantic Versioning.

[Unreleased]

MySQL/MariaDB Support: Complete multi-database adapter architecture
- MySQL adapter using trilogy gem for high-performance connections
- Binary log streaming support for MySQL change capture
- Cross-database compatibility testing
Enhanced Testing Suite: Comprehensive test coverage improvements
- New test files: table_test.rb, connection_test.rb, persistence_test.rb
- Enhanced PostgreSQL adapter tests with connection and replication scenarios
- Increased line coverage from 91.28% to 97.29% (+6.01 percentage points)
- 227 tests with 552 assertions providing robust validation
Ruby 3.4+ Compatibility: Forward compatibility improvements
- Added bigdecimal dependency for Ruby 3.4+ support
- Explicit dependency management for removed stdlib components
CI/CD Enhancements: Improved automation and quality gates
- Matrix testing across PostgreSQL and MySQL databases
- Enhanced MySQL integration testing with proper connection handling
- Security scanning integration and automated dependency updates

Architecture Refactoring: Modular component extraction
- Extracted AuditProcessor into separate, focused components
- Improved service layer with multi-adapter support patterns
- Enhanced configuration system supporting both PostgreSQL and MySQL
Database Adapter Pattern: Extensible multi-database support
- Abstract adapter base class for consistent interface
- Database-specific implementations with optimized performance
- Unified change event system across different database types
Test Infrastructure: Comprehensive testing improvements
- Enhanced mock-based testing for complex database operations
- Improved test organization with better separation of concerns
- Integration test scenarios for real-world usage patterns

MySQL CI Integration: Resolved connection and setup issues
- Fixed MySQL container configuration and health checks
- Improved database readiness detection and timeout handling
- Enhanced error reporting and debugging for CI environments
Dependency Management: Ruby version compatibility
- Added explicit bigdecimal ~> 3.1 dependency for Ruby 3.4+
- Resolved trilogy gem loading issues in newer Ruby versions
- Improved gem specification with proper version constraints

Code Coverage: Significant testing improvements
- Line coverage: 97.29% (647/665 lines covered)
- Branch coverage: 83.6% (158/189 branches covered)
- Comprehensive unit tests for all core modules
Performance Optimizations: Multi-adapter efficiency
- Database-specific SQL generation and parameter binding
- Optimized connection management across different adapters
- Efficient batch processing for both PostgreSQL and MySQL
Error Handling: Enhanced resilience and debugging
- Improved error messages and stack trace reporting
- Better handling of database-specific error conditions
- Enhanced logging for troubleshooting and monitoring

Documentation: Enhanced developer resources
- Updated README with MySQL/MariaDB configuration examples
- Improved inline documentation for multi-adapter usage
- Better error messages and troubleshooting guides
Testing Framework: Improved development workflow
- Faster test execution with better mock strategies
- More reliable CI/CD pipeline with matrix testing
- Enhanced debugging capabilities for test failures

Core Architecture: Complete zero-latency audit streaming implementation
PostgreSQL Adapter: Logical replication streaming with WAL decoding
ChangeEvent System: Unified change representation across database adapters
Processor: Intelligent transformation of changes into audit records
Configuration Management: Comprehensive settings with validation using dry-configurable
Service Orchestration: Thread-safe service with error handling and retry logic
Abstract Adapter Pattern: Extensible design supporting multiple database systems
User Attribution: Automatic extraction of user information from creator/updater/deleter fields
Batch Processing: Efficient bulk processing of audit records
Connection Management: Robust database connection handling with retries
Error Handling: Comprehensive error recovery and logging
Thread Safety: Concurrent processing with thread pool management

Modern Ruby Support: Ruby 3.1+ with frozen string literals
Database Features:
- PostgreSQL logical replication with pgoutput plugin
- Publication and replication slot management
- WAL position tracking and resumption
- Connection pooling and management
Event Processing:
- Real-time change capture at database level
- Structured change events with metadata
- Configurable table and schema filtering
- Transaction ID and sequence number tracking
Audit Records:
- Complete before/after data capture
- Calculated field-level changes
- User attribution from standard columns
- Timestamps and version tracking
- JSON metadata storage

Test Coverage: 94.3% code coverage (447/474 lines)
Testing Framework: Minitest with shoulda-style assertions and mocha mocking
Test Suite: 129 tests covering all components with comprehensive error scenarios
Code Quality: RuboCop compliance with modern Ruby standards
Security: bundler-audit integration for vulnerability scanning
Documentation: Inline YARD documentation for all public APIs