mysql
MySQL and MariaDB client wrapper. Execute queries, use prepared statements and retrieve result sets as row dictionaries.
Install
ppm install mysql
Usage Example
uses mysql;
var conn := Connect('localhost', 'root', 'secret', 'mydb', 3306);
Execute(conn, 'INSERT INTO logs (msg) VALUES ("started")');
var users := Query(conn, 'SELECT id, name FROM users LIMIT 10');
WriteLn(IntToStr(users.RowCount) + ' users found');
for var row in users.Rows do
WriteLn(row['id'] + ': ' + row['name']);
Close(conn);
Features
MySQL 8.x and MariaDB 10.x support
Prepared statements
Transaction support
Last insert ID and affected rows
Connection pool-ready design