MySQL 0.2.0

The first public release of MySQL, a MySQL and MariaDB component for open.mp.

• Queries in order on one connection, in parallel on a pool, or waited for, formatted by the component with no length limit.
• Queries built in pieces, of any length, joined with %Q.
• Prepared statements with the same specifiers as queries, and batches sent to MariaDB as arrays in one command.
• Results read by field name, several result sets, kept results and MySQL_GetRow for a row in one call.
• JSON cells read by key or JSON Pointer, parsed once.
• Argon2id and bcrypt hashing and verifying on threads of the component.
• Limits, timeouts, settings from a file with ${NAME} from the environment, and TLS that never falls back to plain text.

Installation

Unpack the zip into the folder of the server: components/mysql.dll and qawno/include/mysql.inc. No plugin is needed. Windows only, 32 bit, tested with open.mp 1.6.7 and MariaDB 10.4.

See the wiki for the guides and a page for every native.

Licenses

MySQL is under the MIT License. MariaDB Connector/C (LGPL 2.1), Argon2 (CC0 or Apache 2.0), crypt_blowfish (public domain) and yyjson (MIT) are linked into the component, and their licenses are in the zip.