canary icon indicating copy to clipboard operation
canary copied to clipboard

feat: migrate from MySQL C API to MySQL X DevAPI

Open dudantas opened this issue 8 months ago • 6 comments

This pull request encompasses the migration from the traditional MySQL C API to the modern MySQL X DevAPI across our project. This change introduces enhanced robustness, improved code readability, and leverages the modern features of MySQL X DevAPI.

Key Changes:

• Replaced all instances of MySQL C API function calls with their MySQL X DevAPI equivalents. • Refactored database interaction logic to utilize the fluent API provided by MySQL X DevAPI, ensuring more maintainable and clearer code. • Implemented error handling and data type conversions using MySQL X DevAPI's robust mechanisms, enhancing stability and performance. • Updated corresponding documentation and comments to reflect changes in the database access layer.

This update paves the way for future database interactions to be more flexible and easier to manage.

To test on Windows, you need to install the official MySQL and preferably the latest Nginx and PHP using Chocolatey.

Important: in mysqlx, the port used is 33060

dudantas avatar Jun 20 '24 05:06 dudantas