tkcRekall is a full port of our desktop database front end Rekall, it is not a stripped down version. Everything that you can do with the desktop version you can do with tkcRekall, limited only by the Zaurus itself. With tkcRekall you can:

* Access MySQL and PostgreSQL databases over a network

tkcRekall includes drivers for MySQL (based on MySQL 3.23.6 libraries) and for PostgreSQL (based on PostgreSQL 7.0.3 libraries). MySQL has also been ported to the Zaurus, and tkcRekall can access MySQL running on the Zaurus.

* Access an database on the Zaurus stored in XBase format

tkcRekall includes the XBase-2.0.0 libraries and an SQL wrapper library so that you can create simple databases stored on the Zaurus.

* Design, view and update tables

tkcRekall incorporates a table design tool, and you can view and update the data stored in tables.

* Design and view forms

tkcRekall supports forms and forms/subforms (actually, you can nest forms as far as you like). You can design and run forms on the Zaurus, with a range of controls from simple test fields to images and formatted text. Forms can retrieve data directly from tables, via free-text SQL queries or via queries designed with the graphical query designer.

* Design and use queries

tkcRekall includes a graphical query designer, which you can use to create and view queries over multiple tables. Queries functionality allows (depending on the database server) inner and outer joins, group by and having, where and ordering. Queries can also be used in forms.

* Import and export

Data can be moved betweem files and tables using tkcRekall's copier. A copier can move data from one of a number of sources (files, tables and SQL queries) to one of a number of destinations (files, tables and XML-formatted text). For example, you can copy data to and from a networked RDBMS databgase and an XBase database on the Zaurus.

* Scripting

tkcRekall is scripted using the Python language, and incorporates the Python 2.2.1 interpreter. You can write Python scripts to automate and extend the database functionality, and can access any Python modules which are ported to the Zaurus. tkcRekall also contains an embedded Python debugger.

* Reports

This version of tkcRekall does not include the report design and view component. Although printing will not be supported, the next release of tkcRekall will include on-screen report design and generation.

* Manual

The manual for version 1.1.0 of the desktop version of Rekall is included(about 2MB, PDF format). This includes an appendix relating to tkcRekall, but since tkcRekall contains all of Rekalls functionality, the manual is basically the same for both.

* Demonstration version

A demonstration version of thcRekall is available also available. It is fully functional, but will stop after 60 minutes.

* Demonstration database

A minimal demonstration database is included. This should be installed to RAM, and creates files in /home/tmp/DB/Test. The tkcRekall database file is /home/tmp/DB/Test/Test.rlk. It uses the XBase library, so it can run entirely on the Zaurus. To get started, open this database, select the forms tab, open the !Files branch and double- click MainForm.