elixir-sqlite/ecto_sqlite3
72.1
Strong · 15 November 2026
3k
lines of production code
Elixir
primary language
5
measurements over time
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.