SDB Engine means
Simple
Data
Base
Engine and is written entirely using the
LUA scripting language.
The goal of this project is to complete a database engine for the
AROS operating system and, secondary, to improve my programming skills.
The final product will be a single-user relational database, but for further details you should look at the main
SDB site.
And now some specifications:
* Single user database
* limitless number of databases opened at the same time ( limited by available memory )
* Dynamic record size ( no wasted space by empty fields )
* up to 4.294.967.295 records ( can be easily increased when AROS will get a more modern file system )
* up to 65.534 fields within a record
* Field name can reach 255 chars ( with no restrictions )
* Fields can store up to 65k of data
* Supported field type are ( at the moment ):
> numeric
> alphanumeric
> boolean
* maximum database size is 4Gb ( limited by the actual AROS file system )
* warnings/errors localization
* database filtering system trought "Selections"
* limitless number of Selections for each opened database ( limited by the available memory )
* Database Import/Export functions
* Selections Import/Export functions
* Supported criteria operators are:
> Greater than ( > )
> Lesser than ( < )
> Equal ( = )
> Greater or Equal ( >= )
> Lesser or Equal (<= )
> Not Equal ( <> )
> Between ( <-> )
> Not Between ( >-< )
> Contains ( <|> )
> Starts with ( |> )
> Ends with ( <| )
> Is Empty ( empty )
> Is Nil ( nil )
> And
> Or
> Not
* Selections sorting
* Export Selection's data ( at the moment exports only in sdb format )
* Ability to auto update Selections when an involved record is changed ( AutoRefresh feature )
* Relations between databases called "Link System" ( work in progress )
* Record Undo/Redo functions
* Database Defragmentation/Cleaning functions
* Database rebuilding system ( not yet developed )
* Guided procedures ( not yet developed )
* Help System ( not yet developed )
...and that's all!

Links:
> SDB Engine Project, Home Page> LUA> AROS