Home › Technology

Technology

Enterprise-grade, on open source

EasyDairyERP is built on PostgreSQL, PHP, FastAPI, Python and Flutter. The database is open source, with no vendor lock-in, no database licence fee and a free major upgrade every year.

In short

What is EasyDairyERP built on?

EasyDairyERP stores every record in PostgreSQL, the open-source relational database developed by a global community for nearly 30 years. The business logic runs on PHP and Python (FastAPI), and the Android and iOS apps are built with Flutter. Every client runs on their own dedicated server, on AWS, Google Cloud, or a custom or on-premise server of the client’s choice, with database backups kept in S3 buckets leased to the client.

The EasyDairyERP technology stack
The EasyDairyERP technology stack
The stack

The technology, layer by layer

PostgreSQL

The database. Open source under the PostgreSQL Licence, with a new major version every year.

PHP

The web application your teams use every day for every module.

Python and FastAPI

Fast APIs for the apps, devices and integrations, and the base for AI features.

Flutter

One code base for the EasyDairyERP app on Android phones, iPhone and iPad.

Dedicated server, your choice

Every client runs on their own server: on AWS, Google Cloud, or a custom or on-premise server of your choice.

Backups in your S3 buckets

Database backups are kept in S3 buckets leased to you.

Why PostgreSQL

Why we chose an open-source database

PostgreSQL is released under the PostgreSQL Licence, a liberal open-source licence. It offers enterprise features such as partitioning, replication and row-level security, and it can be used for any purpose. Unlike the proprietary databases sold by large corporations, PostgreSQL has no licence fee and no vendor lock-in.

No vendor lock-in. The PostgreSQL Licence lets anyone use, copy, modify and distribute the software for any purpose, without fee. The project has said it will stay free and open source in perpetuity. Your data sits in a standard database that many vendors, tools and cloud providers support.

No database licence cost. There is no per-core, per-user or per-memory database licence to buy or renew, so adding users, plants or servers never brings a database licence bill.

Free upgrades of the core database, every year. A new major version with new features arrives about once a year, and minor releases with bug and security fixes come at least every three months. Each major version is supported for five years. All of it is free. EasyDairyERP runs on PostgreSQL 15.4 in production.

Available in the cloud. Amazon Web Services and Google Cloud, among other cloud providers, offer managed PostgreSQL, and it also runs on your own servers.

At a glance

PostgreSQL at a glance

PostgreSQL
LicencePostgreSQL Licence, a liberal open-source licence: use, copy, modify and distribute for any purpose, without fee
Source codeOpen source, developed by the PostgreSQL Global Development Group
UpgradesA new major version about once a year; minor releases with fixes at least every three months; each major version supported for five years
ExtensionsAn open ecosystem, including PostGIS, Citus and pg_stat_statements
Cloud availabilityManaged services from cloud providers including Amazon Web Services and Google Cloud; also runs on your own servers

Based on the PostgreSQL project’s published licence and versioning policy, and cloud providers’ own pages, as of October 2026.

Tooling and extensions

Enterprise features, built in or added as extensions

PostgreSQL includes these features in the core database, and its open extension ecosystem adds more. PostgreSQL 18, released in September 2025, added asynchronous I/O, faster major-version upgrades and OAuth 2.0 sign-in. The cards below are PostgreSQL features.

PostgreSQL offers the enterprise features businesses expect from large proprietary databases: partitioning, replication, high availability, row-level security, JSON support and more.

In EasyDairyERP: we use PostGIS for location data, and PostgreSQL backup strategies to protect every client’s database.

Declarative partitioning

Split very large tables, such as years of milk collection, into partitions the database manages for you.

Parallel query

Large reports can use several CPU cores at once.

Row-level security

Policies in the database decide which rows each user can see or change.

JSONB

Store and index flexible JSON data next to regular tables.

Streaming replication

Keep standby servers in step with the primary for high availability.

Logical replication

Copy selected tables to another server, for reporting or upgrades.

pg_stat_statements

Track the time every query takes, to find what to tune.

pgAdmin

A free, open-source tool to manage and query PostgreSQL.

PostGIS

Adds maps and location data: routes, centres, distances.

Citus

Distributes PostgreSQL across many servers (sharding) as an extension.

Python and AI

Python makes AI part of the ERP

EasyDairyERP’s services are written in Python with FastAPI. Python is widely used for AI and machine learning, with open-source libraries such as scikit-learn and PyTorch.

Because the ERP already speaks Python, new AI features can be built into it directly, working on the same data in PostgreSQL.

EasyDairyERP already uses Python for analytics and AI assistance inside the ERP, and new AI features are being added on the same foundation.

Coming soon

AI-based invoice processing

Coming in December 2026. We are building AI-based invoice processing into EasyDairyERP, so that invoices can be read by AI instead of keyed in by hand. It is not live yet. Ask us about it when you book a demo.

What it means for you

Enterprise-grade, at an affordable price

EasyDairyERP is built on an open-source database, so there is no database licence in the price. What you pay for is the ERP itself and the dairy-specific work it does.

  • No database licence fee, and no per-employee, per-customer or per-centre charges
  • New features and reports every month, at no extra update charge
  • Your own dedicated server, on AWS, Google Cloud or a server of your choice, with backups in your own S3 buckets
  • A standard, open database: no lock-in to one vendor
FAQ

Frequently asked questions

PostgreSQL, the open-source relational database released under the PostgreSQL Licence.

No. The PostgreSQL Licence allows use for any purpose without fee.

Yes. A new major version comes about once a year and minor releases with fixes at least every three months, all free. Each major version is supported for five years.

Yes. It offers declarative partitioning, parallel query, replication, and extensions such as Citus for distributing data across servers.

Not yet. It is coming in December 2026. Ask us for the latest when you book a demo.

Related

See it in context

PostgreSQL is a trademark of the PostgreSQL Community Association of Canada; other names belong to their owners.

See it live

We walk you through EasyDairyERP on sample data, step by step. Call +91 94880 59495 or write to info@easybis.in.