Re: Invoice program made in Objective c/Cocoa
Re: Invoice program made in Objective c/Cocoa
- Subject: Re: Invoice program made in Objective c/Cocoa
- From: Robert Claeson <email@hidden>
- Date: Fri, 15 May 2009 16:45:49 +0100
On 15 May 2009, at 16:16, Ilan Volow wrote:
I'm working on a Cocoa-based ERP that uses PostgeSQL on the backend.
Invoicing is among the things it does. Yes, it is possible to do
write such a thing, though you will have to work out a preferred way
to (un)persist your data objects to/from the database (or use
someone else's framework that does this). Apple hasn't addressed the
need for Cocoa to interact with database servers, so you'll be on
your own in this dept.
On the topic of databases, working with high-volume, highly
transactional systems is one of the things I've done in the past and
while persistence frameworks is great for single user and small
dataset applications (speed of development, ease of use etc) I would
never go through one in a large volume, multi-user system where high
performance is required.
What I've found works the best (and Oracle and DB2 DBAs tend to agree,
although my view is a bit unorthodox among developers) is to treat the
database as a black box data storage unit with a procedural API. Eg
the application never get to see the actual database schema. That is
internal to the database and all permissions are revoked from users to
use the tables directly. The API is made up of stored procedures that
accesses the database in the best possible manner and returns the data
to the application. This way, a good DBA (or the development team) can
change the internal workings of the database for best performance as
much as they like as long as the API remains the same. This is also
great for allowing third party developers access to the database.
Without such an API, there is very little separation of concepts and
the application knows too much about the internal workings of the
database.
Robert
_______________________________________________
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