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 ------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV _______________________________________________ Ledger-smb-devel mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/ledger-smb-devel
