Re: postgre-sql to mysql translation?

[Jason Rodrigues <..hidden..>]

On Saturday 07 October 2006 18:20, m o wrote:
> here's a suggestion . . . ever think of porting this to mysql? with the
> rise of crm's like sugarcrm, the need for a mysql-based accounting program
> has never been greater. sure, we can save the data from mysql to
> postgre-sql, but it seems in inelegant solution. a shift to mysql would
> make this program even more mainstream. just a suggestion . . . thanks for
> reading.

Mysql just doesn't support the data integrity controls [yet] that we're 
demanding for our system.  Mysql is getting there, but PostgreSQL is there 
*now*. (and has been for quite some time)

The database's job is to not only store data, but guarantee it's integrity and 
stability. Sure, it's possible to do these checks in a middle tier, as many 
mysql apps are prone to do -- but can you be sure that only one application 
will ever be accessing that database?

We want to be able to connect 3rd party applications, scripts, and utilities 
directly into the LedgerSMB database.  With the integrity controls  we're 
adding to the schema (that mysql doesn't support yet), we will be able to 
guarantee that the data in the database will be accurate, no matter how you 
connect to it.

Jason