Datro

PostgreSQL — the system of record for our PWAs

PostgreSQL is the database behind the operational PWAs Datro builds and hosts, including Mountain Ridge Wines.

PostgreSQL Database PWA
October 12, 2026

PostgreSQL is the system of record for the operational PWAs we run. The screens and the API change. The figures for a harvest, a budget, or an invoice stay here.

Where it shows up

  • Mountain Ridge Wines: pooling, vintage, harvest, budgeting, and invoicing share one database, so the close is not a merge of spreadsheets.
  • The hosted service: the database runs with the app, on the managed server, with backups as part of the retainer.
  • A boundary with SAP: on consulting work the ERP stays the client’s system. On a PWA we build, PostgreSQL is ours to run.

Why PostgreSQL

  • Transactions, so a half-saved invoice is not a state the business can reach
  • One database the FastAPI service and the SvelteKit app can both rely on
  • Straightforward to operate under Docker, next to the rest of the stack

See SvelteKit and FastAPI.

Explore Our Technology Stack

Docker — how we ship the systems we run

Docker is how Datro runs the SvelteKit app, the FastAPI service, and PostgreSQL on a managed VPS.

Docker Hosting

FastAPI — typed APIs behind the PWAs

FastAPI is the Python API behind the operational PWAs Datro builds and hosts, including Mountain Ridge Wines.

Python API

SvelteKit — the PWA layer we ship

SvelteKit is the front end of the operational PWAs Datro builds and hosts, including the Mountain Ridge Wines harvest and pooling app.

SvelteKit PWA

Client work

Mountain Ridge Wines

A custom PWA for pooling, vintage and harvest logic, budgeting, and commercial invoicing in one place, on desktop and phone.

Want something like this?

Tell us about the process that is stuck. We will tell you if we are the right fit.

Get in touch