pkgs.ml
Activity Stats For agents Log in with GitHub

sqlite

v0.0.43

SQLite adapter for sqlx

Repository Open docs Open in playground
Install
riot add sqlite
riot.toml
sqlite = "0.0.43"
Last release
May 15, 2026
License
Apache-2.0
Dependencies
3
Dependents
0
Installs
2
Published versions
33
Owner
@leostera@leostera
README Expand

sqlite

SQLite driver for sqlx.

sqlite gives Riot a concrete sqlx-driver backend for file-backed and in-memory SQLite databases. It opens SQLite through native stubs, binds parameters, returns typed Sqlx_driver.Row.t values, and supports transactions.

Install

riot add sqlite

Good fits for SQLite

  • local developer tools;
  • test fixtures and ephemeral databases;
  • desktop or embedded applications;
  • single-node services that do not need a separate database server.

Minimal example

open Sqlx

let pool_result =
  Sqlx.connect
    ~config:{ Sqlx.Config.default with pool_size = 1 }
    ~driver:(module Sqlite.Driver)
    (Sqlite.Config.in_memory ())

You can swap Sqlite.Config.in_memory () for Sqlite.Config.default (Path.v "app.db") when you want a file on disk.

Use a single connection or a pool size of 1 for private :memory: databases. SQLite file-backed databases work with normal pool sizes.

Test databases

let test_creates_rows _ctx =
  Sqlite.Testing.with_db (Sqlite.Config.default (Path.v "test.db")) (fun db ->
    (* db is a temporary SQLite database connection for this callback *)
    Ok ())

Sqlite.Testing.with_db creates file-backed databases inside a temporary directory and cleans them up after the callback. Config.in_memory () stays purely in memory.

What to read

  • src/sqlite.mli documents the configuration surface in detail.
  • packages/sqlx is the higher-level API you actually query through.
Installs
Downloads over the last 30 days, stacked by release.
Total installs
2
Downloads over the last 30 days
v0.0.430
v0.0.420
v0.0.410
v0.0.401
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:30 PM
Completed
Pending
Dependencies
Dependencies declared for this release.
Show 3 dependencies Expand
Dependents
Packages that currently depend on sqlite.
No dependents Expand

No indexed dependents yet.

Recent activity
Latest publication, indexing, and post-publish pipeline events recorded for this package.
Open full activity
Show 12 recent events Expand
  • Blocked
    sqlite 0.0.43 attempt 3 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:44:38 PM
    Event
    Blocked
    Package
    sqlite
    Version
    0.0.43
    Facts
    attempt 3 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "blocked",
  "attempt_count": 3,
  "error": "error: Unknown argument: sqlite"
}
  • Build failed
    sqlite 0.0.43 build · exit 1 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:44:36 PM
    Event
    Build failed
    Package
    sqlite
    Version
    0.0.43
    Summary
    error: Unknown argument: sqlite
    Facts
    build exit 1 artifact 185bf8226516
    Artifacts
    Result key
    pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json
    Logs key
    pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/build.log
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "run_kind": "build",
  "result_key": "pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json",
  "logs_key": "pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/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": 60,
    "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: sqlite",
  "stdout_excerpt": "error: Unknown argument: sqlite"
}
  • Processing
    sqlite 0.0.43 attempt 3 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:44:31 PM
    Event
    Processing
    Package
    sqlite
    Version
    0.0.43
    Facts
    attempt 3 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "processing",
  "attempt_count": 3
}
  • Requeued
    sqlite 0.0.43 attempt 2 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:38:59 PM
    Event
    Requeued
    Package
    sqlite
    Version
    0.0.43
    Facts
    attempt 2 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "pending",
  "attempt_count": 2,
  "next_attempt_at": "2026-05-15T20:43:59.105Z",
  "error": "error: Unknown argument: sqlite"
}
  • Build failed
    sqlite 0.0.43 build · exit 1 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:38:57 PM
    Event
    Build failed
    Package
    sqlite
    Version
    0.0.43
    Summary
    error: Unknown argument: sqlite
    Facts
    build exit 1 artifact 185bf8226516
    Artifacts
    Result key
    pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json
    Logs key
    pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/build.log
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "run_kind": "build",
  "result_key": "pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json",
  "logs_key": "pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/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": 173,
    "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: sqlite",
  "stdout_excerpt": "error: Unknown argument: sqlite"
}
  • Processing
    sqlite 0.0.43 attempt 2 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:38:50 PM
    Event
    Processing
    Package
    sqlite
    Version
    0.0.43
    Facts
    attempt 2 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "processing",
  "attempt_count": 2
}
  • Requeued
    sqlite 0.0.43 attempt 1 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:30:23 PM
    Event
    Requeued
    Package
    sqlite
    Version
    0.0.43
    Facts
    attempt 1 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "pending",
  "attempt_count": 1,
  "next_attempt_at": "2026-05-15T20:35:23.949Z",
  "error": "error: Unknown argument: sqlite"
}
  • Docs ready
    sqlite 0.0.43 docs · 2 json · doc.package_generation_completed · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:30:14 PM
    Event
    Docs ready
    Package
    sqlite
    Version
    0.0.43
    Facts
    docs 2 json doc.package_generation_completed artifact 185bf8226516
    Artifacts
    Result key
    pipelines/docs/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json
    Logs key
    pipelines/docs/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/command.log
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "run_kind": "docs",
  "output_prefix": "docs/sqlite/0.0.43/",
  "public_docs_url": "https://docs.pkgs.ml/p/sqlite/0.0.43/",
  "result_key": "pipelines/docs/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json",
  "logs_key": "pipelines/docs/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/command.log",
  "json_event_count": 2,
  "non_json_stdout_count": 0,
  "last_json_event_type": "doc.package_generation_completed"
}
  • Build failed
    sqlite 0.0.43 build · exit 1 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:30:13 PM
    Event
    Build failed
    Package
    sqlite
    Version
    0.0.43
    Summary
    error: Unknown argument: sqlite
    Facts
    build exit 1 artifact 185bf8226516
    Artifacts
    Result key
    pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json
    Logs key
    pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/build.log
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "run_kind": "build",
  "result_key": "pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/result.json",
  "logs_key": "pipelines/builds/sqlite/0.0.43/185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b/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: sqlite",
  "stdout_excerpt": "error: Unknown argument: sqlite"
}
  • Processing
    sqlite 0.0.43 attempt 1 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:30:01 PM
    Event
    Processing
    Package
    sqlite
    Version
    0.0.43
    Facts
    attempt 1 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "processing",
  "attempt_count": 1
}
  • Queued
    sqlite 0.0.43 artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:09:56 PM
    Event
    Queued
    Package
    sqlite
    Version
    0.0.43
    Facts
    artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "status": "pending"
}
  • Indexed
    sqlite 0.0.43 latest 0.0.43 · artifact 185bf8226516
    Details
    When
    May 15, 2026, 08:09:53 PM
    Event
    Indexed
    Package
    sqlite
    Version
    0.0.43
    Facts
    latest 0.0.43 artifact 185bf8226516
    Payload
    {
  "artifact_sha256": "185bf822651688de934dbd2373a6240a82dfe34c0cbddc8e2d8064664ec1f05b",
  "latest": "0.0.43",
  "package_index_key": "index/v1/sq/li/sqlite.json",
  "package_index_url": "https://cdn.pkgs.ml/index/v1/sq/li/sqlite.json",
  "changed": true
}