Re: Database
Re: Database
- Subject: Re: Database
- From: Ted Thibodeau Jr <email@hidden>
- Date: Tue, 25 Jan 2005 09:27:00 -0500
* Carlos Coutinho [2005/01/24 11:25 PM +0000] wrote:
> Hi,
> What's the best applications and solutions that I can use to
> develop the application I'm describing next.
>
> I manage a Printing Industry and I need a software that can
> calculate all my customer costum order's costs. Starting from
> that I'll have to manage my stocks, save all the productiond
> times, billing, contacts, etc; everything to run my company
> effeciantly.
>
> It will mange Gb of data (including pdf's if it can) and will
> be used simultaneusly by 10-15 people.
>
> Can I use a Cocoa Objective-C application that connects to
> a database like MySQL, for example? I start reading something
> about webObjects but I found it very deep, with a too learning
> curve too steep!
>
> What's the suggestion using Xcode or any other Apple free tools?
Keeping all the other suggestions made on the list in mind, I would
strongly suggest using a database-agnostic API and command set,
like ODBC and SQL....
Mac OS X has shipped with the iODBC headers and runtime dylibs since
Jaguar, and a set of Frameworks has been available in the full SDK
from http://www.iodbc.org/ or http://www.openlinksw.com/ as well.
(For reasons which pass understanding, Apple didn't choose to include
the full kit, which OpenLink provided to them, and only bundled the
dylibs + headers. Further confusing the issue and the world of
users and developers, iODBC 3.0.6, which has been outdated since
before Jaguar shipped, was the version chosen -- and remains the
version Apple ships. iODBC 3.51.2 is the current build available
from the download sites for Mac OS X, with 3.52.1 coming shortly
as we gradually update builds for all platforms. If you work with
ODBC at all, or with tools which work with ODBC, please let Apple
know that you'd like to have the latest kit in both Panther and
Tiger environments!)
By using such an agnostic API, which is also cross-platform, you
can build your application once, and use it long-term, recompiling
to get some platform benefits, but otherwise not worrying about the
newest versions of databases or other things.
If you use generic SQL as much as possible -- avoiding DBMS-specific
calls as are found in Microsoft/Sybase Transact-SQL or MySQL or any
of the other DBMS engines -- you can then use your solution with
whichever DBMS makes the most sense as you go -- and if your needs
outgrow MySQL or PostgreSQL (the most common free DBMS engines),
you can easily migrate to Oracle, Sybase, OpenLink Virtuoso, etc.
When you evaluate DBMS engines, you will need to make sure that
they support things like BLOB and CLOB storage (for your PDF, jpg,
gif, and other files), probably Unicode (if you do any international
work), and support the level of transactions you will have -- which
is often greater than you think, on first blush.
There are other elements to be considered, and this is a pretty deep
space to wade into -- you're looking at building something which has
been built by many others, and sells for many thousands of dollars
in the industry.
Good luck,
Ted
--
A: Yes. http://learn.to/attribute
| Q: Are you sure?
| | A: Because it reverses the logical flow of conversation.
| | | Q: Why is top posting frowned upon?
Ted Thibodeau, Jr. // voice +1-781-273-0900 x32
Evangelism & Support // mailto:email@hidden
OpenLink Software, Inc. // http://www.openlinksw.com/
http://www.openlinksw.com/weblogs/uda/
OpenLink Blogs http://www.openlinksw.com/weblogs/virtuoso/
http://www.openlinksw.com/blog/~kidehen/
Universal Data Access and Virtual Database Technology Providers
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Cocoa-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden
| References: | |
| | >Database (From: Carlos Coutinho <email@hidden>) |