Pgmonkey

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.

This hotfix addresses an installation issue with `PyYAML` in version 1.1.2. We've pinned `PyYAML` to a compatible version to prevent build errors during installation. Users should now experience a smooth installation without additional dependencies.

To upgrade, run:

bash
pip install pgmonkey --upgrade


Thank you for your patience and understanding.

This release of pgmonkey focuses on dependency updates, code and documentation enhancements, and a refined approach to version compatibility for smoother future updates. Version 1.1.2 brings improved flexibility, addressing potential conflicts with newer dependency versions, and introduces minor code updates to support easier connection management.

---

🔧 Improvements:

- **Dependency Version Compatibility**:
- Updated version specifications for key dependencies to maintain flexibility with the latest releases, reducing the risk of version conflicts while ensuring compatibility with future updates.
- This change allows users to stay current with dependency updates within stable major versions without manual updates, enhancing pgmonkey’s long-term reliability.

- **Connection Context Management Documentation**:
- Expanded documentation on managing database connections with context managers (`async with` and `with`) to support both synchronous and asynchronous operations. This update provides clearer guidance and example usage, making it easier for users to manage resources effectively and handle errors smoothly.

- **Requirements File Standardization**:
- Consolidated and standardized dependency requirements across `requirements.txt` and internal dependency configurations, ensuring consistent package management and simplifying project setup.

---

📚 Documentation Updates:

- **Release Notes and Versioning**:
- Added detailed release notes to guide users through new version features and changes. This documentation update includes example code and usage recommendations, making it easier for users to adopt the latest changes quickly.

---

💡 How to Upgrade:

To upgrade to the latest version, run:

bash
pip install pgmonkey --upgrade


Thank you for using pgmonkey! We value your feedback and contributions. If you encounter issues or have suggestions, please feel free to open an issue on our GitHub page.

This release introduces key improvements for `pgmonkey`'s import and export functionality, along with important bug fixes and documentation updates. The focus of this release is on standardizing input argument styles for a more consistent user experience and addressing a few quality-of-life fixes.

🔧 Improvements:
- **Standardized Argument Input Style for `pgimport` and `pgexport`**:
- The input style for `pgimport` and `pgexport` commands has been updated to be consistent. The `--import_file` and `--export_file` options are now used in both commands for specifying file paths, providing a more intuitive and uniform command-line experience.
- This change simplifies usage, making it easier for users to remember command structures and reducing potential confusion.

📚 Documentation Updates:
- **Updated Quick Reference for `pgimport` and `pgexport`**:
- Added missing entries for `pgimport` and `pgexport` in the Quick Reference section of the documentation, ensuring users have easy access to examples and usage tips for these commands.
- Updated the example usage and option descriptions to reflect the new standardized argument style for `pgimport` and `pgexport`.

🐛 Bug Fixes:
- **Progress Bar and Blank Line Handling**:
- Fixed an issue with the progress bar during data import where blank lines were being counted towards the total, leading to inaccurate progress reporting.
- Implemented a fix to skip over blank lines during data import, ensuring that only valid data rows are processed. This improves efficiency and accuracy when importing CSV and text files.
- **Header Blank Line Fix**:
- Corrected a bug that caused blank lines in headers to be mishandled during imports, leading to better parsing of CSV headers.


💡 How to Upgrade:
To upgrade to the latest version, run:
bash
pip install pgmonkey --upgrade


Thank you for using `pgmonkey`! We appreciate your feedback and contributions. If you encounter any issues or have suggestions, please feel free to open an issue on our [GitHub page](https://github.com/RexBytes/pgmonkey).

🚀 New Features and Enhancements:

**Enhanced Data Export and Import:**

- **Custom Delimiters Now Fully Supported:**
Users can specify custom delimiters, including tab (`\t`) and pipe (`|`) characters, directly in their configuration files. The export functionality has been updated to respect these settings, making it easier to work with a variety of data formats.

- **Improved Handling of Blank Lines in CSV Imports:**
The import process has been made more robust by automatically skipping blank lines within CSV files. This ensures smoother data ingestion without errors due to unexpected empty rows, allowing for cleaner data processing.

- **Client Encoding Respect:**
Improved alignment between database client encoding settings and output file encoding during data export, ensuring that data is exported in the correct format. This enhances compatibility when working with diverse character sets and encoding needs.

**Performance Optimizations:**

- **Optimized Binary Mode Data Handling:**
Export operations now leverage binary mode for data output, resulting in faster file writing. This choice balances speed with flexibility, particularly for large datasets, making pgmonkey a better choice for high-volume data tasks.

- **Refined Async and Sync Import Logic:**
The importer’s logic for handling async and sync connections has been refined, ensuring consistent performance across various environments. This streamlines the experience for developers switching between connection types, offering more predictable behavior.

**Better Error Handling and Debugging:**

- **Clearer Error Messages for Invalid Configurations:**
Configuration parsing has been improved to provide more informative feedback when settings are incorrect, such as when an unsupported delimiter is used. This reduces troubleshooting time and helps users correct issues faster.

- **Enhanced Logging for Import/Export Processes:**
The import and export methods now include detailed logging of steps and progress, making it easier to diagnose issues and track the status of long-running operations.

♻️ Backward Compatibility:

- All core functionalities from version 1.0.11 remain intact, with enhancements designed to augment existing workflows rather than replace them.
- Previous configuration files continue to work without modification. New options for delimiter and encoding provide additional flexibility for users without breaking legacy setups.

🐛 Bug Fixes:

- **Resolved:** Fixed an issue where blank lines in CSV data files caused import failures, ensuring that blank lines are skipped.
- **Improved:** Corrected a problem with the COPY command where the specified delimiter was not respected, particularly for tab-delimited files.
- **Refined:** Adjusted the handling of database encoding settings during exports to prevent mismatches between the database and file output encoding.

⚙️ Migration Notes:

- Users are encouraged to review their configuration files to take advantage of the new delimiter options, especially if dealing with data formats that require non-standard separators.
- For optimal performance, consider enabling the use of binary mode for data exports, especially when working with large files.
- No mandatory changes are required for existing setups. Existing YAML configuration files will continue to work seamlessly, while users can benefit from the improved robustness and flexibility of this release.

**What This Means for pgmonkey Moving to 1.1.0:**

Version 1.1.0 marks a significant step forward in pgmonkey’s evolution as a robust database utility tool. This release focuses on improving data handling and performance, making it a reliable choice for both routine and high-volume data tasks. The addition of more precise control over CSV formats and better error handling positions pgmonkey as a more flexible and user-friendly solution for database export and import operations.

As pgmonkey moves to version 1.1.0, developers can expect a smoother experience with fewer edge-case errors, faster processing, and enhanced compatibility with various data formats. This release underscores pgmonkey's commitment to delivering a seamless and efficient data management tool that meets the needs of modern database workflows. Happy coding with pgmonkey! 🐒🚀