Aggregaat Server Integration with dbs:oracle,mysql,sybase,foxpro

Hello All

Has anyone tried integrating odk aggregate with any of the databases above?
Is it possible?

If it is how was this accomplished.

Regards
Kofi

MySQL and PostgreSQL are already supported.

If you want to add support for another database, it is fairly
straightforward.

The code for the 3 datastores (gae (BigTable), mysql (MySQL), pgres
(PostgreSQL)) is under

org.opendatakit.common.persistence.engine

Start by copying the implementation package of either MySQL or PostgreSQL,
whichever is most similar to your new db.

DatastoreImpl -- implements detection(describe), creation and dropping of
tables, getting (by PK), inserting, modifying and deleting rows., including
the conversion between the storage representation of the database and the
data values we use within ODK Aggregate.

TaskLockImpl -- this is the most difficult to get right. The DB layer does
not use transactions. Instead, it uses a global task lock, implemented via
the db layer, to prevent any other processes/threads from entering a
critical section of the code. The task locks time out after some period of
time. The implementation of a task lock will typically use table locks and
transactions in a very db-specific manner.

QueryImpl -- implements the construction of SELECT statements and their
execution, including managing resumable cursors; should be largely
generic/re-usable across JDBC dbs.

RelationRowMapper -- helper function for converting data out of cursors;
should be largely generic/re-usable.

ยทยทยท On Tue, Apr 15, 2014 at 9:39 AM, Kofi wrote:

Hello All

Has anyone tried integrating odk aggregate with any of the databases
above?
Is it possible?

If it is how was this accomplished.

Regards
Kofi

--
You received this message because you are subscribed to the Google Groups
"ODK Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to opendatakit-developers+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

--
Mitch Sundt
Software Engineer
University of Washington
mitchellsundt@gmail.com