New developer - database question

Discussion in 'iOS Programming' started by gaiaDev, Aug 15, 2014.

  1. gaiaDev macrumors newbie

    Joined:
    Aug 15, 2014
    #1
    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. :)
     
  2. D.T. macrumors 604

    D.T.

    Joined:
    Sep 15, 2011
    Location:
    Vilano Beach, FL
    #2
    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).
     
  3. iMacFarlane macrumors 65816

    iMacFarlane

    Joined:
    Apr 5, 2012
    Location:
    Adrift in a sea of possibilities
    #3
    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.
     
  4. ArtOfWarfare macrumors 604

    ArtOfWarfare

    Joined:
    Nov 26, 2007
    #4
    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.
     
  5. whitneyhu macrumors newbie

    Joined:
    Aug 17, 2014
    #5
    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!
     
  6. gaiaDev thread starter macrumors newbie

    Joined:
    Aug 15, 2014
    #6
    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.
     
  7. AxoNeuron macrumors 65816

    AxoNeuron

    Joined:
    Apr 22, 2012
    Location:
    The Left Coast
    #7
    How are you going to create an iOS app without OS X?
     
  8. gaiaDev thread starter macrumors newbie

    Joined:
    Aug 15, 2014
    #8
    It's possible. And I have friends with macs, though few, if needed.
     
  9. D.T. macrumors 604

    D.T.

    Joined:
    Sep 15, 2011
    Location:
    Vilano Beach, FL
    #9
    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).

    Xcode only runs on OSX, so you’ll need to score a Mac.
     
  10. gaiaDev thread starter macrumors newbie

    Joined:
    Aug 15, 2014
    #10
    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.
     
  11. AxoNeuron macrumors 65816

    AxoNeuron

    Joined:
    Apr 22, 2012
    Location:
    The Left Coast
    #11
    Good luck with that ;)
     

Share This Page