Sunday, August 29, 2010

[android-developers] Re: remote db connection

I would urge anyone considering your toolset (which do look very nice,
but I haven't really looked into them) to consider your sync server
approach over direct JDBC connections.

I can't speak to the quality of your efforts -- but from your stated
feature set, I think it fills a major need, and I wish you and your
customers every success with it. Buffering, replication and related
facilities are the best approaches to handling the unreliable and high-
latency connections to mobile devices.

(Perhaps sometime I will get around to playing with your stuff and
will be able to give a less-reserved endorsement! :=)

In Dan's defense, however, I don't think having the ability to do JDBC
is the same as saying there is a remote DB paradigm for the platform.
It is seldom done, because of the drawbacks of doing DB access at such
a low level over low-quality connections. Dan's point is that a 3-tier/
n-tier approach is generally superior -- either specific to your app,
or via a general package such as you provide.

The issues aren't only regarding the connection -- there are also
issues of access control, and abstraction from the underlying DB
representation, that make a 3-tier solution generally superior.

On Aug 29, 12:53 pm, Tim <t...@mobiforms.com> wrote:
> DanH is incorrect in his assertion that "There is no remote DB
> paradigm in Android."
>
> The Android framework supports full standard database JDBC
> connectivity to databases such as Oracle, SQL Server and MySQL.
>
> A direct connection to a remote database is perfectly secure, usable
> and technically possible particularly if the Android device is
> connecting via a secure wi-fi network or a GPRS/3G network where the
> SIM is part of a private APN.
>
> Android also supports many technical solutions to supporting offline
> connectivity that does not just involve REST and web services.
>
> Our MobiForms Developer rapid application development tool for example
> supports the creation of apps that can directly connect to a multitude
> of back office databases via JDBC.
>
> The complementary MobiForms Sync Server also supports bi-directional
> data replication, synchronisation and offline buffering between just
> about any back office database or ERP package (such as Oracle Apps,
> SAP, Navision, Dynamics etc.), and Google Android or others such as
> Windows Mobile. Supported back office databases include Oracle, SQL
> Server, Access, Sybase, IBM DB2, SQLite, HSQLDB and MySQL.
>
> For more information have a look athttp://www.mobiforms.com.
>
>
>
> vineeshkc wrote:
> > pls give me remote db connection code

--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscribe@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en

No comments:

Post a Comment