Zum Inhalt springen

    Cookie Settings

    We use cookies to provide you with the best possible experience.

    Zum Hauptinhalt springen
    My Green Forest – Investment Platform
    Client ProjectFeatured

    Complex Business Logic

    My Green Forest – Investment Platform

    Complex Business LogicPHP BackendKampagnen-System

    Technical Architecture

    For My Green Forest, we designed and implemented a highly scalable investment platform as custom software. The "10,000 Tree Campaign" is based on an Event-Driven Architecture with asynchronous processing of all transaction and campaign data. The PHP backend uses a Domain-Driven Design with clearly separated Bounded Contexts for campaign management, referral tracking, and payment processing. The multi-tenant architecture allows for the parallel management of multiple campaigns with isolated data spaces, while a central API gateway orchestrates all microservice communication. The frontend was implemented as a Progressive Web App with latency-free synchronization, allowing investors to track the status of their tree plantings in real time. A multi-level referral system with cryptographically secured tracking codes ensures the complete mapping of referral chains across any number of hierarchy levels.

    Data Integrity & Security

    The platform implements ACID-compliant transaction management, which processes every investment transaction atomically. All personal data is protected according to GDPR with AES-256 encryption at-rest and TLS 1.3 in-transit. A Role-Based Access Control (RBAC) system with granular permission levels controls data access. Automated audit trails log every data change in an audit-proof manner. Payment integration is carried out via PCI-DSS-compliant interfaces with tokenized card processing. Regular penetration tests and automated vulnerability scans continuously secure the system's integrity.

    Scalability

    The system automation of the campaign logic was designed to absorb load peaks through horizontal auto-scaling of worker processes. Connection pooling and query caching at the database level guarantee consistent response times even with high transaction volumes. CDN integration for static assets reduces the Time-to-First-Byte to under 200ms worldwide. This SaaS solution, built to a German Quality Standard, demonstrates how complex business logic can be combined with enterprise-grade reliability—a benchmark for custom software in the investment sector.
    Engineering profile
    Industry
    Sustainability · Reforestation
    Period
    2023 – laufend
    Role
    System architect, platform engineering

    Problem

    Donations, sponsorships and reforestation data lived in disconnected tools. There was no direct loop between donation, planted tree and donor reporting.

    Baseline

    Manual donation tracking, static reports, no donor self-service, no traceable link between income and impact.

    Architecture

    Frontend
    Donor-Facing Site
    Integration
    Donation Webhook (Payment-Provider)
    Backend
    Edge Functions
    Data
    Postgres (Spenden, Projekte, Bäume, Zuordnungen)
    Insight
    Reporting & Dashboards
    Frontend
    Spender-Portal (Patenschafts-View)

    Tech stack

    Runtime
    React 18TypeScriptTanStack Query
    Data
    PostgresRow-Level SecurityRealtime Channels
    AI layer
    Gemini 2.5 für Inhaltsvorschläge
    Infrastructure
    Edge FunctionsStorageWebhook-Bridge

    Solution

    Donation pipeline

    Incoming webhooks are processed idempotently; every donation is mapped to a concrete reforestation project and a tree count.

    Impact reporting

    Donors see in the portal: amount donated, assigned project, planned trees, planting status, field updates.

    Content pipeline

    Structured project updates (text + image) flow through a single editor, are versioned, and are embedded as HTML into donor emails.

    Automation flows

    Trigger
    Donation confirmed (payment webhook)
    Action
    Webhook verification → idempotency check → donation insert → project assignment → tree reservation → confirmation email with sponsorship link
    Result
    End-to-end traceability from income to planting in one pipeline
    Trigger
    Project update published
    Action
    Update insert → select donors per project → batched HTML email (hosted images, tracked)
    Result
    Donors get relevant, project-specific updates without manual work

    APIs & integrations

    ServicePurposeMethod
    Payment-ProviderDonation webhooksWebhook (HMAC)
    Email-ProviderConfirmations, updates, reportsREST
    StorageProject images, receiptsS3-kompatibel

    Data flow

    Payment webhook → edge function (verify + idempotent) → Postgres (donation, assignment) → realtime to admin → donor email with portal link → portal reads live from Postgres.

    Outcomes & targets

    Strictly separated between verified measurements, declared targets and qualitative observations. No projections, no estimated numbers.

    Measured

    Measurement pending live operation and analysis.

    Targets (planned)
    Donation → confirmation
    Confirmation < 60 s after webhook
    Note: Target for the full pipeline incl. email send.
    Donation → project mapping
    100 % of donations linked to a project
    Note: Target: no donation without a visible impact target.
    Observations
    Donor transparency
    Donors see a project-specific view in the portal: amount, assigned project, planned trees, planting status and field updates.
    Update delivery
    Project-specific updates are sent as batched email with hosted images and tracking to the matching donor list — no manual mail merge.
    Data integrity
    Inbound webhooks are processed idempotently; redundant deliveries do not create duplicate records.

    Outcome

    A previously manual NGO operation became a data-backed platform that ties every individual donation to a planting and gives donors credible, traceable impact.

    Interface view

    Real admin and portal views are shown on request under NDA. Anonymised mockups can be added here via CMS.

    Technical learnings

    Idempotency on payment webhooks is mandatory — providers deliver events multiple times.

    A single dedicated update editor is 10× more valuable than a generic CMS when content ends up in emails.

    Donors trust live data more than annual PDF reports.

    Related Projects