Go Back   MacRumors Forums > Apple Systems and Services > Programming > iPhone/iPad Programming

Thread Tools Search this Thread Display Modes
Old Apr 18, 2009, 09:32 AM   #1
macrumors regular
Join Date: Apr 2009
SQL based app.. direction needed

Hello friends,

As you've prolly guessed, im planning an application for iphone. But Its a niche app intended for medical students. (yes, its not a game). My reasons for making an application like that is because i miss it. and it'll help me..

Before I start, I wanted to make sure im headed in the right direction. And hence I needed some startups from you guys.

My app requires a database. I've heard that iPhone supports SQLLite. I worked in MySQL in the past. so that shouldnt be tough.

Take for example an application like Dictionary.. requires adding to database loads of words. And that takes time. So I was thinking if i should make a simple script and keep adding my data in MySQL db on my mac, since its gonna be a huuuge list with over a thousand terms etc.. whilst i develop the application in SDK
My question is, would I be able to convert all those tables to sql lite in one go.. or am i wasting my time.. and I should add data once my application framework is complete..

Q2- about the communication between the app interface and sql backend. some suggested hosting the data online and make the app service based and send data via xml. The db clubbed with app it self is the other option. Any suggestion here would be very helpful, as it changes the kinda app im making. My need/preference is the db with the app itself, but im concerned about the app footprint it might leave..

About security and cracking.. are we to add any protective features? specially if you've got a database full of information.

Finally, iPhone Developer program, can I apply to the developer license even before i start developing the app? I heard they take loads of time to accept. So this might be a good time.. and the payment of $99 could be a good motivation itself...

If the questions sound lame... its cuz of my limited knowledge.. excuse me please.
Any word of advice would be helpful..
mraheel is offline   0 Reply With Quote
Old Apr 18, 2009, 09:45 AM   #2
macrumors Demi-God
Join Date: Apr 2006
For database, your Mac also has SQLite, so why not just create the database that way and then put it into your iPhone project? There's a Firefox plugin called SQLite Manager that gives you a GUI for SQLite, works great. It's what I use for creating my database files for iPhone apps.

If you're going to have loads of data, I'd advise against storing it on a remote database. The app is then worthless without a data connection (what if the user has a Touch and isn't near WiFi?).

For security, there are a couple methods, but nothing is bulletproof of course. If you do some Googling you'll see there's a way to check the plist for a hack. It's basic, but can catch some of the cracked apps. There are security methods that cost money as well, don't know of anyone actually using them though.

You can sign up for the program at any time. You don't have to be in the process of making an app or even have an app idea. Apple will gladly take your $99 for no reason at all, lol.
fishkorp is offline   0 Reply With Quote
Old Apr 18, 2009, 10:15 AM   #3
Thread Starter
macrumors regular
Join Date: Apr 2009
hey fishkorp, thx for the advice man.. im new to mac .. had no idea there was sql lite in mac. But I an online database was already in my mind. So I was thinking if MySQL conversion to sql lite is possible.. im sure it is, how easy would it be, thats the question!.
mraheel is offline   0 Reply With Quote

MacRumors Forums > Apple Systems and Services > Programming > iPhone/iPad Programming

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Similar Threads
thread Thread Starter Forum Replies Last Post
Automatically Rotate PDF App based off text direction? Mikebuzzsaw Mac Applications and Mac App Store 4 May 14, 2014 08:19 PM
My new app: Jerusalem Direction refaelsh iPhone and iPod touch Apps 0 Mar 5, 2014 01:18 AM
Local SQL editing app (ie, Base/Menial for iPad)? manu chao iPad Apps 1 Mar 29, 2013 09:08 AM
Software similar to SQL Dev and SQL plus? doomfront Mac Basics and Help 0 Nov 20, 2012 12:25 PM

Forum Jump

All times are GMT -5. The time now is 07:47 PM.

Mac Rumors | Mac | iPhone | iPhone Game Reviews | iPhone Apps

Mobile Version | Fixed | Fluid | Fluid HD
Copyright 2002-2015, MacRumors.com, LLC