Re: Database applications
Re: Database applications
- Subject: Re: Database applications
- From: "Ted Petrosky" <email@hidden>
- Date: Sun, 26 May 2002 10:10:01 -0400
I have been using Postgresql for about 2 years now. My first interface was with
Realbasic. I sometimes question my own sanity for working so hard to try to
use PB and cocoa. But the office I work at is 95% macs so...
If you are looking for a simple cross platform (mac and windows) interface to
an RDBMS. I would recommend Realbasic. Remember, you are only doing
the interface and any referencial integrety stuff can be done in the app or the
backend. I prefer to keep the referencial stuff in the app so I could easily switch
database backends and not have a problem with proprietary routines.
If you are a C, C++, obj-C++ programmer, the c class libraries are available
for you to program against. Whether postgresql or mysql. As a matter of fact
you can find C++ libraries by third parties for postgresql.
I can tell you that if speed is an issure, PB is the way. I have a DB with about
6000 rows (a job tracker). If I do a select for all the jobs rows, it take about a
full 2 minutes from Realbasic. The same query from PB takes 8 seconds. But
on the upside, Realbasic was 'real easy' to do.
Oh, and BTW, my postgresql setup with the realbasic front ends has never, in
the two years of operation, been down. Even for data backup (done every two
days).
JM2".
If you are looking for information about the RDBMSs. There is a lot of hype out
there. I settled on postgresql because of transaction support, better support
for SQL99 joins. And in general better support for 'standards' SQL. I took the
front end apps that I wrote and ran them against Oracle. I did not need to
change a line of code (only the access to the DB). Mysql choked on the joins
and transactions.
Ted
-----Original Message-----
From: Steven Woodward <email@hidden>
To: email@hidden
Date: Sun, 26 May 2002 07:41:18 -0400
Subject: Database applications
>
Hi all! I'm looking at developing a database app in Cocoa, and just
>
wanted some input as to what my options are. I have looked at a couple
>
of the SQL products out there as well as rolling my own with
>
arrays/dictionaries. The problem with rolling my own is shared data
>
access, the application would be used by a dept. of 4-5 users. The
>
problem as I see it with the SQL options are that their are either no
>
ObjC libraries yet, or they are in alpha stages of development. I just
>
wondered what other folks are using out there for Cocoa database
>
(non-Web) development. Many thanks in advance for any input!
>
>
Steve
>
_______________________________________________
>
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.
_______________________________________________
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.