Re: sourceforge Project of the Month - compiere

HI Matteo,

I seem to remember some discussion to the effect that MYSQL is not fully 
ANSI SQL compliant.  PostgresSQL, is, again as I remember the discussions, 
compliant.  One of our applications runs on PostgresSQL and it seems fine 
(then so do those that run on MYSQL - it is not exactly a stressful 
environment).

Oracle seems to be the standard (tm) in this area.


At 02:02 AM 26/02/2004 -0800, you wrote:
>here a nice article:
>
>http://sourceforge.net/potm/potm-2004-02.php
>
>Becouse i'm interested in see if they will support
>other database (My SQL) I quote this part:
>
>"
>Where do you see your project going?
>
>Database independence is a big issue. We are currently
>based on Oracle to provide the 100% availability
>required for the backbone of your business. Also, when
>we started, application servers were less than
>reliable and functionality in the database still
>provided the highest performance. Compiere is easy to
>port to IBM's DB/2, but the demand is more for Open
>Source databases. We negotiated a special license with
>Oracle and removed the usual cost factor for an Oracle
>implementation with our support contract, which
>includes all licenses for just US$1,500.
>
>The next generation of our core engine will be
>database-independent and just require ANSI SQL, views,
>and functions. The Compiere application server (based
>on JBoss) has been proven stable enough to be used in
>small business environments with no IT staff. We are
>using database independence to improve our core engine
>to completely implement the OMG workflow facility.
>With that, we gain higher flexibility (workflow is
>usually just an add-on in ERP) and performance
>benefits. It's then a user decision what level of
>stability and performance they require from a
>database.
>"
>
>_______________________________________________
>blug-tech mailing list
>[email protected]
>http://list.beijinglug.org/cgi-bin/mailman/listinfo/blug-tech



Regards,

Graham Brown