Re: Re: [iPAQ] GPE - GNU PDA Environment

On Sat, 29 Dec 2001 21:12:37 +0000 (GMT)
Alan Cox <alan_at_lxorguk.ukuu.org.uk> wrote:

> > > Thats assuming you link the apps with the database rather than
> compiling
> > > up
> > > an sqlserver from sqllite
> > At least for me speaking I do not really see the need for an extra
> server
> > and SQLite also does AFAIK not provide one.
> > Do you think we need one?
> Yes - because
> o I want to be able to query the PDA from outside. If I wander into
> my wireless lan I'd like the main machines to be able to query the
> database, sync it and feed stuff without me even pushing buttons.
Hmm... do you really think this is common for most users?
Sure, you and maybe me as "power users" would like to do so but the
average user is more than happy with the PDA and a desktop machine and
both carrying the same information. The desktop could then be the place
for the database server and network capabilities.

> o It trades a very slight performance lost for easy to implement
> notifications.
OK, that's a point.

> o It reduces memory footprint - data is cached once.
Also good!

> o It means we can be a lot smarter about writeback, delaying
> writebacks when appropriate, without worrying about another db
> instance falling over us.
OK, convinced ;)

> Equally we want to wrap the sql interface very cleanly so we can change
> dbase later. Which in practical terms means we don't care yet
(I suspect your mail got truncated here...)
Wrapping the interface to a certain extend is for sure good. What about
ODBC? It is a common standard for this.

Anyway, if we want to have a database server, we will have to create one.
SQLite does not provide one and all alternatives I know of are to heavy
for a PDA. I headr rumors of an embedded version of MySQL, but have not
yet confirmed this. Maybe I'll do a search for it today.

CU
  nils faerber

-- 
kernel concepts          Tel: +49-271-771091-12
Dreisbachstr. 24         Fax: +49-271-771091-19
D-57250 Netphen          D1 : +49-170-2729106
--