Short: Programmable relational database w/ GUI Author: muibase@yahoo.com (Steffen Gutmann) Uploader: muibase yahoo com (Steffen Gutmann) Type: biz/dbase Version: 4.5 Replaces: biz/dbase/MUIbase-4.4.lha Requires: MUI 3.8 Architecture: m68k-amigaos; ppc-amigaos; ppc-morphos; i386-aros; x86_64-v11-aros URL: http://muibase.sourceforge.net MUIbase V4.5 ============ 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. Features -------- 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 your customers. 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 and PDF. * 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 one. 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