"PoastgreSQL/SQLite Anywhere"?

I am glad to hear that someone else is thinking along these lines , I am
working on a project that uses PDA's with Differential GPS as field
survey units, and I would like to be able to do more than simply dump
the collected data and then append it to a Postgresql DB at home base,
as we are looking at updating records with resurveyed data.

last I looked SQL Lite had a very relaxed approach to data typing, with
the onus being on the Application developer to ensure the integrity of
semi typeless fields, which for the intended usage as an embedded
database that supports SQL is not a bad idea.

This would lead me to suppose that a replication routine would mostly
involve dumping a modified schema into SQL lite from Postgres, and that
some mechanism that combines Primary key + OID might be used as the
replication handle for record merge situations.

One big advantage is that both licenses are similar , so from that point
of view the combination is a no-brainer.
Johan Wehtje

Wolfgang Keller wrote:

On Wednesday 01 December 2004 04:43 am, Wolfgang Keller wrote:

Hello,

for applications which require offline data collection/processing with PDAs
and synchronisation/replication with a centralised server database (running
on PostgreSQL), I was wondering whether it would be possible to set up an
equivalent to *duck* Sybase SQL Anwhere using free software, maybe using
SQLite for the mobile clients.

Is there a solution which allows for automatic (but fully
user-configurable) asynchronous replication between PostgreSQL and SQLite?

TIA,

Best regards,

Wolfgang Keller

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

I don't know about sqlite but here is a program that syncs between pilot-db
(http://pilot-db.sourceforge.net/) and the SQL database of your
choice(assuming Python binding). I have only recently found this and cannot
comment as to its reliability.
http://www.mired.org/downloads/palm/dbsql-0.7.1.tar
Following is a list of projects related to sqlite.
http://www.sqlite.org/cvstrac/wiki
--
Adrian Klaver
aklaver@comcast.net