PHPackages                             martin3r/platform-datawarehouse - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [Database & ORM](/categories/database)
4. /
5. martin3r/platform-datawarehouse

ActiveLibrary[Database & ORM](/categories/database)

martin3r/platform-datawarehouse
===============================

Datawarehouse Module for Platform - Collects, stores, and serves data from various sources

083↓100%PHP

Since May 27Pushed 1w agoCompare

[ Source](https://github.com/martin3r-me/platform-datawarehouse)[ Packagist](https://packagist.org/packages/martin3r/platform-datawarehouse)[ RSS](/packages/martin3r-platform-datawarehouse/feed)WikiDiscussions main Synced 1w ago

READMEChangelogDependenciesVersions (1)Used By (0)

Datawarehouse Module
====================

[](#datawarehouse-module)

Systematisches Einsammeln, Speichern und Bereitstellen von Daten aus verschiedenen Quellen.

Features
--------

[](#features)

- **Datenströme (Streams)**: Konfigurierbare Datenquellen mit Schema-Definition
- **Dynamische Tabellen**: Automatisch erstellte Tabellen basierend auf Spaltendefinitionen
- **Webhook-Ingest**: POST-Endpoint mit Token-basierter Authentifizierung
- **Import-Modi**: Snapshot (Truncate+Insert), Append, Upsert
- **Schema-Audit**: Lückenlose Dokumentation aller Schema-Änderungen
- **Import-Log**: Statistiken zu jedem Import (Zeilen, Fehler, Dauer)

Struktur
--------

[](#struktur)

```
datawarehouse/
├── config/datawarehouse.php
├── database/migrations/
│   ├── ...create_datawarehouse_streams_table.php
│   ├── ...create_datawarehouse_stream_columns_table.php
│   ├── ...create_datawarehouse_imports_table.php
│   └── ...create_datawarehouse_schema_migrations_table.php
├── routes/
│   ├── web.php         # Dashboard (auth)
│   └── api.php         # Webhook-Ingest (token)
└── src/
    ├── DatawarehouseServiceProvider.php
    ├── Http/Controllers/IngestController.php
    ├── Livewire/Dashboard.php, Sidebar.php
    ├── Models/
    │   ├── DatawarehouseStream.php
    │   ├── DatawarehouseStreamColumn.php
    │   ├── DatawarehouseImport.php
    │   └── DatawarehouseSchemaMigration.php
    └── Services/
        ├── StreamSchemaService.php
        └── StreamImportService.php

```

Webhook-Endpoint
----------------

[](#webhook-endpoint)

```
POST /api/datawarehouse/ingest/{endpoint_token}
Content-Type: application/json

[
  {"field1": "value1", "field2": 42},
  {"field1": "value2", "field2": 99}
]

```

Response:

```
{
  "import_id": 1,
  "status": "success",
  "rows_received": 2,
  "rows_imported": 2,
  "rows_skipped": 0,
  "duration_ms": 45,
  "errors": null
}
```

Import-Modi
-----------

[](#import-modi)

- **snapshot**: Löscht alle Daten der Tabelle und fügt neue ein (Truncate + Insert)
- **append**: Fügt neue Zeilen hinzu
- **upsert**: Insert oder Update basierend auf `upsert_key`

Dynamische Tabellen
-------------------

[](#dynamische-tabellen)

Tabellennamen: `dw_{stream_id}_{slug}`

Jede dynamische Tabelle hat automatisch:

- `id` (PK)
- `import_id` (Referenz zum Import)
- `imported_at` (Zeitstempel)
- Konfigurierte Spalten aus `datawarehouse_stream_columns`
- `created_at`, `updated_at`

###  Health Score

24

—

LowBetter than 31% of packages

Maintenance64

Regular maintenance activity

Popularity12

Limited adoption so far

Community8

Small or concentrated contributor base

Maturity11

Early-stage or recently created project

 Bus Factor1

Top contributor holds 82% of commits — single point of failure

How is this calculated?**Maintenance (25%)** — Last commit recency, latest release date, and issue-to-star ratio. Uses a 2-year decay window.

**Popularity (30%)** — Total and monthly downloads, GitHub stars, and forks. Logarithmic scaling prevents top-heavy scores.

**Community (15%)** — Contributors, dependents, forks, watchers, and maintainers. Measures real ecosystem engagement.

**Maturity (30%)** — Project age, version count, PHP version support, and release stability.

### Community

Maintainers

![](https://www.gravatar.com/avatar/624263472b888cbddf2459047c1ab71dafd2a5875da576e3675b9c3584dad922?d=identicon)[martin3r](/maintainers/martin3r)

---

Top Contributors

[![martin3r-me](https://avatars.githubusercontent.com/u/187852765?v=4)](https://github.com/martin3r-me "martin3r-me (50 commits)")[![cwolf-bhgdigital](https://avatars.githubusercontent.com/u/243578275?v=4)](https://github.com/cwolf-bhgdigital "cwolf-bhgdigital (11 commits)")

### Embed Badge

![Health badge](/badges/martin3r-platform-datawarehouse/health.svg)

```
[![Health](https://phpackages.com/badges/martin3r-platform-datawarehouse/health.svg)](https://phpackages.com/packages/martin3r-platform-datawarehouse)
```

###  Alternatives

[jdorn/sql-formatter

a PHP SQL highlighting library

3.9k116.5M113](/packages/jdorn-sql-formatter)[propel/propel1

Propel is an open-source Object-Relational Mapping (ORM) for PHP5.

8361.6M87](/packages/propel-propel1)[mpociot/laravel-composite-key

Support composite keys in your laravel app.

3544.8k1](/packages/mpociot-laravel-composite-key)

PHPackages © 2026

[Directory](/)[Categories](/categories)[Trending](/trending)[Changelog](/changelog)[Analyze](/analyze)