Jump to content
Welcome to InsanelyMac Forum

Register now to gain access to all of our features. Once registered and logged in, you will be able to contribute to this site by submitting your own content or replying to existing content. You'll be able to customize your profile, receive reputation points as a reward for submitting content, while also communicating with other members via your own private inbox, plus much more! This message will be removed once you have signed in.

  • Announcements

    • Allan

      Forum Rules   04/13/2018

      Hello folks! As some things are being fixed, we'll keep you updated. Per hour the Forum Rules don't have a dedicated "Tab", so here is the place that we have our Rules back. New Users Lounge > [READ] - InsanelyMac Forum Rules - The InsanelyMac Staff Team. 
Table16

Database Backend Suggestions

3 posts in this topic

Recommended Posts

I'm trying to develop a personal management application using Cocoa and I'm looking for a database backend solution. I read that there really isn't a clean way access MySQL (which I know and prefer, and if I'm wrong about this, please tell me). I want to do possibly a web interface to it down the line which is why I mentioned MySQL. This means a remote server that hosts the database and my osx application could manipulate data on that server. I also read that there is some sort of SQLite and PostgreSQL support. I'm not familiar with these technologies.

 

I'm just looking on suggestions on what the easiest route would be, or the most practical for what I'm wanting to do.

 

Thanks.

Share this post


Link to post
Share on other sites
I'm trying to develop a personal management application using Cocoa and I'm looking for a database backend solution.

 

Umm... what about CoreData?

 

I read that there really isn't a clean way access MySQL (which I know and prefer, and if I'm wrong about this, please tell me).

 

I am not sure what you mean by "clean", but I would assume you could at least use NSTask to access MySQL. If performance is not critical that should be fine (that is, if for some reason you refuse to just use CoreData like you are supposed to).

 

I want to do possibly a web interface to it down the line which is why I mentioned MySQL. This means a remote server that hosts the database and my osx application could manipulate data on that server. I also read that there is some sort of SQLite and PostgreSQL support. I'm not familiar with these technologies.

 

I'm just looking on suggestions on what the easiest route would be, or the most practical for what I'm wanting to do.

 

As soon as you start talking about a web interface, I think you need to be considering Ruby on Rails instead of Cocoa (as I take "web interface" to mean browser interface, if you merely talking about a distributed application and having a Cocoa client access a Cocoa server then there is no need to consider Rails).

 

I think you need to decide whether this application is going to have a web interface or not before proceeding.

Share this post


Link to post
Share on other sites
I'm trying to develop a personal management application using Cocoa and I'm looking for a database backend solution. I read that there really isn't a clean way access MySQL (which I know and prefer, and if I'm wrong about this, please tell me). I want to do possibly a web interface to it down the line which is why I mentioned MySQL. This means a remote server that hosts the database and my osx application could manipulate data on that server. I also read that there is some sort of SQLite and PostgreSQL support. I'm not familiar with these technologies.

 

I'm just looking on suggestions on what the easiest route would be, or the most practical for what I'm wanting to do.

 

Thanks.

 

PostgreSQL or SQLite, because of the licenses, and the fact that both supports transaction.

MySQL may require a commercial license, and you'd have tough time with concurrency control.

 

-- TG

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Recently Browsing   0 members

    No registered users viewing this page.

×