prooph/pdo-snapshot-store
51.4
Adequate · 9 November 2026
330
lines of production code
PHP
primary language
7
measurements over time
What this system is
This system is a PHP library that provides a PDO-based implementation for storing and retrieving event-sourcing snapshots in relational databases. It supports MySQL, MariaDB, and PostgreSQL, allowing users to persist aggregate state with configurable serialization and transaction handling. The library integrates with PSR-11 containers and includes comprehensive test coverage for its core snapshot store functionality.
Features
Added database schema scripts for snapshot tables
New SQL scripts were added to define the structure of the \snapshots\ table for both MySQL and PostgreSQL databases. These scripts establish the table schema, including columns for \aggregate\_id\, \aggregate\_type\, \last\_version\, \created\_at\, and \aggregate\_root\, with \aggregate\_id\ set as the primary key.
scripts · high confidence
New PDO-based snapshot store implementation
The library now includes a concrete \PdoSnapshotStore\ class that persists snapshots to a relational database using PDO. This implementation supports custom table mappings, configurable serialization, and optional transaction handling. It also introduces a new \RuntimeException\ class to wrap PDO error information for better debugging.
src · high confidence
Behavioural changes
Added CI configuration for running PHPUnit tests against multiple database backends
The project now supports automated testing against MariaDB, MySQL, and PostgreSQL. New configuration files in the \.laminas-ci\ directory define database-specific PHPUnit settings for each backend, and a pre-run script dynamically selects the appropriate configuration based on the active database vendor, enabling the CI pipeline to execute tests against all three database types.
.laminas-ci · high confidence
Migrated CI from Travis to GitHub Actions and updated test configuration
The project has replaced the Travis CI configuration with GitHub Actions, introducing a new \.laminas-ci.json\ file to specify required PHP extensions (pdo-mysql, pdo-pgsql) and a \docker-compose-tests.yml\ file to spin up PostgreSQL and MySQL containers for testing. The legacy \.travis.yml\ file has been removed, and \phpunit.xml.dist\ has been simplified to use the default schema, reflecting the shift in the testing and continuous integration infrastructure.
(repo-wide) · high confidence
Updated PdoSnapshotStoreFactory to support PSR-11 containers and configurable serializers
The factory for creating PdoSnapshotStore instances has been updated to accept a PSR-11 ContainerInterface, replacing the previous container abstraction. This change allows users to provide their own serializer instances or service names via the 'serializer' configuration key, offering more flexibility in how snapshot data is serialized. Additionally, the factory now supports disabling transaction handling via a new 'disable\_transaction\_handling' configuration option, giving users more control over database transaction behavior.
src/Container · medium confidence
Test coverage
Added tests for PdoSnapshotStoreFactory; Added tests for the PDO snapshot store.
Dependencies
Update PHP version support and modernize dependencies
The project now requires PHP 7.4 or 8.0, replacing the previous 7.1 constraint. Several dependencies have been updated or replaced: PHPUnit has been upgraded to version 9.5, Prophecy to 1.10.3, and interop-config to 2.0.1. The package name has changed from prooph/event-sourcing to prooph/snapshot-store, and the PSR-11 container interface (psr/container) is now used instead of container-interop. Additionally, the namespace organization has been updated from Prooph\\PDOSnapshotStore to Prooph\\SnapshotStore\\Pdo, and the repository configuration has been simplified.
(dependencies) · medium 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 51 → 51 (+0.0)
- Rubric changed (rubric-2026.10.5 → rubric-2026.11.2) — scores are not directly comparable.
Lenses
- Code Health 71 → 71 (+0.0)
- Architecture 69 → 69 (+0.0)
- Maturity 43 → 43 (+0.0)
- Readiness 47 → 47 (+0.0)
- Security 76 → 76 (+0.0)
Resolved (3)
- Documentation: no installation or build instructions (README.md)
- Documentation: no project overview (README.md)
- Documentation: no usage examples (README.md)
Written by cca.canine.dev from the codebase's own history, inside the signed delivery this page is composed from.
Survey your own repository
prooph/pdo-snapshot-store 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 9 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 bd27746fa0b33af7a98ac89039ae24f310cc1305 — the exact code this score is about.
- Scored under rubric-2026.11.2 — 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.3+preprod-bb0cb800cd0f.