Solved

Researching a solution

Posted on 2013-06-05
11
308 Views
Last Modified: 2016-11-23
We have a lot of yachts all over the world and what we want to do is install a central server on each yacht, have the employee's use ipads to update data that will be stored on the server then when the boat comes back into port it would sync that data to our MySQL server.

Question: What database works best with iPad and would you go with a Mac server (mini for space) or a small Dell or IBM server?

For the App I could just use a webview and connect with a low res webpage but I would rather use that as a last resort. I have limited xcode experience but have written a few basic apps. I am mostly php.
0
Comment
Question by:Robert Saylor
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 6
  • 5
11 Comments
 
LVL 12

Expert Comment

by:adrian_brooks
ID: 39223262
For the sake of cost effectiveness, each yacht-homed server need not be an enterprise level server. Personally, I would actually use a barebones system with a linux OS. (Literally pennies on the dollar for the server at that point).

The reason I recommend this, is because if all the server needs to do is serve up a local app for the iPads to use, then the architecture need not be extravagant. A simple architecture with a LAMP stack installed on it would serve up your application and the localized MySQL database server would be able to be plenty for your needs. Then when each on-board system is back at a port, you would need only to fire off the updated database records back to the central server.

The central server would be a much better candidate for an enterprise-level system as it will be more responsible for enterprise-level processes and data handling.

~AB
0
 
LVL 7

Author Comment

by:Robert Saylor
ID: 39223283
Thanks, the central server is already enterprise. So with LAMP and I know LAMP very well I am thinking a web based served on a webview would prob work best.

I was wanting to use more native form based in xcode but that's beyond my experience. I could write the webview to be php and the ipad would connect to a local IP address.

We might also consider outsourcing the ipad development if we can get a more centralized connection to the boat server. I have a few older optiplex desktops I could most likely use for the ship computers.
0
 
LVL 12

Expert Comment

by:adrian_brooks
ID: 39223312
Well, you could do the whole thing in PHP and have it hosted on the LAMP server on the yachts and have a wireless router hooked to the servers so that the iPads could connect to them that way and save the cost if the iPad development altogether.
0
PeopleSoft Has Never Been Easier

PeopleSoft Adoption Made Smooth & Simple!

On-The-Job Training Is made Intuitive & Easy With WalkMe's On-Screen Guidance Tool.  Claim Your Free WalkMe Account Now

 
LVL 12

Expert Comment

by:adrian_brooks
ID: 39223351
On the LAMP stack, you could set up a name virtualhost for apache and put that name into the /etc/hosts file so that it knows to resolve it locally. Then when the iPad tries to go to yacht1.yacht-domain.com, it would be able to serve up your PHP app as a web page on the iPad.

Personally, if I were to be faced with this, that would be the route I would implement. Out of pocket expenses would be minimized while solution efficiency would be maximized. And in this day and age, we have all the tech we need to perform such tasks for very little financial expenditure.

~AB
0
 
LVL 7

Author Comment

by:Robert Saylor
ID: 39223355
This is true but have to think of people not computer friendless so was thinking an app would be best.
0
 
LVL 12

Expert Comment

by:adrian_brooks
ID: 39223368
That's quite obviously your preference and most certainly, UX does take precedent over cost when it comes to end-product.

Nonetheless, if a PHP app is done properly, its UX/UI can be as good or even better than a dedicated app. Especially with the use of Ajax and jQuery. But again, I absolutely respect your position in this and leave you to your most desired path to your solution.

Best regards. :)

~AB
0
 
LVL 7

Author Comment

by:Robert Saylor
ID: 39223404
I agree AJAX would make it user friendly. So my plan most likely would be to create a mini server with a mini user website then have an app launch the URL of the site. I should be able to stage the apps at our central office then deploy them. I can use xcode to install the app without going through apple. We don't want the app to be public. Or do you have a suggestion for deploying a private app?
0
 
LVL 12

Accepted Solution

by:
adrian_brooks earned 500 total points
ID: 39223446
I don't know anything about Apple related app development, but from everything I have heard, there is no way to deploy Apple apps without going through Apple directly. But again, that's only what I know from hearsay. So, I sincerely apologize for the lack of expert advise in that arena.

I'm more of one of those folks that lives by the K.I.S.S. paradigm. Or keeping the plumbing simple to avoid unnecessary complications.

~AB
0
 
LVL 7

Author Comment

by:Robert Saylor
ID: 39223461
Thanks, well I know if I execute the app from xcode to the ipad directly it will install the app. That won't be an issue if I have all the ipads here. But remote ipads could cause a problem.
0
 
LVL 7

Author Closing Comment

by:Robert Saylor
ID: 39223470
Thanks for your input on our planning!
0
 
LVL 12

Expert Comment

by:adrian_brooks
ID: 39223506
It's been a pleasure. :)

I wish you well on your endeavor.

~AB
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

CocoaPods is the best way to manage library dependencies in iOS and OS X projects. By using cocoa pods there is no need of downloading the code from github and copying to your project. There are plenty of open source libraries now available with C…
Nothing in an HTTP request can be trusted, including HTTP headers and form data.  A form token is a tool that can be used to guard against request forgeries (CSRF).  This article shows an improved approach to form tokens, making it more difficult to…
The viewer will learn how to dynamically set the form action using jQuery.
This tutorial will teach you the core code needed to finalize the addition of a watermark to your image. The viewer will use a small PHP class to learn and create a watermark.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question