Re: Data Transfer Between Android and MySQL

2016-03-02 Thread Dave Newton 
(Slightly more-complete answers.)

On Wed, Mar 2, 2016 at 3:07 PM, Paul Romero  wrote:

> One more important detail: The Android app. is not a browser.
>

That doesn't matter a whole lot.


> My general question is what is the best and most commonly deployed way
>>> to transfer data between a mobile Android based platform and a
>>> MySQL database on a Linux server ?
>>
>>
There is no "most-commonly deployed way". You could write it in pure Java,
use a framework, use NodeJS, use Rails, use Elixir/Phoenix, PHP, Perl,
whatever. Essentially endless.


> More specifically, is Struts a
>>> good choice or am I barking up the wrong tree ?
>>
>>
Depends. Do you have a lot of Java experience? Don't already have another
Java framework deployed (e.g., SpringMVC, Play, Grails)? Have the hardware
necessary to run it at the loads you're expecting?


> Also, it would be
>>> highly desirable to address the issue of binary data.
>>>
>>
Do you want to talk via sockets, or a web service?


> The aforementioned framework requires a "web service" to be implemented
>>> on the Linux server. My understanding is that such a "web service"
>>> executes PHP code, embedded in HTML, to perform MySQL operations, and
>>> converts MySQL responses to JSON format.
>>>
>>
Web services can be implemented in anything.

Dave

Re: Data Transfer Between Android and MySQL

2016-03-02 Thread Paul Romero 

Hi Paul:

One more important detail: The Android app. is not a browser.

Best Regards,

Paul R.


On 03/02/2016 11:40 AM, Paul Benedict wrote:

Android is a remote client, and a web service is the common solution to
transfer data back to the host.

You are free to use whatever technology you want to implement the web
service. You have (1) message standard and (2) technology standard to
consider. The first are things like XML, SOAP, JSON, etc. The second are
products like Axis, Struts 2, JAX-WS, JAX-RS, etc. As David said, there are
no "best" answers in general; it's based on the best fit of your
requirements.

Cheers,
Paul

On Wed, Mar 2, 2016 at 1:29 PM, Paul Romero  wrote:


Dear Stuts Community:

My general question is what is the best and most commonly deployed way
to transfer data between a mobile Android based platform and a
MySQL database on a Linux server ?  More specifically, is Struts a
good choice or am I barking up the wrong tree ? Note that authentication
and security are essential in my case and my Android platform
uses SSL sockets for Internet connections. Also, it would be
highly desirable to address the issue of binary data.

It appears that the  RESTful/JSON framework is fairly common
way to achieve the functionality I described but I am not really
sure it is the best way and am certainly open to alternatives.

The aforementioned framework requires a "web service" to be implemented
on the Linux server. My understanding is that such a "web service"
executes PHP code, embedded in HTML, to perform MySQL operations, and
converts MySQL responses to JSON format.

I presume the "web service" can be implemented as a stand-alone module or
using Apache functionality.  (i.e. Examples are the Axis framework.) Is
this correct and which option can best achieve the functionality I have
described ?
Are there widely deployed modules or software that have this functionality
?
If not, what would be the easiest way to achieve this functionality ?

Best Regards,

Paul Romero

--


Paul Romero
---
RCOM Communications Software
EMAIL: pa...@rcom-software.com
PHONE: (510)482-2769







--


Paul Romero
---
RCOM Communications Software
EMAIL: pa...@rcom-software.com
PHONE: (510)482-2769

Re: Data Transfer Between Android and MySQL

2016-03-02 Thread Paul Benedict 
Android is a remote client, and a web service is the common solution to
transfer data back to the host.

You are free to use whatever technology you want to implement the web
service. You have (1) message standard and (2) technology standard to
consider. The first are things like XML, SOAP, JSON, etc. The second are
products like Axis, Struts 2, JAX-WS, JAX-RS, etc. As David said, there are
no "best" answers in general; it's based on the best fit of your
requirements.

Cheers,
Paul

On Wed, Mar 2, 2016 at 1:29 PM, Paul Romero  wrote:

> Dear Stuts Community:
>
> My general question is what is the best and most commonly deployed way
> to transfer data between a mobile Android based platform and a
> MySQL database on a Linux server ?  More specifically, is Struts a
> good choice or am I barking up the wrong tree ? Note that authentication
> and security are essential in my case and my Android platform
> uses SSL sockets for Internet connections. Also, it would be
> highly desirable to address the issue of binary data.
>
> It appears that the  RESTful/JSON framework is fairly common
> way to achieve the functionality I described but I am not really
> sure it is the best way and am certainly open to alternatives.
>
> The aforementioned framework requires a "web service" to be implemented
> on the Linux server. My understanding is that such a "web service"
> executes PHP code, embedded in HTML, to perform MySQL operations, and
> converts MySQL responses to JSON format.
>
> I presume the "web service" can be implemented as a stand-alone module or
> using Apache functionality.  (i.e. Examples are the Axis framework.) Is
> this correct and which option can best achieve the functionality I have
> described ?
> Are there widely deployed modules or software that have this functionality
> ?
> If not, what would be the easiest way to achieve this functionality ?
>
> Best Regards,
>
> Paul Romero
>
> --
>
>
> Paul Romero
> ---
> RCOM Communications Software
> EMAIL: pa...@rcom-software.com
> PHONE: (510)482-2769
>
>
>
>
>

Re: Data Transfer Between Android and MySQL

2016-03-02 Thread Dave Newton 
The options are essentially unlimited, both in and out of the JVM ecosystem.

What's "best" is more likely to be determined by the support resources you
have available.

On Wed, Mar 2, 2016 at 2:29 PM, Paul Romero  wrote:

> Dear Stuts Community:
>
> My general question is what is the best and most commonly deployed way
> to transfer data between a mobile Android based platform and a
> MySQL database on a Linux server ?  More specifically, is Struts a
> good choice or am I barking up the wrong tree ? Note that authentication
> and security are essential in my case and my Android platform
> uses SSL sockets for Internet connections. Also, it would be
> highly desirable to address the issue of binary data.
>
> It appears that the  RESTful/JSON framework is fairly common
> way to achieve the functionality I described but I am not really
> sure it is the best way and am certainly open to alternatives.
>
> The aforementioned framework requires a "web service" to be implemented
> on the Linux server. My understanding is that such a "web service"
> executes PHP code, embedded in HTML, to perform MySQL operations, and
> converts MySQL responses to JSON format.
>
> I presume the "web service" can be implemented as a stand-alone module or
> using Apache functionality.  (i.e. Examples are the Axis framework.) Is
> this correct and which option can best achieve the functionality I have
> described ?
> Are there widely deployed modules or software that have this functionality
> ?
> If not, what would be the easiest way to achieve this functionality ?
>
> Best Regards,
>
> Paul Romero
>
> --
>
>
> Paul Romero
> ---
> RCOM Communications Software
> EMAIL: pa...@rcom-software.com
> PHONE: (510)482-2769
>
>
>
>
>


-- 
e: davelnew...@gmail.com
m: 908-380-8699
s: davelnewton_skype
t: @dave_newton 
b: Bucky Bits 
g: davelnewton 
so: Dave Newton

Data Transfer Between Android and MySQL

2016-03-02 Thread Paul Romero 

Dear Stuts Community:

My general question is what is the best and most commonly deployed way
to transfer data between a mobile Android based platform and a
MySQL database on a Linux server ?  More specifically, is Struts a
good choice or am I barking up the wrong tree ? Note that authentication
and security are essential in my case and my Android platform
uses SSL sockets for Internet connections. Also, it would be
highly desirable to address the issue of binary data.

It appears that the  RESTful/JSON framework is fairly common
way to achieve the functionality I described but I am not really
sure it is the best way and am certainly open to alternatives.

The aforementioned framework requires a "web service" to be implemented
on the Linux server. My understanding is that such a "web service"
executes PHP code, embedded in HTML, to perform MySQL operations, and
converts MySQL responses to JSON format.

I presume the "web service" can be implemented as a stand-alone module or
using Apache functionality.  (i.e. Examples are the Axis framework.) Is
this correct and which option can best achieve the functionality I have 
described ?

Are there widely deployed modules or software that have this functionality ?
If not, what would be the easiest way to achieve this functionality ?

Best Regards,

Paul Romero

--


Paul Romero
---
RCOM Communications Software
EMAIL: pa...@rcom-software.com
PHONE: (510)482-2769