mysql_client 0.0.2
mysql_client: ^0.0.2 copied to clipboard
Native MySQL client written in Dart
Native MySQL client written in Dart for Dart #
See example directory for examples and usage
Roadmap #
- ✅ Auth with mysql_native_password
- ✅ Basic connection
- ✅ Connection pool
- ✅ Query placeholders
- ✅ Transactions
- ❌ Prepared statements
- ❌ SSL connection
Usage #
Create connection
final pool = MySQLConnectionPool(
host: '127.0.0.1',
port: 3306,
userName: 'your_user',
password: 'your_password',
maxConnections: 10,
databaseName: 'your_database_name', // optional,
);
Query database
var result = await conn.execute("SELECT * FROM book WHERE id = :id", {"id": 1});
Print result
for (final row in result.rows) {
print(row.assoc());
}
Tests #
To run tests execute
dart test