Totum MIT is a free, MIT-licensed, self-hosted database application platform written in PHP and built on PostgreSQL, which lets non-programmers assemble internal business tools such as CRM, ERP, order management, and accounting by writing a few lines of its own small-code language, totum code, instead of SQL or hand-built application code.

What it is

Totum MIT is described in its own repository as a hybrid of a database and a spreadsheet. It ships a ready-made frontend for desktops and mobile devices, so both development and day-to-day operation happen in one browser environment. Tables, fields, and their settings are created and managed with the mouse, and the developer can instantly hide the developer UI elements to see how the solution looks to an end user, or switch to a specific user and perform an action as that user. The product is written in PHP and stores its data in PostgreSQL, and its internal logic is programmed in totum code.

The concrete problem it solves is the gap between a database engine and a finished internal tool. A Totum developer does not need to know SQL, because calling and writing data is also managed by totum code, and the codes in most fields stay small, typically up to five to ten lines. Instead of assembling a schema, an admin interface, and business logic by hand, a user works through the sections Data, Processing, Actions, Exchange, Reports, Accesses, and Logs within a single browser-based system. That places the project in the low-code and internal-apps ecosystem, with the repository tagged for low-code, low-code-development-platform, internal-apps, small-code, erp, and erp-framework; it replaces the custom application code and raw SQL normally required to turn a relational database into an operational business tool.

Key capabilities

• Logic is written in totum code, with codes separated by action type: one type calculates a value similar to an Excel formula, another follows changes and executes actions, and a third controls appearance depending on conditions.
• The editing environment provides highlighting, searching, and substitution of table and field addresses, variables, and functions, and autofills parameters.
• Ready-made field elements include strings, numbers, checkboxes, buttons, dropdown lists, trees, dates, charts, and files, with file fields available in PRO.
• Access control is two-level, separating developers from users, and a developer can preview the solution as any specific user.
• Actions line up in chains, and if a cancellation or error occurs while a chain is in progress, the transaction rolls back atomically, so concurrent access does not corrupt state.
• The built-in sections Data, Processing, Actions, Exchange, Reports, Accesses, and Logs cover storage, manipulation, integration, reporting, permissions, and auditing without additional components.
• An API is available only in the PRO version, and the interface is available in EN, RU, ES, and DE.

Who uses it and how

• Operations teams build production management, order management, stock, and equipment inventory tools in one place.
• Finance and public-sector style bookkeeping work is supported, including financial accounting and cadastre accounting.
• CRM is a stated use case, matching the repository's crm-platform topic and the order and customer data such tools hold.
• Small teams fit the two-level developer-user access model; the install script also offers a free PRO license for two additional users.
• Newcomers follow the documentation and the free training course, which targets a first working table in 30 minutes, with community discussion hosted in the totum-ru-issues-and-discussions repository.

Getting started

The README documents a one-click native install on Ubuntu 24.04, marked for clean systems only, run as sudo curl -O https://raw.githubusercontent.com/totumonline/totum-mit/master/totum/moduls/install/totum_autoinstall.sh && sudo bash totum_autoinstall.sh. That command installs both the MIT and PRO versions, and the PRO version works without a license when only the Admin user is present; a free PRO license covers two additional users.

How it compares

No list of paid or competing products is provided in the facts, and no similar tools are named, so this project stands alone in this registry on that axis. The only product relationship stated in the README is that this is the free version of Totum PRO, which is the same codebase with the API, file fields, and additional user seats gated. Both are self-hosted on the user's own server, with no hosted or per-seat cloud option described.

When to use it — and when not to

A self-hoster must supply a clean Ubuntu 24.04 server and run the install script as root, which means the one-click path will not help anyone already running a populated machine or a different distribution. Teams that need the API for integration work, file fields, or more than two extra users must move to Totum PRO rather than the MIT build. The README is written as a promotional introduction with installation instructions rather than a full operations manual, so buyers should treat the linked documentation and training course as required reading before committing.

sudo curl -O https://raw.githubusercontent.com/totumonline/totum-mit/master/totum/moduls/install/totum_autoinstall.sh && sudo bash totum_autoinstall.sh

// Example of calculating value code

= : listSum(list: $list) + #fixed_costs

list: selectList(table: 'orders'; field: 'cost'; where: 'number' = $listNumbers)

listNumbers: selectList(table: 'orders'; field: 'number'; where: 'date' >= #first_day_months; where: 'orderStatus' = #final_status)