Jump to content
InsanelyMac Forum
  • Announcements

    • Allan

      Solution to create a topic or post.   04/24/2018

      Hello guys. The majority of you are having issues to create a topic or post here. This are a problem with our current theme InsanelyMac.  Now the theme will be the Default IPS. Sorry for any inconvenience.
Table16

Database Backend Suggestions

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
Advertisement
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.



×