Re: Cheap (or open source) RDB for Windows compatible with WO ...

Kieran Kelleher <[email protected]> Tue, 24 Feb 2004 12:19:25 -0500
Newsgroups gmane.comp.web.webobjects.devel,gmane.comp.web.webobjects.eof
Message-ID <[email protected]>
Ultimately, the decision is yours, but........

Your client wants open source "free". So, there are only two choices in 
your list: PostGreSQL and MySQL. Out of the two, MySQL is better 
supported than PostGreSQL and is even a "qualified" database for use 
with WO. Also, MySQL runs on all popular platforms.

So far, I like MySQL, it's free, very fast, and its "shortcomings" may 
indeed be features that you do not need when the sophisticated EOF in 
WO is controlling it with standard ANSI SQL 92.

Besides, it costs NOTHING to download it and try it out today! 
(http://www.mysql.com)

... anyway, just my recommendation/opinion..... your customer will 
thank you for it in the end and maybe you can make more money since he 
does not have to break out the savings account for a big fat user-based 
license!

G'day, Kieran
____________________________________
OS X 10.3.2 /  WO 5.2.2 / MySQL 4.0.16


On Feb 23, 2004, at 10:39 AM, Ashley Aitken wrote:

> Howdy All,
>
> I have a customer who is determined to deploy WebObjects 5.2 on Windows
> whilst spending as little as possible on a database (MS SQL Server is
> too expensive, and thus is Oracle ...).
>
> I've considered a few options:
>
> FrontBase: my first choice, but Windows support is dependent on having
> WebObjects and I don't want to constrain their use of the database.
>
> OpenBase: a possibility, but the cheap license is throttled (this may 
> be
> ok) and limited to 10 users (this should definitely be ok).
>
> SyBase: maybe, I seem to remember there was a free older version of
> Sybase available, but I have not used it and I am unsure of drivers, WO
> compatibility etc.
>
> PostgreSQL: my preferred open source alternative, but currently not
> available natively for Windows for free (needs *nix emulation)
>
> MySQL: possible, but I have an aversion to it due mostly to some of its
> peculiarities and perceived short-comings (that are argued over often)
>
> I am looking for a database with good WO compatability (eg JDBC 
> drivers,
> EOModeler plugin) and the client is looking for an open source or free
> option
>
> Any recommendations from the above, or others?
>
> Thanks in advance,
> Ashley Aitken.
> Running Code Productions.
>
>
> _______________________________________________
> EOF mailing list
> [email protected]
> http://www.omnigroup.com/mailman/listinfo/eof
>