mysql_dart 3.0.0

mysql_dart: ^3.0.0 copied to clipboard

• breaking: raised the minimum Dart SDK to ^3.6.0, aligning the package with the AOT benchmark baseline and allowing future hot-path refactors to use modern Dart features
• perf: COM_STMT_EXECUTE can now encode directly into a complete MySQL packet with a precomputed buffer, avoiding the generic MySQLPacket + ByteDataWriter path for prepared-statement execution
• perf: typedAssoc() now avoids reparsing values that already arrived as typed Dart values, reducing overhead for PDO-style integrations such as Eloquent that materialize every row as a typed map
• fix: cleaned up Dart 3 analyzer diagnostics in connection/auth and exception code paths without changing public exception formatting
• fix: the connection pool now validates connections after operation errors and retires broken sockets instead of returning them to the idle queue, improving recovery after database restarts
• test: added protocol unit coverage for direct COM_STMT_EXECUTE packet encoding, null bitmaps, variable-length values, temporal values, and exception formatting
• test: added real database integration coverage for prepared-statement binary result decoding with JSON payloads and BLOB bytes
• test: added an opt-in destructive pool restart test controlled by MYSQL_RESTART_COMMAND, allowing local validation against a real MySQL/MariaDB service restart under load
• docs: expanded the performance roadmap with Dart SDK baseline planning and architectural ideas from dpgsql/Npgsql for pool, data source, telemetry, retries, and auto-prepare evolution

• feat: added compatibility with MySQL Community Server 9 and 9.7, including caching_sha2_password full authentication with TLS, pinned RSA public keys, or optional server public key retrieval
• feat: binary protocol now supports MySQL JSON columns (column type 245), decoding them as UTF-8 JSON strings instead of failing at the protocol layer
• feat: integration tests now read MYSQL_* environment variables so they can run against any local or CI port/configuration
• ci: GitHub Actions now runs the test suite against MySQL 9.7 in addition to the existing database coverage
• refactor: removed external runtime dependencies on asn1lib, pointycastle, buffer, crypto, and tuple by inlining the required PEM/RSA/OAEP, hashing, tuple, and byte-writer logic
• perf: removed artificial latency from connect() and close() by replacing handshake polling with Completer signaling and removing the fixed close delay
• perf: compiled AOT benchmark now reaches 0.532 ms average connect latency, 11,255 text queries/s, 11,362 prepared queries/s, and 839,539 rows/s on 10,000-row result sets in the local MariaDB benchmark
• perf: local AOT benchmark beats PHP PDO on connect latency, SELECT 1, and 10,000-row result-set throughput, and beats PHP mysqli on connect latency and 10,000-row throughput while mysqli still leads tiny prepared statements through its native C extension
• perf: documented remaining performance headroom after 2.0.0, especially direct COM_STMT_EXECUTE encoding, per-result-set decode plans, lower row wrapper allocation, streaming memory behavior, and the final incremental packet reader/ring buffer
• perf: connect() now supports setCharsetOnConnect: false, allowing the initial charset/collation SET round-trip to be measured or skipped explicitly
• perf: packet header parsing, length-encoded integers, null-terminated strings, and packet splitting were rewritten to avoid hot-path temporary objects and repeated list concatenation
• perf: COM_STMT_EXECUTE now skips resending parameter type metadata when the parameter signature has not changed for the prepared statement
• perf: textual result-set row decoding now parses length-encoded cells inline, removing per-cell helper tuple allocation in the large result-set path
• perf: binary result-set row decoding now fast-paths common length-encoded column types, reducing per-cell helper dispatch and tuple allocation for VARCHAR, TEXT, JSON, DECIMAL, BLOB, BIT, and GEOMETRY
• perf: result-set metadata now caches case-insensitive column name lookups and precomputed Dart type hints, reducing repeated work in colByName(), typedColByName(), and typedAssoc()
• feat: iterable result sets now propagate stream pause / resume to the socket subscription, enabling real backpressure for row-by-row consumers
• feat: benchmark tooling now separates TLS vs non-TLS runs, measures connect latency with and without the initial charset SET, records median, p95, and p99, and compares materialized vs streaming result sets
• feat: added profiling and stress tools for result-set heap inspection (vm_service) and auto-prepared statement cache behavior under hot-set and thrash-set workloads
• feat: MySQLConnection now exposes auto-prepared statement cache statistics for hits, misses, evictions, deferred closes, and current cache occupancy
• feat: auto-prepared statement cache capacity is now configurable per connection and per pool with autoPreparedStatementCacheCapacity
• breaking: MySQLConnectionPool.execute(..., iterable: true) was removed because streamed results keep the physical connection busy until EOF and the old pooled flow could release the connection early
• breaking: MySQLConnectionPool.prepare() was removed and replaced by withPrepared(...), because prepared statements are bound to one physical connection and the old API could return a statement whose owning connection had already been reused by unrelated work
• docs: README and roadmap now document the new pooling constraints, withPrepared(...), iterable result-set backpressure, benchmark methodology, and the distinction between locally tested and CI-covered server versions

• fix: textual and binary result sets now decode strings with UTF-8 so accented characters appear correctly
• fix: connection pool returns connections to the idle queue even when withConnection callbacks throw, preventing resource leaks
• fix: connection pool enforces maxConnections even when multiple connections are being established concurrently
• feat: MySQLConnectionPool gained idle connection validation, recycling by age/usage, timeZone, onConnectionOpen callback, basic retry policy, and status() method for inspection.

• feat: MySQLConnection.execute now accepts positional lists and named maps directly; when parameters are present the driver auto-prepares, caches, and executes statements over the binary protocol so blobs/bytes are handled transparently
• fix: textual BLOB/TEXT columns are decoded as UTF‑8 strings consistently (even for auto-prepared/binary protocol queries), matching the associative API expectations
• docs: README now documents the new execute() usage patterns and clarifies that DECIMAL/NEWDECIMAL columns are surfaced as strings to avoid precision loss

• implemented "provide SSL certificates in createConnection"

 final SecurityContext context = SecurityContext(withTrustedRoots: true);
    final sslConn = await MySQLConnection.createConnection(
      host: 'localhost',
      port: 3306,
      userName: 'dart',
      password: 'dart',
      databaseName: 'banco_teste',
      secure: true,
      securityContext: context, 
      onBadCertificate: (certificate) => true, 
    );
    await sslConn.connect();

• implemented blob support

 await connection.execute(
        "CREATE TABLE binary_test (id INT AUTO_INCREMENT PRIMARY KEY, data BLOB)");
    final binaryData = Uint8List.fromList([0, 255, 127, 128]);
    final stmt =
        await connection.prepare("INSERT INTO binary_test (data) VALUES (?)");
    final res = await stmt.execute([binaryData]);
    expect(res.affectedRows.toInt(), equals(1));
    await stmt.deallocate();
    final result = await connection.execute("SELECT data FROM binary_test");
    final row = result.rows.first;
    expect(row.typedColByName<Uint8List>("data"), equals(binaryData));

• implemented more tests and fix bugs

• feat: Binary prepared statements with enhanced integration and unit tests

0.0.30 #

• Rename mysql_client to mysql_dart

• Add Support empty password

0.0.28 #

• Add support for unix socket on pool connection

• Add timeoutMs param to pool constructor

• Change default charset to ut8mb4 (fix emojies)
• Add timeoutMs option to connect() method
• Increase default timeout from 5 seconds to 10 seconds

• Add support for unix socket connection. See example/main_unix_socket.dart

• Fix colByName and typedColByName: ignore column name case

• Fix caching_sha2_password auth plugin

• Check server supports SSL
• Add support for multiple statements

• Fix _lastError reset in _forceClose() and used after

• Refactor error handling
• Add section about error handling to README.md
• Fix connection pool bugs
• Fix mysql protocol string parsing (ascii instead of utf8)

• Expose mysql server error code in MySQLServerException

• Remove general Exception class. Add custom exception classes

• Fix string encoding in prepared statements

• Fix in transaction flag

• Fix capability flags parsing

• Fix prepared statement select with params (handle two EOF packets if numOfCols and numOfParams are both > 0)

• Fix decoding long strings

• Add info about typed access to readme and examples

• Implement typed access to column data
• Add tests

• Add more docs and examples

• Use utf8 charset by default
• Encode all data using utf8.encode() and utf8.decode()

• Improve error handling
• Add handling of incomplete packets in _spliPackets() method
• Fix parameters substitution
• Add mysql_client tests

• Add doc comments and example

• Implement iterable result sets

• Implement caching_sha2_password auth plugin
• Refactor data packets handling
• Split data packets
• Fix some bugs

• Implement SSL connection
• Fix bug with hardcoded host and port

• Implement prepared statements
• Add more tests

• Fix readme and docs

• Initial version.