Totum

Open source

Self-hosted database and spreadsheet hybrid with its own small scripting language for building internal business tools without heavy programming.

GitHub stars
981
Last 30 days
+1(+0%)
Last commit
5 mo ago
Repository age
7 years
Version
7.17.63.0
Licence
MIT
Self-hosted
Yes

About Totum

Totum is a self-hosted platform that combines a database with spreadsheet-like tables. The repository holds the free MIT-licensed community edition of Totum PRO. It comes with a ready-made front end for desktop and mobile, so tables, fields and their settings are created in a browser with the mouse.

Logic is written in Totum code, a small language that lets non-programmers build solutions without knowing SQL. Most codes run to five or ten lines. Some calculate a field value like an Excel formula, others react to changes and run actions, and a third kind controls appearance depending on conditions. Actions are grouped into chains, so an error cancels the whole chain, and concurrent edits to the same table restart the later action.

The README lists example solutions such as production management, cadastre and financial accounting, order management, stocks, CRM and equipment inventory. Access is two-level, split between developer and user, with logging and access rules. Data can be exchanged over an API using JSON via POST, and code can call third-party servers; the API is flagged as PRO only.

Installation is a one-command script on a clean Ubuntu 24.04 system. The PRO version works without a licence when only the Admin user exists, and a free licence for two additional users is available.

Key features

  • Database and spreadsheet hybrid with ready front end
  • Own scripting language called totum code
  • Developers need not know SQL
  • Tables and fields built in the browser with the mouse
  • Actions run in chains that cancel as a whole on error
  • Field types including strings, numbers, dates, trees and charts
  • JSON over POST for data exchange with other systems
  • One-command install on Ubuntu 24.04

Good fit for

  • Order management
  • CRM
  • Stock and equipment inventory
  • Financial and production accounting
Tags
low-code
database
internal-tools
self-hosted
php
postgresql
crm
erp

Totum: questions and answers

What is Totum used for?
Totum is a self-hosted database and spreadsheet hybrid with its own small scripting language for building internal business tools without heavy programming. It is a good fit for order management, CRM, and stock and equipment inventory.
Is Totum open source?
Yes. Totum is open source under the MIT licence. Its source code is on GitHub at totumonline/totum-mit and is written mainly in PHP.
Is Totum free?
Yes. Totum is open source, so the software itself is free to use.
Can I self-host Totum?
Yes. Totum can be self-hosted on your own server or infrastructure.
What is Totum an alternative to?
Totum is an open-source alternative to Airtable, SmartSuite, Ninox and Quickbase. Other open-source alternatives to Airtable include Budibase and Baserow.
Is Totum actively maintained?
No. The GitHub repository for Totum has been archived by its owner, which makes it read-only. The project has 981 stars on GitHub, with 1 added in the last 30 days.

Open-source alternatives to Totum

See all

SaaS alternatives to Totum

See all