v1.0.0

Added

• SQLiteVecClient class for CRUD and similarity search operations
• create_table() - Initialize schema with configurable dimensions and distance metrics
• add() - Insert texts with embeddings
• update() - Update existing records
• update_many() - Bulk update multiple records in a single transaction
• delete() - Remove records by rowid
• get() - Fetch single record by rowid
• get_many() - Fetch multiple records
• get_all() - Memory-efficient generator for iterating over all records
• get_by_text() - Find records by exact text match
• get_by_metadata() - Find records by metadata JSON match
• list_all() - List all records with pagination
• similarity_search() - Vector similarity search with configurable top_k
• count() - Get total record count
• clear() - Remove all records
• drop_table() - Delete table and index
• transaction() - Context manager for atomic multi-operation transactions
• Support for text, metadata (JSON), and float32 embeddings
• Automatic synchronization between base table and vec0 index via triggers
• Context manager support for automatic connection cleanup
• Distance metrics: cosine, L2, L1
• Python logging module integration with configurable log levels
• Type hints and dataclasses for typed results
• Comprehensive test suite with 91%+ coverage
• Complete CI/CD pipeline with GitHub Actions
• Enhanced GitHub release workflow with improved changelog extraction
• Better error handling in CI/CD pipeline
• Pre-commit hooks and code quality tools (ruff, mypy)
• CONTRIBUTING.md with contribution guidelines
• CHANGELOG.md for tracking changes
• TESTING.md with testing documentation
• SECURITY_IMPROVEMENTS.md documenting security enhancements
• Multiple examples in examples/ directory
• Updated batch_operations.py example with new features
• Comprehensive README with quick start guide

Security

• SQL injection prevention with table name validation
• Input validation for all parameters
• Custom exception classes for better error handling

Fixed

• PyPI publishing workflow with tag-based releases
• Changelog extraction in GitHub releases
• Changelog parsing in release notes generation