iphone app

Posted on 2013-10-04
Medium Priority
Last Modified: 2013-10-07
I'm looking into creating an iphone app to get data from my SQL server.  Is this possible?What safeguards can  be in place to restrict access? Thanks for your help.

Question by:mfony
  • 2
  • 2
LVL 54

Expert Comment

by:Scott Fell, EE MVE
ID: 39547935
It depends on your definition of an app.  

If you make a webview, you just make an html5 website as you almost normally do.

If you make a true native app, you will will convert all data functions to a webservice and use ajax calls to to your database and oAuth.

If you want to make an app and use MS, you might want to check into using azzure http://www.windowsazure.com/en-us/develop/mobile/tutorials/get-started-ios/

Author Comment

ID: 39547942
With the website, can I limit the use with .htaccess? I need to make sure the app is the only thing that can access the site.
LVL 14

Expert Comment

ID: 39550506
I agree with padas however, even if you do restrict access at the server level a user can easily spoof their os/browser.  The issue this brings up is are you willing to be ok with non iPhone users ( more advanced users ), accessing the site in this fashion?  The HTML 5 solution offers a ton of advantages especially reusability and I think that's the biggest advantage IMHO.  With that being said, I would approach it by creating some restful web services that serve data out to a native iPhone application.  Why would I go the extra distance to do this?  I think that the native development offers some advantages in the context of speed and offers some more security.  Anyways the questions you need to ask yourself:  what does the app do, what users am I targeting, what level of control do I need...

Hope this helps

Author Comment

ID: 39552204
Could you define?:

restful web services that serve data out to a native iPhone application.

LVL 54

Accepted Solution

Scott Fell,  EE MVE earned 2000 total points
ID: 39552534
In ultra simple terms, a webservice is referring to hitting a url to manage your data functions.  You would use a webservice to create, retrieve, update and delete data (CRUD).

As example, you might have www.yourdomain.com/api/contacts/list which would list out all of your contacts.  This would be instead of using a connection string in your code to access your db as you would not be able to do this in a native app.  (you could, but it would be like adding your connection string along with password to your db to everybody's personal computer).

It is more complex however and better explained in the first article.  The 2nd compares REST with another type of webservice SOAP.


There are very good reasons to make a native app.  However, if this is new to you, I think you are better off starting with making a webview allowing your to make the app in html5 as you typically make a website.  

You can use tools like phonegap http://phonegap.com/ to help you as well.  This will make it easier for you, although for some apps, you will see some lag compared to native apps because in part of all the things that make it easy, also add layers of resources.

Another option is to use a platform like http://factory.joshfire.com/.  Warning though, there is a free tier, but the jump to paid is expensive.  It does make the entire process very easy though.

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Do you come here a lot? Are you lazy like me and don't want to go through the "trouble" of having to click your Dock's Safari icon and then having to click your Experts Exchange Favorites bookmark to get here? Well then this article is for you.
This article outlines the struggles that Macs encounter in Windows-dominated workplace environments – and what Mac users can do to improve their network connectivity and remain productive.
The video provides a quick and easy steps to migrate MBOX file to well known Outlook PST and Office 365. Besides this, it also supports and migrates more than 20 email clients of MBOX which include AppleMail, Opera, Thunderbird and SeaMonkey effortl…
To export Lotus Notes to Outlook PST or Exchange and Domino Server files to Exchange Server or PST files with ease, go for Kernel for Lotus Notes to Outlook conversion tool. Through the video, you can watch the conversion process. A common user with…

607 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