OESF Portables Forum

General Forums => General Discussion => Topic started by: fabri70 on October 23, 2004, 09:41:06 am

Title: Database for zaurus c860
Post by: fabri70 on October 23, 2004, 09:41:06 am

Is there a good GPL relational database for zaurus C860 ?
I would appreciate something that will archive data in a file that will be readable also on WIN XP.

Fabri

Title: Database for zaurus c860
Post by: johnw on October 23, 2004, 04:07:19 pm

Will this (http://www.caulfei.demon.co.uk/zaurus/) work on a C860?

Title: Database for zaurus c860
Post by: stupkid on October 23, 2004, 08:00:28 pm

Yeah I have mysql on my c860 with Cacko QT.  It's on my feed:

http://bryandeluca.com/feed/ (http://bryandeluca.com/feed/)

mysql_3.22.32-3_arm.ipk

I don't think this really the best solution if you want to move the database between Zaurus and Windows though.

Enjoy.

Title: Database for zaurus c860
Post by: Hrw on October 24, 2004, 07:14:31 am

maybe SQLite will be enough? it is available in OZ 3.5.1

Title: Database for zaurus c860
Post by: freizugheit on October 24, 2004, 11:34:23 pm

Try using PortaBase at http://portabase.sourceforge.net/ (http://portabase.sourceforge.net/)

Title: Database for zaurus c860
Post by: fabri70 on October 26, 2004, 05:18:56 am

Quote

Try using PortaBase at http://portabase.sourceforge.net/ (http://portabase.sourceforge.net/)

PortaBase works also in WinXP Great !!!
I tried to do some databases, when I'll buy my C860 I already have some file to work with !

I was just wondering.... how to make printout of the data in the database ?
C860 does not make printout when it is connected to a network ?
The only way to print is to export to csv ?

Bye

Title: Database for zaurus c860
Post by: PsionX on October 26, 2004, 10:51:57 am

Quote

I was just wondering.... how to make printout of the data in the database ?
C860 does not make printout when it is connected to a network ?
The only way to print is to export to csv ?
Bye

Hi,
See my contribution on this french forum :
Portabase and Xml/Html conversion (http://pdafrance.com/pdaforum/showthread.php?s=&threadid=41757&highlight=portabase).
This is an example of a Xml transformation in html, directly on the Zaurus !!...
Xml to Html with personnal xslt (http://sdahlen.free.fr/VRAC/zaurus/Psion.html)  
My XSL template (http://sdahlen.free.fr/VRAC/zaurus/portaB.xsl)

Title: Database for zaurus c860
Post by: rickh on October 26, 2004, 12:53:31 pm

Quote

Try using PortaBase at http://portabase.sourceforge.net/ (http://portabase.sourceforge.net/)

Portabase is great, but it's not relational (from the original post, though, it really doesn't sound like relational is needed).

That said, there are some relational DBs that run on both the Zaurus as well as Windows, aside from MySQL.  There's picoSQL - full server and client (Zaurus, Win, Linux), and a PostgreSQL client for Zaurus, server on Windows and Linux, HSQLDB client that connect to various types of databases on the server-side.  I also understand that Daffodil DB runs on both the Zaurus and Windows, alothough I have no experience with it.

But really, unless you want to actually do SQL and have the overhead of an RDB, or have special datatype requirements, why not just use Portabase?  It stores all your data neatly on several different platforms.

R.
==

Title: Database for zaurus c860
Post by: fabri70 on October 28, 2004, 06:26:40 pm

Quote

Quote

Try using PortaBase at http://portabase.sourceforge.net/ (http://portabase.sourceforge.net/)

Portabase is great, but it's not relational (from the original post, though, it really doesn't sound like relational is needed).

That said, there are some relational DBs that run on both the Zaurus as well as Windows, aside from MySQL.  There's picoSQL - full server and client (Zaurus, Win, Linux), and a PostgreSQL client for Zaurus, server on Windows and Linux, HSQLDB client that connect to various types of databases on the server-side.  I also understand that Daffodil DB runs on both the Zaurus and Windows, alothough I have no experience with it.

But really, unless you want to actually do SQL and have the overhead of an RDB, or have special datatype requirements, why not just use Portabase?  It stores all your data neatly on several different platforms.

R.
==

Hi rickh,

actally the best for me is to have  a relational databse.
Buy the way I'm interested in see wich kind of database sw I can find.

Relational will help me a lot to simplify the job.

BTW I'm going to try picoSQL.

Tnx for info.

Fabri