Question on Databases

By JP_Smith at Wed, Jan 13 2010 11:17am |

I’m moving over from the C#/SQLServer world to programming on a Mac. Are MySQL and PostgreSQL the only 2 database options? Ideally I’d like something relational with trigger and stored procedure support. The closer to SQLServer the better.

And free... Free is good.

Oh and is there any good Objective-C source code examples anywhere for accessing a stored procedure?

Thanks,

JP

‹ OS X benefits on Biomedical Engineering. How to transfer iTunes library between Mac and Windows ›

Comment viewing options

Select your preferred way to display the comments and click "Save settings" to activate your changes.
Fri, 2010-01-15 07:40 — mikecsh

Question on Databases

There are many database options on the Mac. For a good sample have a look at the Operating System Support section of this Wikipedia article:

http://en.wikipedia.org/wiki/Comparison_of_relational_database_management_systems

Of those that I've tried (including MySQL, PostgreSQL, MonoDB, SQLite, Valentina, FileMaker) PostgreSQL is closer to SQLServer (but free).

Sun, 2010-01-17 12:29 — lbland

RE: Question on Databases

hi-

There is an obj-c wrapper (framework) for db work floating around, but I have not used it. ODBC is kinda "built in" to Mac OS X and I prefer that level of programming. My thoughts about stored procedures: Buyer beware. I've had to deal with it, but I never thought of it in terms of transportability - I"ve alway recreated the wheel from scratch. I have a personal preference for MySQL just because it is so easy to compile and install on Mac OS X (meaning I've done it so many times that it is easy) and you can also build the ODBC adapters from scratch too. I use the Microsoft SQL Server pages as a reference for programming ODBC calls on the Mac!

thanks!-

-lance

Wed, 2010-01-20 08:56 — JP_Smith

Thanks! I'll have to try

Thanks!

I'll have to try PostgreSQL. I've been partial to MySQL but I'm a little worried about what will happen to it with the whole Oracle/Sun partnership.