v0.2.0 - Production Ready Release

sonnixgres v0.2.0 - Production Ready Release

This release marks sonnixgres as production-ready with complete feature implementation, security fixes, and comprehensive testing infrastructure.

Key Highlights

Security Fixes

• Fixed SQL injection vulnerabilities in identifier sanitization
• Added case-insensitive SQL keyword detection
• Strengthened regex patterns and expanded keyword list to 70+ keywords

Complete Feature Implementation

• All advertised functions now fully implemented
• Exception hierarchy with 27 custom exception classes
• Transaction management with context managers
• Comprehensive input validation (9 validation functions)

Robustness & Reliability

• Connection pooling (psycopg2 ThreadedConnectionPool + SQLAlchemy QueuePool)
• Query result caching with configurable TTL
• Retry logic with exponential backoff
• Automatic reconnection on connection failures
• Structured JSON logging with performance monitoring

Testing & CI/CD

• GitHub Actions workflow for automated testing
• Tests on Python 3.9, 3.10, 3.11, 3.12
• PostgreSQL 15 test database service
• Code coverage reporting with 70% minimum threshold
• 25 test functions across 10 test classes

Documentation

• Complete README with API reference
• Comprehensive CHANGELOG
• Installation and configuration guides
• Usage examples and error handling documentation

Issues Resolved

• Issue #10: Core module implementation complete
• Issue #11: SQL injection vulnerabilities fixed
• Issue #12: All imports and dependencies resolved
• Issue #14: Robustness and error handling complete
• Issue #15: CI/CD pipeline and test coverage added

Installation

pip install sonnixgres

See README.md for complete documentation.