Slashdot Mirror
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 was discussing a similar problem with some musicians the other day: how to pay for creative work?
Our solution was sponsoring, in one way or another: support from wealthier individuals or firms, getting advertising and honorable mentions in return.
The basis was the way traditional musicians are paid in Africa, which is by singing the praises of whoever gives them money. Since such musicians (like griots) are also respected on who is who in the community, their voices are sometimes worth a lot.
In software, why not something along the lines of "such and such paid for this feature", an eternal mention of one's contribution to the project. It worked for Bach and Mozart, why not for OSS today?
Ceci n'est pas une signature
I'm taking a similar approach to employment independence. For only a few dollars a month, you could help me sit on the couch every day.
Life is the leading cause of death in America.
The claim was made this 'port' would have aviablity in Qt 4 of 2003.
t ml page:
No sign of that happening.
Some other data for the slashdot readers.
Other 'claims' from the http://www.compiere.org/technology/independence.h
"but you can get an invoice"
and
"As a proof of concept, ComPiere plans to provide a porting kit for one database to be selected yet."
Now I "donated" over $100 on this last year for a PostgreSQL port.
1) I have not gotten a invoice.
2) Phone calls to Mr. Janke have not been returned to answer the question 'what is the status of the port'
3) Now what I "donated money" for - a PostgreSQL port - may not be done, and instead a MySQL port may be done instead?
As you can guess, I'm "Happy" about the progress thus far.
On the mailing list some people have talked about a PostgreSQL fork of his code and Mr. Janke had made mention of some PostgreSQL work done 2 years ago, but to my knowledge, none of that code is 'out there' for the public to see.
At present, the development environment is Jbuilder...perhaps a seperate slashdotting can happen and convice them to move to Eclipse?
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'
Porting the table structure is not the same as, oh, porting the actual program so that it reads and writes to PostgreSQL.
What exactly do you mean by giving us a database configuration file, and then saying you've ported compiere to postgresql? Where are the modified java files?
-Adam
Compiere has been hounded for a postgresql database port for a long time now.
They have had a committee to oversee it, they have had numerous people (of varying skill) offer to contribute, and they have had a stunning lack of progress.
Their opinion has not changed much, which is, "If you have the Enterprise needing such software, Oracle is nothing more than a drop in the bucket" Eventually, they complained that it would be a finiancial burden to make the port happen. That's when someone indicated a "donation" web page should be set up (as a compromise).
I see the donation webpage as nothing more than an attempt to keep the port from never happening, by addressing the one point of money (raised when it became obovious that many wanted the feature, but few would donate time or money)
Stored procs etc. are fantastic if you know what platform you're building for (and that target platform has been set in stone).
... well, it's a no brainer.
...
I'm building an in-house piece of software in this manner, and stored procs alone saved me LOTS of work - particularly with respect to security checking. All the necessary checking is done automatically when the user logs into the database. Furthermore, users can be assigned roles within the system automatically as a knock-on effect.
I thought about trying to go database independant for a while, but the sheer amount of time saved for an application with a 95% chance of always running on a particular platform with a particular RDBMS compared to doing it all in the code
However neat it is, cross-platform isn't always The Way.
But I completely agree with you with respect to open source projects and db independance. That said, this project hasn't always been open source right? Perhaps that's half an answer as to why they built it the way they did
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 ;)
I don't know if you have EVER use an enterprise applicaiton before. Even if it IS just select/inserts/deletes for basic GL/AP/AR applications you are talking about people, systems and components requiring gigs to terrabytes of data and hundreds if not THOUSANDS of concurrent users.
:)
MySQL can't handle flash back transactions, doesn't support load balancing, hot site, and paralell or clustered transactions. I need all of these to support an enterprise environment!
Sure compiere may be small, but it needs a powerfull database. It needs the features of an enterprise database oh which there isn't an open source solution to. I wouldn't dare want to recover a mysql or postgress 1.2 terrabyte erp system.
Oracle RDBMS is an amazing product. Overly capable and getting easier to use as the releases pile on. You pay for the mindset that you have a multi billion dollar company supporting you.
That brings me to the question of why use Compiere at all on anything but oracle and is there a demand for an ERP system that doesn't use a commercially supported system as NO vendor in there right mind would want to support a product they didn't develop or that didn't have its own superb support channels to begin with.
oh well. You have to remember that big business is alot different than hosting a small website or cddb database on your average linux pc
you're not going to believe what you need to do to get oracle to work ;)
:-)
Bah, that's easy - I just email our DBA and ask her to do it
It's official. Most of you are morons.