alfresco database

Question

How can we extend alfresco database . I need to add new tables for the existing database . Do alfresco supports this ?

thanks in advance, sri..

Answer 1

Well, it is just a database. So you can create as many new tables as you want just like you would in any other database. Obviously Alfresco won't use them because it doesn't know them, but you can query the tables as you like.

Answer 2

I think changing the alfresco db model is never a good solution. Some alfresco upgrades are made using Schema Upgrade Scripts, and that could get messy.

Have you tried to extend the alfresco content model? Alfresco support some data types, allowing you to persist data. The Web Script framework allow you manipulate all your data inside your content model.

If your data is not suitable for a "content model", I think you should create a new database to hold your data.