Skip to content
CAI
Software that uses CAICheck a score

woylie/flop

70.4

Strong · 15 November 2026

9.1k

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 custom Ecto types for flexible filter value casting

New custom Ecto types (\Any\, \ExistingAtom\, and \Like\) have been added to the \lib/flop/custom\_types\ directory to improve how filter values are validated and cast. The \Any\ type allows values to pass through unchanged, \ExistingAtom\ safely converts binary strings to existing atoms, and the \Like\ type supports casting values for \ilike\ and \like\ operators as either a single string or a list of strings, enhancing the flexibility of filter inputs.

_lib/flop/custom\types · high confidence

Initial release of Flop for Ecto filtering, ordering, and pagination

This change introduces the Flop library, a helper for filtering, ordering, and paginating Ecto queries. It provides a \use Flop\ macro for creating config modules with default options, schema-level validation via \Flop.Schema\, and core functions like \validate\_and\_run/3\ to execute queries with parameters. The library supports page-based, offset-based, and cursor-based pagination, along with configurable global and schema-specific options for limits, filters, and sorting.

lib · high confidence

Introduce Ecto adapter for custom field support

The Ecto adapter has been implemented to enable filtering, sorting, and cursor pagination on custom, compound, and join fields. This change allows users to define custom fields with specific Ecto types and operators, supporting complex queries that were previously unavailable or required workarounds.

lib/flop/adapter · high confidence

Introduces adapter-based architecture and cursor-based pagination

Flop now supports cursor-based pagination (via \:first\/\:after\ and \:last\/\:before\) alongside existing offset and page methods, enabling efficient navigation for large datasets. The library introduces a new \Flop.Adapter\ behaviour to decouple query building from specific data sources, allowing for extensibility beyond Ecto. This change also adds new filter operators (\:empty\, \:not\_empty\, \:contains\, \:not\_contains\, \:starts\_with\, \:ends\_with\, and \like/ilike\ variants), support for custom, join, and compound fields, and stricter configuration validation using NimbleOptions.

lib/flop · high confidence

New backend and schema configuration cheat sheets for Flop

Added two new documentation cheat sheets in the guides/cheatsheets directory: 'backend.cheatmd' and 'schema.cheatmd'. The backend guide details how to configure the Flop backend module, including application environment settings, pagination options, feature toggles (filtering, ordering, pagination), and Ecto adapter configurations. The schema guide explains how to configure Flop options directly on Ecto schemas using @flop\_options, covering basics, limit/ordering settings, alias fields, compound fields, and join fields.

guides/cheatsheets · high confidence

Behavioural changes

Credo configuration updated to use elixir\_baseline preset

The project's Credo linting configuration has been replaced with a minimal file generated by the \elixir\_baseline\ preset. This change shifts the linting strategy to inherit Credo's default checks, allowing new checks to be applied automatically during Credo upgrades, while explicitly enabling specific readability and refactoring checks (such as \BlockPipe\ and \StrictModuleLayout\) via the \extra\ configuration.

(repo-wide) · high confidence

Improved database compatibility and new string filtering options

The Ecto adapter now includes a dialect system that automatically adapts queries for database-specific limitations, such as falling back from ILIKE to LIKE for MySQL and SQLite, emulating NULLS FIRST/LAST ordering for MySQL, and using JSON functions for array queries in MySQL. Additionally, new filtering operators (starts\_with and ends\_with) are now supported, and cursor pagination on nullable columns has been fixed to work correctly.

lib/flop/adapter/ecto · high confidence

Initial configuration setup for test environment

The application now includes a structured configuration setup with a base config file that loads environment-specific settings. Specifically, the test environment configuration has been defined to set up Ecto repositories for the Flop library, enable diagnostics, configure StreamData properties (adjusting max runs and run time based on CI environment variables), and set the logger level to warning.

config · high confidence

Test coverage

Add MySQL adapter test infrastructure; Add SQLite adapter integration tests; Added PostgreSQL adapter test infrastructure; Added comprehensive test coverage for Flop validation, cursor handling, and schema configuration; Added integration tests for Ecto adapter ordering and custom fields; Added test coverage for Flop validation and custom types; Added tests for Ecto dialect handling and cursor pagination; Expanded test support schemas and utilities for advanced filtering and custom fields; Removed legacy FlopTest module.

Dependencies

Major dependency upgrade and expanded test infrastructure

This release upgrades core dependencies to modern versions, including Ecto to \~\> 3.11, Postgrex to 0.22.4, and Credo to 1.7.19, while adding support for MySQL (via MyXQL) and SQLite (via Ecto SQLite3) in the test suite. The project now requires Elixir 1.11+, introduces new aliases for running tests against specific database adapters, and adds documentation tooling like Makeup Diff for better code highlighting in guides.

(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 70 → 70 (-0.1)
  • Rubric changed (rubric-2026.10.5 → rubric-2026.11.4) — scores are not directly comparable.

Lenses

  • Code Health 97 → 97 (-0.5)
  • Architecture 92 → 92 (-0.2)
  • Maturity 54 → 54 (+0.0)
  • Readiness 75 → 75 (-0.1)
  • Security 99 → 99 (-0.4)

New (7)

  • Edited copy of a member (16 corresponding lines) (lib/flop.ex)
  • Edited copy of a member (16 corresponding lines) (lib/flop/adapter/ecto.ex)
  • Edited copy of a member (5 corresponding lines) (lib/flop/adapter/ecto.ex)
  • Edited copy of a member (9 corresponding lines) (lib/flop.ex)
  • Medium CVE: EEF-[CVE redacted] (mix.lock)
  • Outdated: ex_doc
  • Outdated: nimble_options

Changes since last survey

  • 2 commits — 2 feature/other, 0 fixes

By area

  • (root) — 2 commits

Notable commits

  • change: Update dependency dialyxir to v1.4.8 (#740)
  • change: Update dependency ex_doc to v0.40.4 (#741)

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

Survey your own repository

woylie/flop 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 165ec7c01d01793c354122af6b0981a5d64cadc8 — 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.