Skip to content

FormuviaBuild business applications on PostgreSQL

Model your data, lay out its forms, add procedures and triggers of the database, make reports, leave routine work to scheduled jobs and start them from other systems through webhooks — all from inside the application.

What Formuvia is ​

Formuvia is a platform for business applications over a PostgreSQL database, shaped from inside the application itself.

You describe what you need — a menu, a table, the fields on its form — and Formuvia creates the table in the database: the columns, the foreign keys, the constraints. There is no migration script to write and nothing to redeploy. A table added in the Model exists in the database the moment you save it, appears in the menu and opens as a list with its form.

The rules of the business stay where the data is. A field can take its value from a function of the database while a record is being entered, a procedure can be run over a record from its menu, and a trigger runs on every write without anyone asking for it.

On top of the data sit the reports — queries, procedures and Jasper reports, with parameters — and the jobs that run them on a timetable: a report goes out by mail or into a file, filled-in Excel templates are imported from a folder, and another system can start any job through a webhook.

Around all of that sits everything a business application needs anyway: accounts and roles, a record of every change, filtering, sorting and totals done on the server, and an Excel export of whatever you are looking at.

Who this guide is for ​

Where Formuvia is today ​

Formuvia is still being built, and this guide describes what actually works rather than what is planned. Where something can already be defined but does not take effect yet, the page says so in a box headed What is in effect today.

Before you start ​

You need an address where Formuvia is running and an account. The very first account is admin, created when the system is first started — whoever installed Formuvia set its password.

Installing and deploying Formuvia is described in the repositories themselves: FormuviaFront for the web client and Formuvia for the server.