OESF Portables Forum

Everything Else => General Support and Discussion => Zaurus General Forums => Archived Forums => Software => Topic started by: daniel3000 on December 12, 2005, 06:50:21 am

Title: Database Program For Data "tracking"
Post by: daniel3000 on December 12, 2005, 06:50:21 am

Hello,

I'd like to have a database applicatoin which allows configurable database layout and an easy way to add new entries with time stamp configurably prefilled fields for various purposes.

Does anyone know which software I could use (either under QTopia or on a console, no X)?

For example I need this to track my health data (blood sugar, weight, blood pressure...) or to track expenses, or to track time I spent on different projects.... I am aware that there are solutions for all these fields seperately, but all of them which I have seen turned out to be not configurable enough or to have other inacceptable limitations. Additionally, I'd prefer a common database file format,  which can be manipulated and used by other applications as well (XML...)

Especially nice would be a feature to perform calculations, such as average, sum etc.

On my old palmtop (HP 200LX) I used the spreadsheet application Lotus 1-2-3 for such purposes, which had its shortcomings too, but generally supported what I needed, including macros for data entry support etc.
I have yet to find something as good on the zaurus!

I have seen Portabase. Configurable database layout, but strange file format (XML only with manual export) and no things like maacros, prefilling etc. and no calculations.

I have seen Hancom Sheet. IMHO just a simple grid for puting numbers inside the cells. Not much more. :-(

I have seen SQLite. Interesting beginning, but I would like to avoid programing much on my own.

Any ideas?

Thank you
daniel

Title: Database Program For Data "tracking"
Post by: dfisher on December 12, 2005, 10:13:37 pm

Hi,

How about tkcCard from theKompany:
http://www.thekompany.com/embedded/tkccard/ (http://www.thekompany.com/embedded/tkccard/)

Or these ones for free:
http://www.killefiz.de/zaurus/showdetail.php?app=735 (http://www.killefiz.de/zaurus/showdetail.php?app=735)
http://www.killefiz.de/zaurus/showdetail.php?app=138 (http://www.killefiz.de/zaurus/showdetail.php?app=138)

I've always liked the look of kgrok.  

Cheers,
Doug

Title: Database Program For Data "tracking"
Post by: Tehas on December 12, 2005, 11:39:07 pm

I've been using Portabase.  It can do an export to comma separated values (CVS) files too.  You can set default values for columns.  True though about not doing computations on columns.

With Hancom sheet, you should be able to use formulas that reference cells =sum(a1:a3), etc.   Kind of like what you'd do with Excel.

SQLite is more of a database management engine for storing the data - you need to find or write a front-end application.