The MySQL Simple Asynchronous Client is a software tool designed to simplify the process of connecting to MySQL databases. It allows users to access and manipulate data asynchronously, making it a valuable tool for developers seeking to streamline their database operations.
At present, the library is in beta, and the developer welcomes testers to provide feedback and suggestions. It has only been tested with MYSQL 5, but it may work with MySQL 4.1.
The library operates using the same asynchronous mechanism as OpenSSL, whereby I/O functions return messages such as “need write” or “need read” without blocking. It links with the official MySQL client library for authentication method and conversion network host functions, ensuring durability of the library.
Memory allocation is solely handled by user code instead of the library. Therefore, users can personalize their memory managers as per their preferences.
To start, you must allocate memory for MYSAC pools, whereby each MYSAC struct manages a connection to the MySQL server, and each MYSAC struct uses 10384o. In the second stage, buffer pools need to be created to store responses. The sizes of the buffer pool can vary, and users can choose larger ones for faster execution.
For increased speed and efficiency, MySQL statements can be prepared before making the actual request. When sending requests to the server, developers should prepare the request, execute the statement, and associate a buffer with the request. Once the request is complete, the buffer can be detached from the MYSAC structure, and users can send other requests. While waiting for the response of the subsequent request, developers can utilize the buffer of the previous request.
Version 0.2 Beta: N/A