MUIbase is a relational, programmable database system
with graphical user interface for Windows, Mac, Linux and Amiga.
MUIbase is open source software distributed under the terms of the
GNU General Public License (GPL).
If you like MUIbase and would like to support it then you are welcome to
make a donation. Please visit https://sourceforge.net/projects/muibase
for more information.
MUIbase is well suited for managing structured data with clear semantics
that can be organized into tables and fields. It can be regarded as an
application development environment where an application designer creates
the database structure and user interface, and users of the application
enter and process data on a regular basis.
There are numerous applications for MUIbase including managing addresses,
music and movies, photo collections, your family tree, or your income and
expense. Some users run their entire business using MUIbase from project
planning to creating offers, article and part management, creating bills
and invoices, and tracking their finances.
The strength of MUIbase lies in its graphical user interface and its
programming capabilities. It allows you to process data in various ways,
e.g. automatic calculations upon user input, generation of reports,
import and export of data, etc. For example MUIbase can be used for
calculating the total amount of income, or the total amount of recorded
time on a CD, or to automatically create and print serial letters to
MUIbase offers the following features:
* Graphical user interface for defining the database schema and the graphical
layout for entering and browsing data.
* Admin and user modes.
* Shared access to a project from multiple instances of MUIbase running on
the same or different computers.
* Fields can be of type string, memo (multi line text), integer, real,
date, time, Boolean, choice (one item out of many items), reference
(easy way to reference a record of another table), button (for
starting MUIbase programs), and virtual (compute value on the fly).
* The string type can also manage lists of strings, files, and fonts.
A string can refer to an external image which is displayed in the
graphical user interface.
* Programmability. With the easy and powerful MUIbase programming
language complex tasks can be implemented. The language also
includes a SELECT-FROM-WHERE query for easy and fast data retrieval.
* Ordering of records by any combinations of fields.
* Query editor which allows entering and managing of SELECT-FROM-WHERE
queries. The queries can be saved and the results can be printed.
* Optional logging of changes (adding, deleting and changing of records)
into a system log table.
* SQLite3 file format, and import and export facility.
* Full documentation including user and programming manual in HTML
* Operating system independence. MUIbase is available for Windows, Mac,
Linux and Amiga. The source code of MUIbase is also available as part
of a Source Forge project.
New features since V4.4
o New trigger function for virtual list fields for supporting drag and drop
of URLs (e.g. filenames).
o New sort-drop trigger function for virtual list fields when sorting items
using drag and drop.
o New programming function MOVEREC for moving a record to a new position in
its table. This is useful, e.g. for the new sort-drop trigger function.
o New programming functions GETREC and SETREC for obtaining and setting the
record reference of a value.
o New programming functions for lists, REPLACENTH, MOVENTH, and REMOVENTH,
which are useful for changing the value of the n-th element in a list,
moving it to a new position, or removing it.
o New demo project FileList.bss which shows how to store external filenames
in a Memo field and making them accessible in a virtual list. The project
also showcases the new drag and drop functions for adding external files
and for sorting the files.
o Menu item 'Open project' creates a new project instead re-using the current
o ASKOPTIONS uses now check boxes for selecting rows on all platforms.
o The Windows distribution uses now x64 binaries.
o The Amiga distribution now also contains binaries for AROS (i386 and x86_64).
o Several bug fixes.
Steffen Gutmann, 03.06.2022