First update on the big new project in english. This is my vision of a database system that I have been planning and developing for a long time. It is based on a relational database with its own twist. The idea came from hobbies many years ago when I was looking for a ready-made database of this kind to replace the currently used Access database. The most important feature would be the ability to use the software in a browser on many different devices and to import data, for example, through an API interface.
Creating Identifiers:
The biggest feature is the unique way of creating identifiers. In this system, you can use the database at many levels and create tables, forms, reports, etc. Each table row/record identifier first gets the database level number (0-9), followed by the table's own unique three-digit number. This three-digit number is formed as follows: 1. block, 2. group, 3. class, which can be named separately as a whole.
After this, each row gets its own unique identifier, which is a sequentially increasing number starting from one or alternatively a randomly generated number.
After this, each row gets its own unique identifier, which is a sequentially increasing number starting from one or alternatively a randomly generated number.
Using Tables:
Tables, like relational databases, are highly customizable. However, the system requires a few predefined tables to function, the most important of which are the product database, the so-called dump code table, and log files.
The database tables can be used and modified through the system like in a spreadsheet application or through forms. Data can also be imported into the database from external sources.
The biggest note on using the table is that rows are not deleted even if the product is out of stock, out of use, or broken. Instead, they are archived by making them inactive, so they are no longer considered with other active data.
Development:
 |
| (Idea for home screen) |
The implementation is more demanding than this idea. Soon, I will publish a non-functional example of what the database might look like in a browser, and I will try to publish functional tests separately, for example, in Python. PTB Database?
The goal, although far in the future, would be to get this idea to work together with a ready-made SQL database base, with basic settings ready.
 |
| (Idea for smartphone view) |
1025.022508.1020.1.1
