FODB – Features & Benefits

• Easy installation – no configuration files, no setup, no dependencies.

• All syntax examples fit on 2–3 pages.

• Extremely performant, especially with millions of rows.

• Affordable – donate once (min. 20€) for a full version.

• Run and query as many instances as your hardware allows.

• Fully preconfigured – ready to use immediately.

• Only one datatype: VARCHAR.

• All Latin characters allowed (except: #, ', ; — and "," on Linux).

• 20 preconfigured tables (T1–T20) (since the most recent JUN Release amount of tables can be multiplied arbitrary* - Endless amount of tables now possible). see SQL-Examples at in InstallInstructions.php - (*= as far as Hardware,OS, and the datatype Int64 allowes ;) - Release is in final testing)

• Each table has 38 columns (C1–C38).

• Alias names supported for tables and columns.

• Need more tables? Just copy the DB folder — instant expansion.

• Max column length: 65k characters.

• Max row length around: 800k characters.

• Max output length around : 2000k characters.

• Dynamic column selection and dynamic WHERE clauses.

• Native INNER JOIN.

• Aggregation: COUNT, COUNT DISTINCT, ORDER BY.

• Multi‑row SQL execution (batch files).

• Bulk Insert: up to 800,000 rows at once.

• Export SQL statements to file and reload them.

• Three output channels: Console, CSV, GUI.

• Core written in plain C for maximum speed.

• UI written in C#, Java or Tkinter depending on OS.

• No foreign code, no third‑party libraries (except UI frameworks).

• Database size: < 8 MB zipped, < 150 MB unpacked.

• Direct core calls possible for maximum performance.

• Easy migration: copy old data files into new version folder.

• Backup & Restore with one simple command.

• GUI (Windows / Linux)

• Command Line / Terminal

• Direct Core Call (fastest)

Personal Version

• Unlimited queries per minute.

• Unlimited instances on your PC.

• Free to copy within your own system.

• Optional tuning (e.g., larger row/column sizes) available.

Commercial / Company Version

• All personal features included.

• Up to 1000 PCs within one company domain.

• Custom UIs and interfaces available.

Custom Builds

• Special optimized versions available on request.

• Contact via Impressum / Contact form.