{
  "name": "pg_trickle",
  "abstract": "pg_trickle turns PostgreSQL 18 into a real-time data platform. Define stream tables on top of any base table and let the extension maintain materialized views incrementally — keeping only the delta in flight rather than recomputing the full result set. Built on a trigger-based CDC pipeline and a differential dataflow engine written in Rust, pg_trickle delivers sub-millisecond propagation latency with no external dependencies, no message broker, and no ETL pipeline. Your views stay fresh, your queries stay fast, and your data never leaves the database.",
  "version": "0.87.11",
  "maintainer": "pg_trickle contributors",
  "license": "apache_2_0",
  "provides": {
    "pg_trickle": {
      "abstract": "Streaming tables with differential (incremental) view maintenance for PostgreSQL 18. Captures row-level changes via after-row triggers, propagates only the delta through a dependency DAG, and applies differential updates to downstream materialized views — all inside a single transaction, with zero external dependencies.",
      "file": "pg_trickle.control",
      "docfile": "doc/pg_trickle.md",
      "version": "0.87.11"
    }
  },
  "prereqs": {
    "runtime": {
      "requires": {
        "PostgreSQL": "18.0.0"
      }
    }
  },
  "resources": {
    "homepage": "https://github.com/trickle-labs/pg-trickle",
    "repository": {
      "url": "https://github.com/trickle-labs/pg-trickle",
      "web": "https://github.com/trickle-labs/pg-trickle",
      "type": "git"
    },
    "bugtracker": {
      "web": "https://github.com/trickle-labs/pg-trickle/issues"
    }
  },
  "tags": [
    "ivm",
    "streaming",
    "materialized view",
    "cdc",
    "rust",
    "differential-dataflow"
  ],
  "no_index": {
    "directory": [
      "blog",
      "roadmap",
      "plans",
      "demo",
      "monitoring",
      "playground",
      "pgtrickle-relay",
      "dbt-pgtrickle",
      "benches",
      "fuzz",
      "examples",
      "tests",
      "cnpg",
      "docker",
      "scripts",
      "docs",
      "src",
      "sql",
      "proptest-regressions"
    ],
    "file": [
      "test_output.txt",
      "staged_files.txt",
      "AGENTS.md",
      "ESSENCE.md",
      "CONTRIBUTING.md",
      "SECURITY.md",
      "CHANGELOG.md",
      "ROADMAP.md",
      "INSTALL.md"
    ]
  },
  "release_status": "stable",
  "generated_by": "pg_trickle contributors",
  "meta-spec": {
    "version": "1.0.0",
    "url": "https://pgxn.org/meta/spec.txt"
  }
}
