Re: Databasing and Cocoa
Re: Databasing and Cocoa
- Subject: Re: Databasing and Cocoa
- From: p3consulting <email@hidden>
- Date: Sat, 28 Feb 2004 09:09:07 +0100
>
I would write the classes first, then set up the database to store the
>
information represented by the classes. I'd wait until the last
>
possible moment before setting up the database since databases can be
>
tough to change.
>
>
I'd also think really hard about whether a SQL-based relational
>
database is necessary. For example, could you just save all your data
>
in a file when quitting and reload it all into RAM as objects when
>
starting up? A gig of RAM is only $200.
>
>
I have been writing SQL-based relational database-backed apps
>
professionally for a little over 10 years now, and my opinion is that
>
while they are necessary for certain projects, they are sometimes
>
(often?) used when something simpler and easier to change would have
>
worked just as well or even better.
>
>
In the original post it was stated
>
We are the visual effects department that work a number of TV shows,
>
and we need our database to grow as we take on bigger and more
>
complicated projects.
if "complicated" means multi-user and possible local and remote access,
a db system could be necessary
Regarding mySQL, keep an eye on what DB features you need and check if
they are or will be available in version 4, since it seems that version
5 will have a different licensing scheme.
Among important features a business application may need and that are
or will be implemented in 5 and apparently not in 4:
(copy/pasted from mysql.org site)
Support for stored procedures was added in version 5.0, and support for
triggers will be added in version 5.1
...
Views are currently scheduled to be supported in version 5.1.
Reasons why I currently prefer PostgreSQL for vertical solutions
development, even if I use mySQL for some Web site development
Pascal Pochet
email@hidden
_______________________________________________
cocoa-dev mailing list | email@hidden
Help/Unsubscribe/Archives:
http://www.lists.apple.com/mailman/listinfo/cocoa-dev
Do not post admin requests to the list. They will be ignored.