/totum-mit

Business database for non-programmers. Universal UI, simple-code logic, automatic actions, access rules, logging, API and more. Quickly create a complex internal apps using the database as an interface.

Primary LanguagePHPMIT LicenseMIT

If you want russian README — go here: README_RU

>

Site — totum.online

Demo-server — demo.totum.online

>

1-Click Docker install: video on YouTube —>

>

Documentaion — docs.totum.online

Training course — docs.totum.online/training-course 🚀

Telegram tech support — @alexeypolunin

>

Email — totum at totum.online

>

If you have done a project on Totum — tell about it here 🙌

>

>

logo

>

Business database for non-programmers

Universal UI, simple code-based logic, automatic actions, access rights, logging, API and lots of other stuff 👍
For rapid construction of business applications 💪 👀
On your server, easy to learn and scalable with business growth 🎉

>

ico1 ico2 ico3 ico4 ico5 ico6 ico7

>

— Totum — a hybrid of database and spreadsheet.

— Ready-made frontend — for desktops and mobile devices.

— Small-code — simple syntax that is easy to learn.

— Documentation and training course — first working table in 30 min.

— WEB, open-source — is installed on your own server.

— Two-level access — developer-users.

— API — integrate with anything.

>

main

>

>

Using

>

Data ⟶ Processing ⟶ Actions ⟶ Exchange ⟶ Reports ⟶ Accesses ⟶ Logs

>

  • Production management

  • Cadastre accounting

  • Collecting data from sensors

  • Financial accounting

  • Order management

  • Stocks

  • Backends for an online shop

  • Services accounting

  • CRM

  • Contract shipments

  • Fitness management

  • Lease accounting

  • Equipment inventory

  • Transferring accounting from Excel

  • Purchasing optimisation

  • Printing industries

  • Pototyping apps

  • ...

  • See people's completed projects — in this section of the GitHub forum 🙌

>

Using

>

>

All you need is a browser

Development and operation are in the same environment.

Tables, fields and their settings are created and managed with the mouse.

The developer can instantly hide the developer UI elements to see what the solution looks like for the user or switch to a specific user and perform an action from that user.

>

uniform interface

>

>

Program the logic with simple codes

Totum is written in PHP but is internally programming with its own language — totum code.

This makes development on Totum possible for non-programmers.

A Totum developer does not need to know SQL — calling and writing data to database is also managed by totum code.

In most fields, the codes are small — up to 5-10 lines.

Totum provides highlighting, searching and substitution of table and field addresses, variables and functions, and autofills parameters.

Codes are linked to fields and separated by action types:

— ones calculate the value similar to the formulas in Excel.

— others, follow the changes and execute the actions.

— the third type is responsible for appearance depending on conditions.

>

// 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)

>

You can implement complex logic, even with the lowest programming skills. You will be able to understand it with — the free training course, forum and technical support on Telegram 👌

>

>

Database as interface - x10 to development speed 🏃💨

Use a variety of ready-made elements:

  • Strings
  • Numbers
  • Checkboxes
  • Buttons
  • Dropdown lists
  • Trees
  • Dates
  • Files
  • Charts

>

numbers

>

>

Adaptivity

Use a single adaptability setting for desktop and mobile devices.

You don't need to know CSS/GRID/FLEX to make a clear, adaptive interface on Totum.

One function and several parameters provide a huge range of options.

Your solution will look neat on all screen widths.

img

>

>

Special views

After a little customisation, tables can be automatically presented in more than just cells!

Kanban

kanban

>

Trees

trees

>

>

And a few more details... 👀

Don't worry about concurrent access — transactions are atomic

All actions line up in chains: if a cancellation or error occurs while the chain is in progress — the whole chain will be cancelled.

You can work in parallel: if two users make a changes to the same table at the same time, the action saved by the second one will automatically restart.

>

Refine directly in the running project

With PHP-base, your development error will not crash the server, and built-in debugging and testing tools help you make changes to running projects on the fly.

>

Print by html templates, export/import to .csv

Just don't waste your time on it, that's all...

>

API, for any interaction

Open and customisable API allows data to be exchanged with any system for both input and output.

Exchange data with Totum via POST in JSON format.

Call to a third-party server directly from totum-code.

Write your own microservice on totum-code responding to GET/POST requests.

You will be able to write integrations with the website, bank, messengers and any other services working in web.

>

>

Perks 📣

>

Free

The Community version of Totum is distributed under an MIT-licence. Free for any type of use!

>

All information can be located in the company's secure network

Totum is self hosted. You can set up any access policies for the server you manage yourself.

You also control what can be transmitted outside of this contour and what cannot.

Therefore, Totum can be used to automate the work of individual units, and especially effectively as pilot prototypes!

>

A copy of Totum will stay with you forever

You make a full copy of all platform scripts to your own server — you are not dependent on the availability of the developers servers, and you can modify the platform code as needed.

>

Totum is scalable

In the event of dramatic success and large-scale growth of your database, the Totum solution will stand up to the load.

Even if some elements of the solution turn out to be designed for a lower load — you can modify them without rewriting the whole solution.

In addition, the database underlying Totum allows it to be clustered across multiple servers, including in large certified clouds.

>

>

Technical basis (double elefant)

postgres php

  • Open source code in PHP.

  • PostgreSQL database.

  • Installation on your own server. All code is freely modifiable!

  • Easy interaction with other software products via a simple API.

>

For skilled developers:

— the ability to add a custom interface without changing the core of the solution.

— easy ability to connect codes written in any language via SSH.

>

How to try?

Welcome to the demo server — demo.totum.online 🎉

>

Site — totum.online

>

Documentation — docs.totum.online

Training course — docs.totum.online/training-course 🚀

Telegram tech support — @alexeypolunin

>

Email — totum at totum.online

>

If you have done a project on totum — tell about him here 🙌