Re: Cocoa Newbie & MySQL
Re: Cocoa Newbie & MySQL
- Subject: Re: Cocoa Newbie & MySQL
- From: Dru Satori <email@hidden>
- Date: Thu, 29 Apr 2010 13:12:35 -0400
Yes, Marko's BaseTen is excellent, and the PostgreSQL support for the Mac as a platform is quite good. The only downside really, is that there is an outstanding issue with regards to collation in certain locales on BSD based systems, of which OS X is one, so long as you are us_EN and UTF-8, you'll be fine, but there are issues with the us_FR and a few others.
Andy 'Dru' Satori
On Apr 29, 2010, at 12:53 PM, Joshua Tidsbury <email@hidden> wrote:
> Flavio,
>> Well... That's a good enough reason. Driving that Sun stuff through exec() and command-line utilities should be extremely painful and hard to maintain in the future.
>>
> Indeed, I did consider that for about 5 seconds, then smacked myself in the forehead...
>> Do you really need to use MySQL -- or any other full-fledged RDBMS? I am not sure how big will be your dataset, how often it will be updated and how many users you'll have, so I can't help that much.
>>
> We're looking at about 100 users (for now), and a dataset starting at about 3 million rows. This will grow steadily through the years though, at a rate of about 3+ million rows per year.
>> If you really need an RDBMS, you could consider PostgreSQL and the BaseTen framework (basetenframework.org). It feels a lot like Core Data, but for Postgres.
>>
> I actually had my head buried in the sand solely thinking of MySQL, only for sake of familiarity. But this framework looks fantastic - I'll play around with it and see what I can come up with. And I have little doubt that PostgreSQL has plenty of power to pull this sort of project off.
>> Why do we, developers, love challenges? ;)
>>
> The question of the ages :)
>
> Take care,
> Josh_______________________________________________
>
> Cocoa-dev mailing list (email@hidden)
>
> Please do not post admin requests or moderator comments to the list.
> Contact the moderators at cocoa-dev-admins(at)lists.apple.com
>
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
>
_______________________________________________
Cocoa-dev mailing list (email@hidden)
Please do not post admin requests or moderator comments to the list.
Contact the moderators at cocoa-dev-admins(at)lists.apple.com
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden