LiteBase is a simplified and low cost database management system for PDAs and smartphones compatible with the SQL language. The product runs jointly with TotalCross virtual machine installed in all supported devices.
Here are some key features of "LiteBase":
· types: SHORT, INT, LONG, DATE, DOUBLE, DATE, DATETIME, NULL, BLOB e VARCHAR
· DML commands: SELECT, INSERT, UPDATE e DELETE
· DDL commands: CREATE TABLE, ALTER TABLE, CREATE INDEX
· aggregation and ordination functions:MAX, MIN, SUM, AVG, GROUP BY, ORDER BY
· miscellaneous functions: ABS, UPPER, LOWER, YEAR, MONTH, DAY, HOUR, MINUTE, MILLIS
· sd card table handling
· join clause support
· compound primary keys and indexes
· multithread support
Requirements:
· Palm OS 5.x with NVFS: Zire 22, Tungsten T|X / E2, Treo 650 and newer
· BlackBerry OS 4.3 to 4.7
· Windows Mobile 5/6
· Pocket PC
· Android 1.6 or later
Limitations:
· The DEMO version will work during 80 hours of continuous use. After this period, you are allowed to hard-reset the device and install it again.
What's New in This Release: [ read full changelog ]
· Corrected a bug with date and datetime using default on JavaSE and Blackberry.
· Corrected a bug of possible composed index corruption when updating or deleting data.
· Corrected a possible crash if the path had more than 255 characters on Windows 32, Windows CE, Palm, Android, iPhone, and iPad.
· Corrected the fact that a field used in a function can't be fetched using only the name of the field unless it is also in the select field list.
· Corrected a bug when using a default value of type string which could become messed up on Windows 32, Windows CE, Palm, Android, iPhone, and iPad.
· Corrected a possible bug when using ResultSetMetaData in tables with more than 128 columns on Windows 32, Windows CE, Palm, Android, iPhone, and iPad.
Find us on Google+
