Version 2.0:
This version brings significant enhancements to the database management system, including improved support for asynchronous SQL operations, better error handling, and advanced migration functionalities. The introduction of the SQLFactory class allows for better, easier management, execution of database connections and migration processes. Additionally, the deprecation of the SQL class indicates a shift towards more efficient and modern database management techniques and that is no longer supported.
Full Changelog: https://github.com/TntTastisch/SQLAPI/commits
Usage/Docs Documentation for v2
Bugfix
Security Update
Fixed connection mistake
Fixed migration
DatabaseCommand:
Upgraded query and update methods to support asynchronous execution of SQL operations.
Enhanced error logging capabilities for better error handling and reporting.
Introduced support for executing large SQL updates asynchronously.
ConnectionAuthenticator:
Improved management of database connections with added functionalities.
Enhanced error handling and logging for improved troubleshooting.
DatabaseType
Added easier support for defining different types of databases.
Migration
Extended functionality for handling the migration process for database tables.
Implemented support for preserving legacy data during the migration process.
SQLFactory
Introduced a new class for better management of database connections and migrations.
Added methods for creating and managing database connections with specified parameters.
Enhanced migration support with the introduction of the createMigration method for managing migration instances.
Implemented the migrate method for executing the migration process for all stored migration instances.