Thread: "PoastgreSQL/SQLite Anywhere"?
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
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: >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 > >. > > >
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