pkgs.ml
Activity Stats For agents Log in with GitHub

mysql

v0.0.43

MySQL adapter for sqlx

Repository Open docs Open in playground
Install
riot add mysql
riot.toml
mysql = "0.0.43"
Last release
May 15, 2026
License
Apache-2.0
Dependencies
4
Dependents
1
Installs
20
Published versions
10
Owner
@leostera@leostera
README Expand

mysql

MySQL/InnoDB driver for sqlx.

The package implements Sqlx_driver.Driver.Intf and is intended for MySQL 8.x and compatible servers that speak the MySQL 4.1+ protocol.

open Std
open Sqlx

module Db = Sqlx.Make (Mysql.Driver)

let config =
  Mysql.Config.{
    (default ()) with
    database = Some "app";
    user = "app";
    password = "secret";
  }

URI connection strings can set TLS preference with ssl-mode, ssl_mode, or sslMode:

let config =
  Mysql.Config.from_string
    "mysql://app:secret@127.0.0.1:3306/app?ssl-mode=disable"

Supported values are disable, prefer, and require. The default remains prefer, which attempts TLS when the server advertises it.

Parameterized SQL uses ? placeholders:

let user =
  Db.query_one pool "SELECT id, email FROM users WHERE id = ?" [ Value.int64 id ]

Supported authentication methods:

  • mysql_native_password
  • caching_sha2_password fast authentication
  • caching_sha2_password full authentication over TLS

Full caching_sha2_password RSA key exchange on plaintext connections is rejected with a structured driver error. Use ssl_mode = Require for servers that need full authentication.

For migrations, use Sqlx.Migrate.Config.for_mysql (). It selects MySQL placeholders, creates the migration table with ENGINE=InnoDB, uses GET_LOCK/RELEASE_LOCK, and runs migration bodies outside an explicit transaction by default because MySQL DDL usually commits implicitly. The driver prepares multi-statement migration bodies as individual statements before SQLx executes them.

Installs
Downloads over the last 30 days, stacked by release.
Total installs
20
Downloads over the last 30 days
v0.0.430
v0.0.420
v0.0.410
v0.0.4016
v0.0.390
Package status
Submission, indexing, and post-publish processing milestones for this release.
Submitted
May 15, 08:09 PM
Indexed
May 15, 08:09 PM
Searchable
May 15, 08:09 PM
Docs ready
May 15, 08:26 PM
Completed
Pending
Dependencies
Dependencies declared for this release.
Show 4 dependencies Expand
Dependents
Packages that currently depend on mysql.
Show 1 dependents Expand
Recent activity
Latest publication, indexing, and post-publish pipeline events recorded for this package.
Open full activity
Show 12 recent events Expand
  • Blocked
    mysql 0.0.43 attempt 3 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:43:17 PM
    Event
    Blocked
    Package
    mysql
    Version
    0.0.43
    Facts
    attempt 3 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "blocked",
  "attempt_count": 3,
  "error": "error: Unknown argument: mysql"
}
  • Build failed
    mysql 0.0.43 build · exit 1 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:43:15 PM
    Event
    Build failed
    Package
    mysql
    Version
    0.0.43
    Summary
    error: Unknown argument: mysql
    Facts
    build exit 1 artifact d54ea287637e
    Artifacts
    Result key
    pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json
    Logs key
    pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/build.log
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "run_kind": "build",
  "result_key": "pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json",
  "logs_key": "pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/build.log",
  "environment_probe": {
    "success": true,
    "exit_code": 0,
    "stdout": "glibc=glibc 2.39\nriot=riot 0.0.43 (build 2a3a2071a5f0)\nPRETTY_NAME=\"Ubuntu 24.04.4 LTS\"\nNAME=\"Ubuntu\"\nVERSION_ID=\"24.04\"\nVERSION=\"24.04.4 LTS (Noble Numbat)\"\nVERSION_CODENAME=noble\nID=ubuntu\nID_LIKE=debian\nHOME_URL=\"https://www.ubuntu.com/\"\nSUPPORT_URL=\"https://help.ubuntu.com/\"\nBUG_REPORT_URL=\"https://bugs.launchpad.net/ubuntu/\"\nPRIVACY_POLICY_URL=\"https://www.ubuntu.com/legal/terms-and-policies/privacy-policy\"\nUBUNTU_CODENAME=noble\nLOGO=ubuntu-logo",
    "stderr": "",
    "duration_ms": 55,
    "command": [
      "sh",
      "-lc",
      "printf 'glibc=%s\\n' \"$(getconf GNU_LIBC_VERSION 2>/dev/null || echo unknown)\" && printf 'riot=%s\\n' \"$(/root/.riot/bin/riot version 2>/dev/null || echo unavailable)\" && cat /etc/os-release"
    ],
    "json_events": [],
    "non_json_stdout_lines": [
      "glibc=glibc 2.39",
      "riot=riot 0.0.43 (build 2a3a2071a5f0)",
      "PRETTY_NAME=\"Ubuntu 24.04.4 LTS\"",
      "NAME=\"Ubuntu\"",
      "VERSION_ID=\"24.04\"",
      "VERSION=\"24.04.4 LTS (Noble Numbat)\"",
      "VERSION_CODENAME=noble",
      "ID=ubuntu",
      "ID_LIKE=debian",
      "HOME_URL=\"https://www.ubuntu.com/\"",
      "SUPPORT_URL=\"https://help.ubuntu.com/\"",
      "BUG_REPORT_URL=\"https://bugs.launchpad.net/ubuntu/\"",
      "PRIVACY_POLICY_URL=\"https://www.ubuntu.com/legal/terms-and-policies/privacy-policy\"",
      "UBUNTU_CODENAME=noble",
      "LOGO=ubuntu-logo"
    ]
  },
  "exit_code": 1,
  "json_event_count": 0,
  "non_json_stdout_count": 1,
  "failure_summary": "error: Unknown argument: mysql",
  "stdout_excerpt": "error: Unknown argument: mysql"
}
  • Processing
    mysql 0.0.43 attempt 3 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:43:10 PM
    Event
    Processing
    Package
    mysql
    Version
    0.0.43
    Facts
    attempt 3 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "processing",
  "attempt_count": 3
}
  • Requeued
    mysql 0.0.43 attempt 2 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:37:36 PM
    Event
    Requeued
    Package
    mysql
    Version
    0.0.43
    Facts
    attempt 2 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "pending",
  "attempt_count": 2,
  "next_attempt_at": "2026-05-15T20:42:36.318Z",
  "error": "error: Unknown argument: mysql"
}
  • Build failed
    mysql 0.0.43 build · exit 1 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:37:34 PM
    Event
    Build failed
    Package
    mysql
    Version
    0.0.43
    Summary
    error: Unknown argument: mysql
    Facts
    build exit 1 artifact d54ea287637e
    Artifacts
    Result key
    pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json
    Logs key
    pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/build.log
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "run_kind": "build",
  "result_key": "pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json",
  "logs_key": "pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/build.log",
  "environment_probe": {
    "success": true,
    "exit_code": 0,
    "stdout": "glibc=glibc 2.39\nriot=riot 0.0.43 (build 2a3a2071a5f0)\nPRETTY_NAME=\"Ubuntu 24.04.4 LTS\"\nNAME=\"Ubuntu\"\nVERSION_ID=\"24.04\"\nVERSION=\"24.04.4 LTS (Noble Numbat)\"\nVERSION_CODENAME=noble\nID=ubuntu\nID_LIKE=debian\nHOME_URL=\"https://www.ubuntu.com/\"\nSUPPORT_URL=\"https://help.ubuntu.com/\"\nBUG_REPORT_URL=\"https://bugs.launchpad.net/ubuntu/\"\nPRIVACY_POLICY_URL=\"https://www.ubuntu.com/legal/terms-and-policies/privacy-policy\"\nUBUNTU_CODENAME=noble\nLOGO=ubuntu-logo",
    "stderr": "",
    "duration_ms": 90,
    "command": [
      "sh",
      "-lc",
      "printf 'glibc=%s\\n' \"$(getconf GNU_LIBC_VERSION 2>/dev/null || echo unknown)\" && printf 'riot=%s\\n' \"$(/root/.riot/bin/riot version 2>/dev/null || echo unavailable)\" && cat /etc/os-release"
    ],
    "json_events": [],
    "non_json_stdout_lines": [
      "glibc=glibc 2.39",
      "riot=riot 0.0.43 (build 2a3a2071a5f0)",
      "PRETTY_NAME=\"Ubuntu 24.04.4 LTS\"",
      "NAME=\"Ubuntu\"",
      "VERSION_ID=\"24.04\"",
      "VERSION=\"24.04.4 LTS (Noble Numbat)\"",
      "VERSION_CODENAME=noble",
      "ID=ubuntu",
      "ID_LIKE=debian",
      "HOME_URL=\"https://www.ubuntu.com/\"",
      "SUPPORT_URL=\"https://help.ubuntu.com/\"",
      "BUG_REPORT_URL=\"https://bugs.launchpad.net/ubuntu/\"",
      "PRIVACY_POLICY_URL=\"https://www.ubuntu.com/legal/terms-and-policies/privacy-policy\"",
      "UBUNTU_CODENAME=noble",
      "LOGO=ubuntu-logo"
    ]
  },
  "exit_code": 1,
  "json_event_count": 0,
  "non_json_stdout_count": 1,
  "failure_summary": "error: Unknown argument: mysql",
  "stdout_excerpt": "error: Unknown argument: mysql"
}
  • Processing
    mysql 0.0.43 attempt 2 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:37:29 PM
    Event
    Processing
    Package
    mysql
    Version
    0.0.43
    Facts
    attempt 2 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "processing",
  "attempt_count": 2
}
  • Requeued
    mysql 0.0.43 attempt 1 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:26:35 PM
    Event
    Requeued
    Package
    mysql
    Version
    0.0.43
    Facts
    attempt 1 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "pending",
  "attempt_count": 1,
  "next_attempt_at": "2026-05-15T20:31:35.532Z",
  "error": "error: Unknown argument: mysql"
}
  • Docs ready
    mysql 0.0.43 docs · 2 json · doc.package_generation_completed · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:26:15 PM
    Event
    Docs ready
    Package
    mysql
    Version
    0.0.43
    Facts
    docs 2 json doc.package_generation_completed artifact d54ea287637e
    Artifacts
    Result key
    pipelines/docs/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json
    Logs key
    pipelines/docs/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/command.log
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "run_kind": "docs",
  "output_prefix": "docs/mysql/0.0.43/",
  "public_docs_url": "https://docs.pkgs.ml/p/mysql/0.0.43/",
  "result_key": "pipelines/docs/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json",
  "logs_key": "pipelines/docs/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/command.log",
  "json_event_count": 2,
  "non_json_stdout_count": 0,
  "last_json_event_type": "doc.package_generation_completed"
}
  • Build failed
    mysql 0.0.43 build · exit 1 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:26:13 PM
    Event
    Build failed
    Package
    mysql
    Version
    0.0.43
    Summary
    error: Unknown argument: mysql
    Facts
    build exit 1 artifact d54ea287637e
    Artifacts
    Result key
    pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json
    Logs key
    pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/build.log
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "run_kind": "build",
  "result_key": "pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/result.json",
  "logs_key": "pipelines/builds/mysql/0.0.43/d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47/build.log",
  "environment_probe": {
    "success": true,
    "exit_code": 0,
    "stdout": "glibc=glibc 2.39\nriot=riot 0.0.43 (build 2a3a2071a5f0)\nPRETTY_NAME=\"Ubuntu 24.04.4 LTS\"\nNAME=\"Ubuntu\"\nVERSION_ID=\"24.04\"\nVERSION=\"24.04.4 LTS (Noble Numbat)\"\nVERSION_CODENAME=noble\nID=ubuntu\nID_LIKE=debian\nHOME_URL=\"https://www.ubuntu.com/\"\nSUPPORT_URL=\"https://help.ubuntu.com/\"\nBUG_REPORT_URL=\"https://bugs.launchpad.net/ubuntu/\"\nPRIVACY_POLICY_URL=\"https://www.ubuntu.com/legal/terms-and-policies/privacy-policy\"\nUBUNTU_CODENAME=noble\nLOGO=ubuntu-logo",
    "stderr": "",
    "duration_ms": 59,
    "command": [
      "sh",
      "-lc",
      "printf 'glibc=%s\\n' \"$(getconf GNU_LIBC_VERSION 2>/dev/null || echo unknown)\" && printf 'riot=%s\\n' \"$(/root/.riot/bin/riot version 2>/dev/null || echo unavailable)\" && cat /etc/os-release"
    ],
    "json_events": [],
    "non_json_stdout_lines": [
      "glibc=glibc 2.39",
      "riot=riot 0.0.43 (build 2a3a2071a5f0)",
      "PRETTY_NAME=\"Ubuntu 24.04.4 LTS\"",
      "NAME=\"Ubuntu\"",
      "VERSION_ID=\"24.04\"",
      "VERSION=\"24.04.4 LTS (Noble Numbat)\"",
      "VERSION_CODENAME=noble",
      "ID=ubuntu",
      "ID_LIKE=debian",
      "HOME_URL=\"https://www.ubuntu.com/\"",
      "SUPPORT_URL=\"https://help.ubuntu.com/\"",
      "BUG_REPORT_URL=\"https://bugs.launchpad.net/ubuntu/\"",
      "PRIVACY_POLICY_URL=\"https://www.ubuntu.com/legal/terms-and-policies/privacy-policy\"",
      "UBUNTU_CODENAME=noble",
      "LOGO=ubuntu-logo"
    ]
  },
  "exit_code": 1,
  "json_event_count": 0,
  "non_json_stdout_count": 1,
  "failure_summary": "error: Unknown argument: mysql",
  "stdout_excerpt": "error: Unknown argument: mysql"
}
  • Processing
    mysql 0.0.43 attempt 1 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:25:55 PM
    Event
    Processing
    Package
    mysql
    Version
    0.0.43
    Facts
    attempt 1 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "processing",
  "attempt_count": 1
}
  • Queued
    mysql 0.0.43 artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:09:38 PM
    Event
    Queued
    Package
    mysql
    Version
    0.0.43
    Facts
    artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "status": "pending"
}
  • Indexed
    mysql 0.0.43 latest 0.0.43 · artifact d54ea287637e
    Details
    When
    May 15, 2026, 08:09:35 PM
    Event
    Indexed
    Package
    mysql
    Version
    0.0.43
    Facts
    latest 0.0.43 artifact d54ea287637e
    Payload
    {
  "artifact_sha256": "d54ea287637e3bb890b85b3bb64d77cffb87d08d61ec736f9e6fd8a2497c3a47",
  "latest": "0.0.43",
  "package_index_key": "index/v1/my/sq/mysql.json",
  "package_index_url": "https://cdn.pkgs.ml/index/v1/my/sq/mysql.json",
  "changed": true
}