topic Re: NOSQL support in Alfresco Archive

NOSQL support

mchaia — Fri, 17 Jun 2011 14:56:34 GMT

Hi all,I know that a workflow engine relies on a transactional relational database to maintain state, putting focus on Consistency (in terms of "CAP theorem").Taking into account performance and horizontal scalability, is it possible to think about a NOSQL database for workflow engine repository? (l

Re: NOSQL support

jbarrez — Mon, 20 Jun 2011 07:32:17 GMT

Hi Martin, internally we are experimenting with nosql, but don't expect anything soon in the open source version.

But I think your assumption is wrong: a 'regular' database can cope with huge loads. You would need a massive amount of users (think Facebook, Twitter, etc.), to really justify a nosql backend.

Re: NOSQL support

mchaia — Mon, 20 Jun 2011 15:40:03 GMT

Thanks for your answer Joram.
We are certainly NOT Facebook or Twitter… but we are on our way to be so…
Anyway, your answer makes me feel more confident about this subject.
We will give Activiti a serious try in our Production environment.
Thanks again!!