Posts
414
Comments
232
Trackbacks
42
June 2011 Entries
SharePoint Lists Vs. Database Tables

I got a question from a developer whether they should use SharePoint lists or database tables to hold the data for his application.  This is a fair question and as a consultant I will start with the standard answer:  It depends.

I will follow up that answer with the standard consultant question: what are you trying to do?  There generally isn’t one answer for any technology choice.  We need to take as many factors into account as possible.  Who will be maintaining the data?  Will the data only be used in your SharePoint application or does it need to be available across the enterprise and used by a multitude of systems?  What standards are already in place for application data?  Are there security concerns for this data?  All of these questions and more need to be answered in order to decide where you should store your data.

SharePoint has come along way since I first started using the 2001 products.  But just because you can use SharePoint lists to hold all your application data doesn’t mean you should.  My general rule is if there is little or no usage of the data outside of your SharePoint application, you don’t need complex table joins and it doesn’t need to be edited by other systems then it is acceptable to use a SharePoint list.  If you go beyond these limits I heavily lean toward using a DBMS.  Could you still use lists outside of these conditions?  Yes, but it will probably cost you more in development time across all of your systems.  Just remember, just because you have a hammer, everything isn’t a nail.

Posted On Wednesday, June 15, 2011 7:21 AM | Comments (2)
June 2011 Chicago Information Technology Architects Group Meeting

Things have been busy and we didn’t have a presentation last month.  This month’s presentation will be on the 29th due to scheduling conflicts with TechNexus. On the schedule this month Carl Franklin will be presenting on scalable internet solutions. Come out and join us for a night of discussion and meet a few of your peers in the process.

Register here.

Posted On Monday, June 13, 2011 9:04 AM | Comments (0)

Tim Murphy

Tim is a Solutions Architect for PSC Group, LLC. He has been an IT consultant since 1999 specializing in Microsoft technologies. Along with running the Chicago Information Technology Architects Group and speaking on Microsoft and architecture topics he was also contributing author on "The Definitive Guide to the Microsoft Enterprise Library".



I review for the O'Reilly Blogger Review Program



Technorati Profile

www.flickr.com
Tag Cloud