News Archive (1999-2012) | 2013-current at LinuxGizmos | Current Tech News Portal |    About   

Desktop database front end to the Sharp Zaurus now available

Jul 23, 2002 — by LinuxDevices Staff — from the LinuxDevices Archive — views

An announcement from theKompany . . .

theKompany has released 'tkcRekall'. This is a port of the Rekall desktop database front end to the Sharp Zaurus.

Everything that you can do with the desktop version of you can do with tkcRekall, limited only by the Zaurus itself. tkcRekall is not a stripped down version of software. Forms and reports and are compatible between tkcRekall and the desktop version, so you can design and test on the desktop and then move your work to the Zaurus. This speeds your productivity.

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 available in the package (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 database
    A minimal demonstration database is included in the package.

A demonstration version of tkcRekall is available via ftp. It is fully functional, but will stop after 60 minutes. Screenshots of tkcRekall are available here. Additional requirements and resources are listed here.

theKompany.com has a wide range of products available for Linux including a growing collection of 'embedded' applications for the Sharp Zaurus starting at prices as low as $4.95.

 
This article was originally published on LinuxDevices.com and has been donated to the open source community by QuinStreet Inc. Please visit LinuxToday.com for up-to-date news and articles about Linux and open source.



Comments are closed.