Skip to content

PostgreSQL

PostgreSQL:
your data in order, for years

PostgreSQL is an open-source database and one of the most common choices for business applications. Choose it when your company’s data should live in one place, consistent and secure, instead of being scattered across spreadsheets, emails and old programs.

Free 30-minute call · We usually get back to you within a few hours on business days

What PostgreSQL is and when to choose it

A database is where an app keeps customers, orders, appointments or documents. PostgreSQL keeps that data consistent: an order can’t be saved without a customer, and a payment can’t be booked twice. It is open source with no licence fees, so you don’t pay per user or per server, and you can move the data to any provider.

What you gain

  • 01

    Everything in one place

    Customers, orders and documents in one database instead of several spreadsheets that need reconciling every week.

  • 02

    Data that stays consistent

    Rules stored in the database itself make sure a wrong or incomplete entry never gets saved.

  • 03

    Reports from real data

    Sales, appointment or cost summaries calculated straight from the database, current the moment you open them.

  • 04

    No licence fees

    An open licence with no per-seat fees. You pay for the server and the work, not for the right to use your own data.

What we do with PostgreSQL

We usually run PostgreSQL through Supabase, which adds login and file storage, and when you need it, we set up the database alone on a server in the EU.

  • 01

    Database design

    • A data model worked out with the people who use it
    • Consistency rules stored in the database
    • Permissions: who sees and changes what
  • 02

    Data migration

    • Import from Excel, Access and old systems
    • Duplicates and errors cleaned up before import
    • A check with you that nothing went missing
  • 03

    Maintenance

    • Backups on EU servers
    • Database changes recorded in the repository
    • Monitoring of slow queries

When PostgreSQL is a good choice

  • Company data spread across many spreadsheets
  • An app with orders, payments or billing
  • Reports you currently put together by hand
  • Replacing an old database or program nobody maintains
  • Full-text search across documents and descriptions

When we’d choose something else

  • A few dozen rows that live happily in a spreadsheet: we don’t build a database just in case
  • Company website content: that lives in Sanity, where you edit it yourself
  • Real-time analysis of huge data volumes: then we add a dedicated analytics tool next to the database

See also: Supabase

PostgreSQL in practice

Apps where tidy data shows in daily work:

Frequently asked questions

How is PostgreSQL different from Supabase?
PostgreSQL is the database itself. Supabase is a service built around PostgreSQL that adds user login, file storage and an admin panel. Underneath, the data sits in the same kind of database, so you lose nothing either way.
Can you move my data from Excel or an old program?
Yes. We first review the data and agree what is a duplicate or an error, then import it and check with you that everything adds up.
Where will my data be stored?
On EU servers, in line with GDPR. Only people who need access to the database get it, and backups run automatically.

Does your data live in several spreadsheets at once?

Tell us what you keep and where. On a call we’ll tell you how to bring it into one database and what that would change in your daily work.

The button opens a short form: a link or a few sentences is enough. We usually get back to you within a few hours on business days and, if a call would help, suggest a free 30 minutes. You get a written quote for the scope before you decide anything.

See custom software

Prefer to ask first? Email one question about PostgreSQL to biuro@epko.tech. We usually get back to you within a few hours on business days.

Data stored on EU servers · GDPR-aligned · WCAG 2.1 AA accessibility · You own the code and the copyright