Hi,

In my app i should maintain a local database which contain 20 tables with
primary and foreign keys later it should sync with remote server database.
I have some queries following

   - I came across that foreign key constraint is not supported.
   - Can we implement Joins.
   - What is maximum size of database file.
   - Do we have any api's to sync with remote database.

Please help me....

Thanking you,
nageswararao.

usually the syncing with a database pattern happens via service in an
alarmmanager then updating a content provider or something of that
nature..

kris

On Fri, Oct 26, 2012 at 1:26 AM, nageswara rao Rajana

This is some thing what m also working on to sync db best thing is use
content provider using syncAdapter in android  
see one of my
post http://ericmiles.wordpress.com/2010/09/22/connecting-the-dots-with-an...

database file size is  android.database.sqlite.SQLiteDatabase has following
API call that returns the maximum size the database may grow to:

long getMaximumSize()

and more sqlite limits u can see http://www.sqlite.org/limits.html

Dear Nageswararao,

Could I suggest you have a look at the MobiForms Advanced Edition mobile
development suite for Android?  The MAE includes the MobiForms Developer
and the MobiForms Sync Server.  The MobiForms Developer is especially
designed for creating database oriented mobile business apps.  MobiForms
totally replaces Eclipse, the Android SDK and the need to learn Java.
 MobiForms dramatically accelerates the development process with most
programming done with drag and drop or selectable lists of tables and
columns.  Behind the scenes MobiForms automatically takes care of resultset
and database cursor management.  MobiForms supports direct JDBC connection
to a range of remote databases including Oracle, SQL Server and MySQL.

The addition of the MobiForms Sync Server enables any MobiForms app to run
offline as well and supports bi-directional online synchronisation when
connectivity is available. The MSS provides the means to define the
synchonisation and offline buffering rules to Oracle, SQL Server, MySQL,
Sybase, DB2, Access, SQLite, HSQLDB and Firebird.

The MobiForms tools will run on Windows, Linux and Apple Mac, and supports
the creation of mobile apps for Android smartphone and tablet, Apple
iPhone, iPad and iPod, and Windows Mobile.  For more information go to:
http://www.mobiforms.com

Kind regards,

Tim @ MobiForms

<snip>

Can we keep the marketing stuff off the mailing list? You can always
reply directly to person who requested information?

-Subodh