Download the PHP package th3mouk/materialized-view without Composer
On this page you can find all versions of the php package th3mouk/materialized-view. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Download th3mouk/materialized-view
More information about th3mouk/materialized-view
Files in th3mouk/materialized-view
Package materialized-view
Short Description Declarative, PostgreSQL-native management of materialized views: define views as versioned SQL, synchronise, rebuild, refresh (concurrently) and read them safely. Runs on Doctrine DBAL or a bare PDO connection.
License Apache-2.0
FAQ
Example:
In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
- Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
- To use Composer is sometimes complicated. Especially for beginners.
- Composer needs much resources. Sometimes they are not available on a simple webspace.
- If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
- Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Informations about the package materialized-view
th3mouk/materialized-view
Declarative, PostgreSQL-native management of materialized views on top of Doctrine DBAL.
Define a materialized view once, as a versioned .sql file plus a small PHP definition, and let the library create it, detect drift, rebuild it safely, refresh it (including CONCURRENTLY), and let your app read it without surprises. No ORM owns the DDL; PostgreSQL stays the source of truth for the physical object.
This is the framework-agnostic core (depends only on doctrine/dbal). For Symfony — autoconfiguration, console commands, the locked deploy lane and async refresh — use th3mouk/materialized-view-bundle.
Why this library exists
A materialized view is a physical PostgreSQL object with its own lifecycle: CREATE MATERIALIZED VIEW … AS …, REFRESH MATERIALIZED VIEW [CONCURRENTLY], no CREATE OR REPLACE, destructive redefinition, unique-index preconditions for concurrent refresh, dependency ordering. Doctrine ORM can read the rows as a read-only projection, but it cannot express any of that — and at the time of writing no maintained, framework-agnostic PHP library manages PostgreSQL materialized views. This library fills that gap, DBAL-first.
See docs/internals/design-rationale.md for the full reasoning and the competitive landscape.
Highlights
- Declarative: SQL lives in
db/matviews/*.sql; a tiny PHP class declares name, indexes, rebuild & population policy. - Drift detection via a canonical hash stored in
COMMENT ON MATERIALIZED VIEW(travels with database clones). - Safe rebuilds:
drop_createand a low-lockside_by_sidestrategy, with index and GRANT re-application. - Refresh runtime:
CONCURRENTLYwith precondition validation, primary/replica awareness,lock_timeout/statement_timeout, advisory locks,ANALYZE. - Catalog-derived dependency ordering (
pg_depend/pg_rewrite) — no hand-maintained graph, no drift. - Read-only ORM mapping (optional) with a write guard and an unpopulated-read readiness guard.
Installation
Requirements: PHP ≥ 8.4, Doctrine DBAL ≥ 4.4, PostgreSQL (12+; tested against 17). The optional ORM layer requires doctrine/orm ≥ 3.6.
60-second example (framework-agnostic)
Given a base table orders (id bigint, category text, amount numeric, created_at timestamptz):
db/matviews/sales_by_category.sql
Documentation
| Tier | Audience | Start here |
|---|---|---|
| Getting started | Users — set it up fast | docs/getting-started.md |
| Guide | Users — advanced concepts | docs/guide/ |
| Internals | Maintainers — design & upstream references | docs/internals/ |
A full table of contents is in docs/README.md.
Compatibility
| This library | PHP | Doctrine DBAL | Doctrine ORM (optional) | PostgreSQL |
|---|---|---|---|---|
^1.0 |
≥ 8.4 | ^4.4 | ^3.6 | 12 – 17 |
We track DBAL major versions deliberately and do not pin a tight upper bound that would strand the library (see docs/internals/compatibility-and-evolution.md).
License
NOTICE.
If you use or redistribute this package, keep the NOTICE attribution —
crediting Jérémy Marodon (th3mouk) and naming this library in your product's
documentation or credits. Please contribute upstream rather than
maintaining a public fork.
