Solved

Researching a solution

Posted on 2013-06-05
11
305 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
  • 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 6

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
 
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 6

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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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 6

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 6

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 6

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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
The viewer will learn how to count occurrences of each item in an array.

867 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

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now