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? "
Voila. Adware.
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
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