http://www.sugarcrm.com/forums/showthread.php?t=14851Q: We're just starting to look at open source CRM systems and are focusing our attention on SugarCRM and ............ We're not experts in PHP but it seems that a system such as ........... which is ASP.NET will eventually surpass SugarCRM given that it has immediate access to any .NET enhancements. How confident are you that PHP provides the best platform going forward?
LOL - SplendidCRM must be a threat to SugarCRM on the MS platform ;)
The thing that amuses me most is how slow SugarCRM is at adopting standards and best practices.
Back in SugarCRM 1.0, they used integers as primary keys in an enterprise product. Clearly the original architect did not have any experience developing an enterprise product. And now, almost two years later, they are just getting around to supporting UTF-8. I can even swear that I saw a version of SugarCRM that changed database records anytime someone changed their timezone.
I have not checked, but they probably still store their user preferences in PHP array format when XML is the obvious choice. The worst part is that we had to read the PHP array so that SplendidCRM could support the import of an existing MySQL database.
Then there was the version that used complex PNG images everywhere that required a special stylesheet hack due to a bug in Internet Explorer. Thankfully, the PNG images did not last long.
And don't get me started on that whole "Microsoft partnership" thing. Are their developers so inexperienced that they cannot figure out how to develop against the easiest of all the database platforms? In my opinion, Oracle is the most difficult database platform to support. MySQL is kind of painful in the way that it concatenates strings, but otherwise the port went quickly. DB2 took the least amount of time to support even though we had almost no expierience with the platform. We would add Sybase to the list of supported platforms if they would simply fix a bug in their ADO.NET provider.
Actually, I do understand the "Microsoft partnership" thing; it is all about marketing. I prefer to quote a popular movie, "build it and they will come".
Sorry for sounding like a newbie (maybe I am ?), but why are INTs not acceptable as primary keys?
Thx.