Pgmonkey

This release ensures greater compatibility across environments, offering a more stable experience for developers utilizing various Python and PostgreSQL configurations.

Thank you for your continued support! With every release, pgmonkey becomes more robust, and we’re committed to making database management simpler for you. Happy coding!

This release of `pgmonkey` focuses on robust CSV import enhancements, addressing edge cases in large and complex datasets. Version 1.1.6 introduces improvements in handling field sizes, better support for multi-gigabyte CSV files, and more user-friendly error handling to ensure seamless integration with PostgreSQL.

---

🔧 **Improvements:**

1. **Improved Field Size Handling:**
- Dynamically increased CSV field size limits, allowing for smooth processing of datasets with extremely large fields.
- Eliminates import failures caused by exceeding default field size restrictions.

2. **Graceful Handling of Header Mismatches:**
- Enhanced validation to ensure that CSV headers match database table definitions.
- Provides clear, actionable error messages to help users resolve mismatched columns effectively.

3. **Automatic Import Configuration Creation:**
- Automatically generates YAML configuration files for detected CSV properties (e.g., encoding, delimiter, headers).
- Simplifies setup for importing complex or unfamiliar datasets, with advanced detection for robust configurations.

4. **Efficient Handling of Multi-Gigabyte Files:**
- Optimized import process to handle massive CSV files (several gigabytes) efficiently, with minimal memory overhead.
- Ensures stability and performance for large-scale data ingestion.

---

💡 **How to Upgrade:**

To upgrade to the latest version, run:

bash
pip install pgmonkey --upgrade


Thank you for your continued support of `pgmonkey`! If you encounter any issues or have suggestions, please open an issue on our GitHub page. Your feedback is essential as we strive to make `pgmonkey` the best PostgreSQL management tool for your needs.

This release of `pgmonkey` introduces streamlined connection management, internal code refactoring, and a simplified CLI interface, improving usability and standardizing configurations. Version 1.1.5 focuses on enhancing the developer experience, optimizing code for maintainability, and refining user-facing tools to make `pgmonkey` more intuitive and powerful.

🔧 Improvements:

**Standardized Connection Factory Refactoring:**
- Refactored the `PostgresConnectionFactory` to unify and simplify connection instantiation across multiple connection types (normal, pool, async, and async pool).
- This standardization reduces redundant code and improves consistency, making it easier to manage and extend connection types in the future.
- Updated the connection classes to support consistent initialization, allowing for direct instantiation without keyword-specific arguments for configurations.

**CLI Command Optimization:**
- Removed the unused `settings` command from the CLI to streamline the interface, focusing on core PostgreSQL management commands (`pgconfig`, `pgserverconfig`, `pgimport`, `pgexport`).
- This adjustment declutters the CLI, making it easier to navigate and use only essential commands.

💡 How to Upgrade:

To upgrade to the latest version, run:

bash
pip install pgmonkey --upgrade


Thank you for your continued support of `pgmonkey`! If you have any questions or suggestions, please open an issue on our GitHub page. Your feedback is invaluable as we work to make `pgmonkey` the best PostgreSQL management tool for you.

This hotfix resolves an installation issue by updating the `PyYAML` dependency to a version known to install smoothly without additional build requirements. With this update, users should experience a straightforward installation process without needing manual intervention.

To upgrade to the latest version, run:

bash
pip install pgmonkey --upgrade


Thank you for your patience as we work to improve `pgmonkey`. Please don’t hesitate to reach out with any feedback or issues.