https://fodb-database.dnsuser.de

The first performant, affordable, and easy to use database for all!

All features and Benefits at a glance:

Deutsche Version (features & benefits): hier klicken

- Extrem performant especially with huge amounts of data.

- Super easy to install - NO CONFIG FILES has to be touched at all.

- Super easy to use: All Syntax examples fit on 2-3 Din - A4 Pages

- Dynamic column and where clause with alias names in all CRUID calls

- Native inner join

- Aggregation functions like Count (Distinct) and Order By

- Database itself is super small (zipped less than 8mb) and can be send via email. (unpacked less than 150Mb)

- ALL LATIN SIGNS AND SPECIAL SIGNS ALLOWED except the "#", the "'", the ";" and in the linux version the "," as well

- Only one datatype to concern about: Varchar

- 3 diffenrent ways of calling the database (GUI / Command Line / Terminal / Direct Core Call) for different performance needs

- Flat and easy to understand calling hierarchy

- Export written statements to file and load them

- BULK INSERT (Selects are queried in bulks if possible anyway) to insert up to 800K rows at a time.

- The database is totally preconfigured

- 20 Tables exist (all datatype VARCHAR) and have INTERNAL NAMES from T1 to T20 (If you need more just copy the whole DB-folder (inclusive FragDieFODB.exe / FODB_ConsoleUbu24 - Datei) and continue using that tables with that FragDieFodb.exe / FODB_ConsoleUbu24 - Datei)

- Each Table has 38 columns (If you need more just continue inserting the column values in the next table but with same PK for later join-selects)

- These columns are internally named from C1 to C38

- You may give these internal names Alias names like "Customers", "Employees" for the tables and "firstname" etc. for the columns, and ofcorse use them in simple queries (CRUID)

- Secure code due the fact that, except standard libraries like stdio.h , string.h and the like - NO FOREIGN CODE and NO THIRD PARTY SOFTWARE/CODE is used (implemented while compiling), except the Microsoft XAML-Definitions for the Windows UI and the Java namespaces for the swing UI in the Ubuntu 20-22 versions, and the tkinter libraries in the Ubuntu 24.04 UI

- Cores are written in plane C to maximize performance, UI in C# or Java to keep the felxibility of 3rd-gen languages.

- Every query causes, depending on the calling level up to 3 outputs that can but not have to be used (Console/Terminal, csv into WDIR (separated by ";" enclosed by "#" (s. Documentation), and / or User-GUI))

- Insert up to 800K rows at once

- Easy data migration to newer versions: Just copy the old data files into the folder of new downloaded and unzipped version to replace them with the datafiles there

- BACKUP AND RESTORE DATABASE WITH ONE SIMPLE COMMAND AND SUPER FAST.

- Multi-row-feature to execute several sql commands inclusive BULK INSERTS in one big SQL-FILE

- Very simple but function UI

- If needed call the FODB from Command Line / Terminal or if even higher perf is needed call the cores direct - s. documentation

- Special versions can be compiled very fast that are tuned reagrding a specific purpose - Fell free to contact me over the email form in the Contact/Impressum section

- New more appealing UI that dynamically adjusts its sizing regarding the users configured screen size

Personal version:

- You may query the DB as often as you want per minute or time interval (as much as your hardware allows) - You may run as much FragDieFodb.exe - instances as you want (you have free theads) - On your whole PC-filesystem you can copy and use the database as often and much you want. (If you move to another PC and / or copy right takes effect please consider another donation of >= 10€ to download a new version) - Max row and column size is 65000 signs (for extra 100 € this can be adjusted / tuned, compiled and send separately as well)

Commercial / Company version:

Same as Personal BUT ADDITIONALLY: - You may copy and use as many instances as you want within your company domain (up to 1000 PCs) - Separate / Custom UIs and interfaces can be ordered for extra 500€

ADDITIONALLY: - Several for specific purposes tuned versions can be ordered as well (for example optimized for max row and/or column length of 4096 - please use the contact formular in the impressum of this webpage if interested)