Release version 1.2.0

Changelog

[v1.2.0] - 2024-07-12

Added

• Status Display: Real-time status messages to provide feedback during the merge process.
• Client Traffic Merging: Enhanced logic to merge client traffic data, ensuring accurate aggregation based on parent usage when specific client data is missing.
• Similar Ports Detection: Identify and display similar ports found during the merge process for better clarity.

Improved

• Error Handling: Further improved error handling with clear messages for operational errors and warnings.
• Code Refactoring: Additional refactoring for better readability and maintainability.
• User Interaction: Enhanced GUI and terminal interface logic for improved user interaction.

Fixed

• Client Traffic Issues: Resolved issues where client traffic data was not correctly merged, particularly for clients under the same port.

Notes

• Port Merging: Ensure the merging process considers both client-specific data and parent inbound data to maintain accuracy.
• Environment Requirements: Ensure Tkinter is installed for GUI operations and that the TERM environment variable is set in terminal environments.

License

• This project is licensed under the MIT License.

Contributions

• Contributions are welcome! Please fork the repository and submit pull requests for any features, bug fixes, or improvements.

Acknowledgements

• Developed by g3ntrix

In this release, we focused on improving the database merging functionality, specifically handling client traffic data more accurately by leveraging parent usage data when specific client data is missing. We've added real-time status displays to keep users informed during the merge process and implemented better error handling to provide clear feedback when issues arise. Additionally, we've improved the user interaction for both GUI and terminal interfaces and refactored the code for enhanced readability and maintainability. Similar ports found during the merge are now displayed, offering more clarity on the merging process.

Release version 1.1.1

Changelog

[v1.1.1] - 2024-06-16

Fixed

• Ensure TERM environment variable is set to avoid issues in IDEs and unsupported terminals.
• Improved compatibility for terminal environments that do not support curses.

[v1.1.0] - 2024-06-16

Added

• Merge Identical Ports: New feature to detect identical ports and merge their clients into one entry in the final database.
• Enhanced Client Merging: Improved logic for merging unique clients from both databases under the same port.

Improved

• Performance Improvements: Optimized the merging process to handle larger databases more efficiently.
• Error Handling: Improved error messages and handling for better user experience.
• Code Refactoring: Cleaned up code for better readability and maintainability.

Fixed

• Bug Fixes: Resolved issues with the previous version related to merging databases and handling duplicate entries.

[v1.0.0] - 2024-06-16

Added

• Initial release of SQLiteTrim.
• GUI and Terminal Interfaces: Users can choose between a graphical interface or terminal commands for interacting with SQLite databases.
• Recreate Database with Sequential IDs: Functionality to reorder IDs in a database sequentially starting from a specified ID.
• Merge Databases: Combine two SQLite databases, ensuring unique client entries and handling port conflicts.
• Delete Database Rows: Delete single rows or a range of rows from the database and recreate the database with sequential IDs.
• Environment Detection: Automatic detection of the environment (GUI or terminal) and appropriate handling of file selection and user inputs.
• Backup Recommendation: Prominent notice to users to back up their data before using the tool.
• Dependency Checks: Ensures necessary dependencies like Tkinter are installed for GUI operations.

Notes

• Merging Databases: When merging, ensure no identical ports exist in both databases to avoid conflicts.
• Environment Requirements: Detailed requirements for running the tool in both GUI and terminal environments.
• Screenshots: Included screenshots for a better understanding of the tool’s interface and processes.

License

• This project is licensed under the MIT License.

Contributions

• Contributions are welcome! Please fork the repository and submit pull requests for any features, bug fixes, or improvements.

Acknowledgements

• Developed by g3ntrix

SQLiteTrim v1.1.0

Changelog

[v1.1.0] - 2024-06-16

Added

• Merge Identical Ports: New feature to detect identical ports and merge their clients into one entry in the final database.
• Enhanced Client Merging: Improved logic for merging unique clients from both databases under the same port.

Improved

• Performance Improvements: Optimized the merging process to handle larger databases more efficiently.
• Error Handling: Improved error messages and handling for better user experience.
• Code Refactoring: Cleaned up code for better readability and maintainability.

Fixed

• Bug Fixes: Resolved issues with the previous version related to merging databases and handling duplicate entries.

Notes

• Backup Recommendation: Continue to backup your data before using the tool, especially with the new merging feature.

License

• This project is licensed under the MIT License.

Contributions

• Contributions are welcome! Please fork the repository and submit pull requests for any features, bug fixes, or improvements.

Acknowledgements

• Developed by g3ntrix

SQLiteTrim v1.0.0

Changelog

[v1.0.0] - 2024-05-27

Added

• Initial release of SQLiteTrim.
• GUI and Terminal Interfaces: Users can choose between a graphical interface or terminal commands for interacting with SQLite databases.
• Recreate Database with Sequential IDs: Functionality to reorder IDs in a database sequentially starting from a specified ID.
• Merge Databases: Combine two SQLite databases, ensuring unique client entries and handling port conflicts.
• Delete Database Rows: Delete single rows or a range of rows from the database and recreate the database with sequential IDs.
• Environment Detection: Automatic detection of the environment (GUI or terminal) and appropriate handling of file selection and user inputs.
• Backup Recommendation: Prominent notice to users to back up their data before using the tool.
• Dependency Checks: Ensures necessary dependencies like Tkinter are installed for GUI operations.

Notes

• Merging Databases: When merging, ensure no identical ports exist in both databases to avoid conflicts.
• Environment Requirements: Detailed requirements for running the tool in both GUI and terminal environments.
• Screenshots: Included screenshots for a better understanding of the tool’s interface and processes.

License

• This project is licensed under the MIT License.

Contributions

• Contributions are welcome! Please fork the repository and submit pull requests for any features, bug fixes, or improvements.

Acknowledgements

• Developed by g3ntrix