Excellent to implement solutions quickly
Use Cases and Deployment Scope
How we use: In different line of businesses with CBRE, we use MS SharePoint / SQL as a central repository to hold datafiles, or structured data in the form of MS SharePoint / SQL Lists. Business problem: Datafiles collaboration among users, Low code No Code Automation usecases developement. Scope of use cases: Most of the time they are financial processes.
Pros
- Scalable: I like MS SharePoint / SQL as it comes with builtin scalability when concurrent users are reading or writing even a single file
- Quick app development: Using MS SharePoint / SQL lists we can quickly spin up a web applications for general purpose specifically the ones that require users to collaborate
- Integration: We have well documented API that provide us a way to quickly integrate them with any applications
Cons
- Missing functionality: We dont any native options to deal with big data
- Limited scope for customisation: We have very limited scope to customise the MS SharePoint / SQL as a whole, and that too requires you to be a full fledged developer
- User exprience: There is a lot of room for ui/ux, such as there is no full list search option
Likelihood to Recommend
Well Suited: 1. if you already have the team of developers with the background of UIUX and server side, then adding MS SharePoint / SQL to your text type would be a great choice. 2. if the use cases you have do not require ACID Compliance 3. if the use cases that you have Do not do anything with big data. Less Suited: Vice versa of above mentioned points