Home › Technology
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.
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 database. Open source under the PostgreSQL Licence, with a new major version every year.
The web application your teams use every day for every module.
Fast APIs for the apps, devices and integrations, and the base for AI features.
One code base for the EasyDairyERP app on Android phones, iPhone and iPad.
Every client runs on their own server: on AWS, Google Cloud, or a custom or on-premise server of your choice.
Database backups are kept in S3 buckets leased to you.
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.
| PostgreSQL | |
|---|---|
| Licence | PostgreSQL Licence, a liberal open-source licence: use, copy, modify and distribute for any purpose, without fee |
| Source code | Open source, developed by the PostgreSQL Global Development Group |
| Upgrades | A new major version about once a year; minor releases with fixes at least every three months; each major version supported for five years |
| Extensions | An open ecosystem, including PostGIS, Citus and pg_stat_statements |
| Cloud availability | Managed 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.
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.
Split very large tables, such as years of milk collection, into partitions the database manages for you.
Large reports can use several CPU cores at once.
Policies in the database decide which rows each user can see or change.
Store and index flexible JSON data next to regular tables.
Keep standby servers in step with the primary for high availability.
Copy selected tables to another server, for reporting or upgrades.
Track the time every query takes, to find what to tune.
A free, open-source tool to manage and query PostgreSQL.
Adds maps and location data: routes, centres, distances.
Distributes PostgreSQL across many servers (sharding) as an extension.
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 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.
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.
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.
PostgreSQL is a trademark of the PostgreSQL Community Association of Canada; other names belong to their owners.
We walk you through EasyDairyERP on sample data, step by step. Call +91 94880 59495 or write to info@easybis.in.