Skip to main content
Mehdi Cheniki's avatar head

Mehdi Cheniki

Back to projects
Independent projectFull-stack development2026

EcoKwa

An application for easily searching and visualising French public data from several official organisations.

  • Laravel
  • React
  • TypeScript
  • PostgreSQL
Open the application
EcoKwa home page with search and an inflation indicator

Starting point

Making public data easier to consult

French public data is plentiful and reliable, but spread across different organisations, formats and specialist terminology. EcoKwa provides a simpler entry point for finding an indicator, understanding what it represents and following its evolution.

Design challenges

  • Bringing sources with different formats into a common model while retaining their origin and methodology.
  • Keeping data up to date despite import failures, without creating duplicates on reruns.
  • Making data readable without losing its context: source, methodology, provisional or revised statuses, and the difference between a missing value and zero.

Architecture choices

Unifying sources, making imports dependable, preserving context

01

Dedicated importers

Data arrives through paginated JSON APIs and Excel files. Dedicated importers validate responses, normalise periods and update existing observations.

02

Background processing with recovery

Imports run in the background, distinguish temporary from permanent failures and retry progressively. Locks and an execution history complete the process.

03

Context preserved

The source, methodology and statuses remain visible. A missing value is never replaced with zero, and charts have a tabular alternative.

In pictures

Inflation evolution chart on an EcoKwa indicator page
An indicator page brings together its latest value, evolution, origin and official source.

Technologies

Technical foundation

  • LaravelLaravel
  • ReactReact
  • TypeScriptTypeScript
  • PostgreSQLPostgreSQL
  • DockerDocker

Inertia.js · Tailwind CSS · Laravel Queues & Scheduler · Pest · Vitest · Inertia SSR · GitLab CI/CD · Coolify

Try the application

Explore the data in EcoKwa

The application is live: search for an indicator and read its methodology.