Compiere on Postgres/MySQL
Tim Griffin writes " Compiere (arguably the most comprehensive open source ERP/CRM solution) has recently taken an interesting approach to harnessing community support for adding database independence to their product (currently it requires Oracle). They are taking pledged donations to help get the ball
rolling on the project
Certainly there are many feature requests in OSS I'd gladly pledge towards. Is this feature pledging a sustainability model for opensource developers/companies? Other examples, such as
Blender3d which raised 100,000 EUR in 7 weeks, point in that direction. Perhaps in the future we may even see these pledge requests
linked within the GUI itself? "
I didn't know what this was, so from their webpage:
What are ERP Software Solutions? ERP stands for Enterprise Resource Planning and is the software to support your entire business processes. ERP Software Solutions typically consists of modules such as Marketing and Sales, Field Service, Production, Inventory Control, Procurement, Distribution, Human Resources, Finance and Accounting.
What are CRM Software Solutions? CRM stands for Customer Relationship Management and is the software to support your business process to find, get and retain customers. CRM Software Solutions typically consist of modules such as Sales Force Automation, Call Management, Self Service.
PostgreSQL is more feature rich than MySQL. Whether or not it's more "advanced" depends on what you are using it for.
And no, I know MySQL has transactions through InnoDB, however MySQL doesn't have stored procedures, which also means no triggers. PostgreSQL not only has procedures but it has inheritance, overloading, and support for pl/PHP, pl/Perl, pl/Python and a host of other languages you can write stored procedures in.
Theres a bunch of differences between MySQL and PostgreSQL, neither of which make either one better overall. It's a matter of the application of each which determines if one is better.
..There's a-dooin's a-transpirin'
Really? Have you tried setting up postgresql? The version in RH9 was just as easy to set up as mysql, so if that's a PITA, you're not going to believe what you need to do to get oracle to work ;)