Author Topic: Database Program For Data "tracking"  (Read 2383 times)

daniel3000

  • Hero Member
  • *****
  • Posts: 1003
    • View Profile
    • http://
Database Program For Data "tracking"
« 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
« Last Edit: December 12, 2005, 06:50:35 am by daniel3000 »
SL-C3200 with weeXpc, based on pdaXrom 1.1.0beta3
HP 200LX with MS-DOS 5.0

dfisher

  • Jr. Member
  • **
  • Posts: 51
    • View Profile
    • http://
Database Program For Data "tracking"
« Reply #1 on: December 12, 2005, 10:13:37 pm »
Hi,

How about tkcCard from theKompany:
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=138

I've always liked the look of kgrok.  

Cheers,
Doug
SL-6000, Various SD cards, Sharp ROM, Belkin F8U-1500E Keyboard, Boxwave MiniSync cable

Tehas

  • Full Member
  • ***
  • Posts: 157
    • View Profile
    • http://users.adelphia.net/~stonerrl/rick/
Database Program For Data "tracking"
« Reply #2 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.
+SL-5600 v1.32 ROM (Special pre-emptive kernel with overclock)  +Viking 256CF  +SimpleTech 256CF  +Viking 128SD (as ext2)  +AmbiCom WL1100C +Micro Innovations KB  +Hawking Ethernet CF  
+SL6000L +Lexar 1GB SD (as ext2)  +Windows 98/Me/Nt/XP  +Mandrake 8.1 My Zaurus Page[img]http://users.adelphia.net/~stonerrl/rick/rls_userbar.gif\" border=\"0\" class=\"linked-sig-image\" /]