Sidebar Sidebar
Become a MacRumors Supporter for $50/year with no ads, ability to filter front page stories, and private forums.

iOS New developer - database question

G

gaiaDev

macrumors newbie
Original poster
Aug 15, 2014
4
0
I currently have experience with Java and MS SQL Server and the app I'm intending to build will be an iOS app (at least for now). It will require storing information into a collective database.

What, in your opinion, would be a good database system to go with? Free preferred.... I was looking at Oracle 12c since it says it uses cloud servers, but I'm honestly not sure what to go with. Difficulty of use doesn't matter to me. Also, my computer couldn't exactly handle hosting any database server, so thought on hosting will be appreciated as well. Thank you :D

... and if you have any questions or need clarification, please ask. :)
 
I’d suggest Postgres (PG), assuming your design isn't better served by a non-SQL product like MongoDB. If you decide to stick with Java, no sweat with PG. Some people will likely suggest mySQL, either would serve your purpose (I’ve used both extensively, as well as MS/SQL and Oracle).

If you build your backend/API using open source type tools, you’re going to be looking at Postgres, MySQL vs. costly enterprise DBs like MS/SQL and Oracle.

There’s some great PaaS solutions like Heroku, App Engine, where you don’t have to concern yourself with managing a server, it exposes deployment through something like Git, and when you provision different services like a database, you specify the service level, pay and forget about it :) (that of course simplifying it, but you get the idea...)

You might look into Scala if you’re coming from a Java background, unless you decide to explore a totally different option like Python or Ruby. I’m assuming you’re talking about building something like a RESTful API for consumption via your iOS app, and potentially from other clients (web, Android).
 
Have you looked into the included CoreData framework? I'm by no means a database guru but I can Access better than any of my co-workers. I believe CoreData is pretty flexible and keeps everything in your OS X or iOS project "in-house", and of course, free (part of xCode).

Just a thought.
 
If you won't be launching until after iOS 8, and your database only needs to be shared between iOS devices, then I would look into Apple's CloudKit. That's free and I believe it's pretty effortless to use if your code (which is compatible with iOS 7) is already using CoreData.
 
gaiaDev said:
I currently have experience with Java and MS SQL Server and the app I'm intending to build will be an iOS app (at least for now). It will require storing information into a collective database.

What, in your opinion, would be a good database system to go with? Free preferred.... I was looking at Oracle 12c since it says it uses cloud servers, but I'm honestly not sure what to go with. Difficulty of use doesn't matter to me. Also, my computer couldn't exactly handle hosting any database server, so thought on hosting will be appreciated as well. Thank you :D

... and if you have any questions or need clarification, please ask. :)
Click to expand...

Hi! I wonder what sort of app you can build which involves using SQL server? I am a programming beginner and I want to build one as well. Or, do you know any website that teaches this?

Thank you!
 
I actually don't have any Mac computers.... I've never really been a fan.

My app is essentially a case management system for lawyers. I hope to create a software that covers more than that and connect to it. The database will be collective. I'm going to go ahead and try using Postgres.
 
It's possible. And I have friends with macs, though few, if needed.
 
gaiaDev said:
My app is essentially a case management system for lawyers. I hope to create a software that covers more than that and connect to it. The database will be collective. I'm going to go ahead and try using Postgres.
Click to expand...

Is it going to be iOS only, and/or Android and/or a web based interface?

If it is (heck, even if it isn’t), I’d suggest building the app logic on the server side where it’s easier to maintain and provides consistency across different clients.

Side note: have you done any research into the CMS options for attorneys? Vertical apps like that can be an excellent market, but unless it’s something completely new, there’s probably already some dominant players. I know there is on the large scale law enforcement (and they’re in pretty deep).

gaiaDev said:
It's possible. And I have friends with macs, though few, if needed.
Click to expand...

Xcode only runs on OSX, so you’ll need to score a Mac.
 
Yes I've done research, that wasn't ever an issue. Also, while probably easier for IOS apps, you don't have to use Xcode. And yes, I intend to build across multiple platforms and I know that a server is necessary.
 
You must log in or register to reply here.
Register on MacRumors! This sidebar will go away, and you'll see fewer ads.
Top Bottom
Back