[olug] Looking for Open Source alternatives

[Will Langford]

If you're just doing a simple select from a table, MySQL... sure...

If you start needing subselects, views, ACID compliance, more
extensibility/programability, etc.... PgSQL all the way :).

I will note that it appears MySQL and PgSQL ODBC drivers both appear have
problems with Microsoft SQL four-part-naming conventions.  In a recent
linked-server situation, I had to do all of my queries via OPENQUERY() and
usp_executesql().

-Will

On 11/8/06, Phil Brammer <olug at wjjeep.com> wrote:
>
> On Tue, Nov 07, 2006 at 12:58:03PM -0800, Joe Gulizia wrote:
> > Oracle DBMS
>
> It "depends."
>
> MySQL for lightweight stuff.
> PostgreSQL for more heavyweight stuff when ACID compliance is desired, for
> instance.
> _______________________________________________
> OLUG mailing list
> OLUG at olug.org
> http://lists.olug.org/mailman/listinfo/olug
>