Skip to content
CAI
Software that uses CAICheck a score

elixir-sqlite/ecto_sqlite3

72.1

Strong · 15 November 2026

3k

lines of production code

Elixir

primary language

5

measurements over time

CAI band scale
CAI trend line
CAI lens gauges

What this system is

Features

Add Ecto benchmark suite with multi-database comparison results

The \bench\ directory now includes a complete benchmarking infrastructure using the Benchee library, featuring scripts to measure performance across SQLite3, PostgreSQL, and MyXQL adapters. This update adds specific benchmarks for loading raw data into Ecto structures, parsing Ecto.Query objects into SQL, and inserting changesets/structs, along with committed result files (e.g., \bench/results/all.md\, \insert.md\) that provide baseline performance metrics for these operations on an Apple M3 Max system.

bench · high confidence

Removals

Removal of Exqlite core modules

The \Exqlite\, \Exqlite.Error\, \Exqlite.Sqlite3\, and \Exqlite.Sqlite3NIF\ modules have been removed from the library. This eliminates the public API for opening databases, executing SQL, and managing NIF bindings, effectively stripping the core SQLite functionality from this location.

lib/exqlite · high confidence

Removed C source files for SQLite NIF

The C source files \c\_src/sqlite3\_nif.c\ and \c\_src/utf8.h\ have been deleted from the project. This removes the native interface implementation and the embedded UTF-8 handling library that were previously part of the build.

_c\src · high confidence

Behavioural changes

Introduce SQLite3 adapter with configurable type encoding and decoding

The adapter now includes a dedicated codec module that handles the encoding and decoding of Ecto types (such as booleans, JSON, decimals, and datetimes) with configurable JSON libraries and datetime formats. A new type extension behavior allows custom data loaders and dumpers, while the connection layer implements the Ecto SQL Connection behavior to manage database interactions, including constraint error parsing and query execution.

lib/ecto/adapters/sqlite3 · high confidence

Project rebranded to Ecto SQLite3 Adapter with updated documentation and tooling

The project has been rebranded from 'Exqlite' to 'Ecto SQLite3 Adapter' (ecto\_sqlite3), reflecting its role as an Ecto adapter wrapping the Exqlite driver. The README has been completely rewritten to document Ecto-specific usage, configuration, type extensions, and database encryption support, replacing the previous low-level Exqlite API examples. Development tooling has been updated: the C-based build system (Makefile, Makefile.win) and .clang-format have been removed in favor of Elixir-native tooling, including a new .tool-versions file specifying Erlang 29.0 and Elixir 1.20.1, a .credo.exs configuration for static analysis, and an AGENTS.md development guide. The .formatter.exs now includes the bench directory, and .gitignore has been updated to exclude object files.

(repo-wide) · high confidence

Rename adapter to SQLite3 and introduce configurable storage types

The adapter module has been renamed from Exqlite to SQLite3 (Ecto.Adapters.SQLite3), bringing a comprehensive set of configuration options for how data is stored. Users can now explicitly configure the storage format for binary IDs (:binary\_id\_type), UUIDs (:uuid\_type), maps (:map\_type), and arrays (:array\_type) to choose between string/text representations or binary/JSONB formats. Additionally, datetime handling is configurable via :datetime\_type, and the adapter enforces stricter safety for in-memory databases by raising an error if the pool size is not 1.

lib/ecto/adapters · high confidence

SQLite library updated to version 3.35.0

The bundled SQLite C source files (sqlite3.c, sqlite3.h, and sqlite3ext.h) have been replaced with the 3.35.0 amalgamation, upgrading from the previous 3.34.1 release. This update brings the latest bug fixes, performance improvements, and new features from the SQLite project to the application.

sqlite3 · high confidence

Test coverage

Added integration test suite for SQLite3 adapter; Added integration tests for Ecto SQLite3 data handling; Added test coverage for SQLite3 adapter configuration and behavior; Added test support infrastructure for Ecto SQLite3 integration; Added test support schemas for EctoSQLite3; Added tests for SQLite3 codec and data type mappings; Configure Ecto SQLite3 test environment with sandboxing and migration support; Expanded test coverage for SQLite3 connection query generation; Removal of legacy Exqlite SQL test suite.

Dependencies

Ecto SQLite3 adapter v0.25.0: major dependency and platform upgrades

The Ecto SQLite3 adapter has been updated to version 0.25.0, requiring Elixir 1.17 and introducing significant dependency upgrades. The core SQLite driver dependency has been bumped from exqlite 0.5.x to 0.22+, and the adapter now relies on Ecto 3.14 and Ecto SQL 3.14. Additionally, the Decimal library has been upgraded to version 3.0, and the project has removed the esqlite dependency in favor of exqlite. Development tooling has also been updated, including Credo, ExDoc, and benchmarking tools.

(dependencies) · high confidence

Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

How this codebase got here

Score

  • CAI 72 → 72 (-0.2)
  • Rubric changed (rubric-2026.10.5 → rubric-2026.11.4) — scores are not directly comparable.

Lenses

  • Code Health 98 → 97 (-0.9)
  • Architecture 74 → 74 (+0.0)
  • Maturity 66 → 66 (+0.0)
  • Readiness 73 → 73 (-0.1)
  • Security 96 → 93 (-2.7)
  • Performance 85 → 85 (+0.0)

New (5)

  • Edited copy of a member (16 corresponding lines) (lib/ecto/adapters/sqlite3/connection.ex)
  • Edited copy of a member (7 corresponding lines) (lib/ecto/adapters/sqlite3/connection.ex)
  • Edited copy of a member (8 corresponding lines) (lib/ecto/adapters/sqlite3/connection.ex)
  • Medium CVE: EEF-[CVE redacted] (mix.lock)
  • Outdated: ecto

Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.

Survey your own repository

elixir-sqlite/ecto_sqlite3 was measured the same way every project in this corpus was: the same rubric, at a pinned commit, with the result published in full. Point a surveyor at a repository you know and see whether you agree with it.

About this page

  • The score is its most recent published measurement, taken on 15 November 2026 at a pinned commit. It is not a live figure and does not change until the project is measured again.
  • Measured at commit d25d4aa85d541fc66ef4d6fa45612bd0c62c3a52 — the exact code this score is about.
  • Scored under rubric-2026.11.4 — the same rubric and the same method as every other entry in this index.
  • Measured by Canine Code Analyzer (cca.canine.dev) using cca measure-2026.11.65+preprod-3c33c1882dc1.