mysql question
mysql question
- Subject: mysql question
- From: Jeff Biggus <email@hidden>
- Date: Thu, 18 Sep 2003 23:08:08 -0500
I'm wondering if anyone has any reasons for a Cocoa program not to make
use of MySQL (or PostgreSQL). I have a project which is intended to use
thousands of large text chunks per project (and potentially to open
many projects at the same time). I was thinking of storing the text,
along with some other info, in MySQL, since only a small number of
items will ever be used / in memory at any one time. I'm assuming this
would help with speed, but have no benchmarks to fall back on.
Pros seem to be: Speed, other programs can make use of information in
database (not a priority here), info can be backed up along with other
databases during regular db backups, can easily edit information with
standard mysql tools.
Cons seem to be: Information stored in two distinct places (mysql and
the program's own files), user has to install mysql, data not easily
moved from computer to computer or user to user.
Is there more I should be taking into account? Is there a good argument
to be made that Cocoa apps don't have a need to use a database if the
information need not be shared by other applications or across networks?
I was told to check out in-process databases like Metakit, SQLite or
BerkeleyDB, but haven't had time yet.
Thanks,
-Jeff
_______________________________________________
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.