SharePoint vs Drupal
Saturday 10 October 2009 at 07:29 am. Used tags: development, difficulty, drupal, sharepoint This is a little biased (he's obviously an open-source LAMP fan; specifically the Drupal CMS) but the points he raises as SharePoint difficulties are similar to the ones we've experienced.Pop over and have a read of Drupal vs SharePoint
We've had ongoing issues, particularly items 1, 2, 3, 4, 6:
1.Setting up a local development environment is difficult and expensive.
We solved (if you can call it that) by just giving admin rights to the dev SharePoint boxes - the catch is that opportunities to customize the environment for a developer decreases moving through Systest, UAT and Production so its very easy for things to get out of synch.
2.Setting up an efficient development/deployment process is cumbersome.
We don't have a fix - apparently you can develop automated deployments from TFS (Team Foundation Server - the successor to Visual Source Safe) for SharePoint but most project managers wouldn't wear the additional expense of a foolproof scripted deployment for a one-off project. So we manually move between environments and every deployment brings with it new and odd problems (often the fix isn't regression tested which means going from UAT into Prod can bring new and unforeseen issue; often not helped by inconsistances from item #1).
3.Theming SharePoint is extremely difficult.
Doing anything thats not out of the box seems to cost a lot of time and money - very little of which seems to be re-usable.
4.Many SharePoint modules (aka webparts) are quirky and don't work as expected.
5.Lists and libraries are quirky and also often do not work as expected.
6.SharePoint is slow and does not give you real access to the database that powers it.
In fact - reinforcing this point - messing with the back-end SQL database will render your SharePoint environment unsupportable. Microsoft patches and hotfixes may just over-write anything you've added above and beyond the standard SharePoint working databases. Without telling you. Nice.
The comment from another developer in the discussion thread is interesting too and nails why the SharePoint push is so strong for IT management in terms of a seamless user experience for their clients:
"I would love to dump sharepoint altogether, but users simply will not accept a detaching, editing, and attaching workflow for documentation management. They simply want to click and go. It wouldn't matter if a drupal site could serve them coffee and cake-- they simply won't stand for the attachment method of document management."
What the article didn't point out is that a growing number of people (particularly the younger generation) write on the web for the web (ie don’t use Word) so the DMS paradigm is becoming less relevant. Check out The prospects of Microsoft Word in the wiki-based world.