SplendidCRM Software has followed SugarCRM's lead by adopting the GNU Affero General Public License Version 3 (AGPLv3) for its Community Edition. Although it may seem strange to post this announcement on the SugarCRM forums, our goal here is to catch the attention of the internal SugarCRM developers. This is our first public release that includes the full set of SQL source code, so we thought that it would be a good opportunity to point out something that we believe we do better.
Although SugarCRM and SplendidCRM are very similar in features and appearance, they are two vastly different applications. Whereas SugarCRM tends to keep its data and configuration in PHP files, SplendidCRM tends to keep its data and configuration in data tables inside the database. Both methods have their strengths and their weaknesses, and I'm sure that developers on both camps would extol the virtues of their design until they are blue in the face.
The one requirement that both products share is the need to upgrade any previous version of the database to the current version of the database. This is an area where the Splendid approach seems better. Instead of have separate upgrade files from each prior version to the current, we find it to be much easier to create a single upgrade file that will do everything necessary to upgrade from any prior version. Is it really necessary to create all of the following:
SugarCE Upgrade 5.5.1 to 6.1.0.zip
SugarCE Upgrade 6.0.x to 6.1.0.zip
SugarCE Upgrade 6.1.0RC1 to 6.1.0.zip
SugarCE Upgrade 5.5.0 to 6.0.3.zip
SugarCE Upgrade 5.5.1 to 6.0.3.zip
SugarCE Upgrade 6.0.0RC1 to 6.0.0.zip
SugarCE Upgrade 6.0.x to 6.0.3.zip
SugarCE Upgrade 5.5.1 to 5.5.4.zip
SugarCE Upgrade 5.5.2 to 5.5.4.zip
SugarCE Upgrade 5.5.3 to 5.5.4.zip
SugarCE Upgrade 5.2.0 to 5.5.1.zip
SugarCE Upgrade 5.5.0 to 5.5.1.zip
SugarCE Upgrade 5.5.1RC to 5.5.1.zip
We encourage the SugarCRM developers to take a look at our SQL Scripts folder to see how we manage 150 tables, 46 functions, 385 views, 593 procedures and hundreds of data files. We logically separate the content of each SQL file and we use a Build.bat file to create a single Build.sql file that can be used to upgrade any previous version to the current database schema.
Paul Rony
SplendidCRM Software, Inc.


LinkBack URL
About LinkBacks



Reply With Quote

Bookmarks